RTBL_MORE_VW

(SQL View)
 Index Back

SELECT SCE.SCE_ID , GRP.SETID , GRP.PROCESS_GROUP ,GRP.VERSION_GRP ,GRP.DESCR ,GRP.DEPLOYED FROM PS_ALLOC_GROUP_TBL GRP , PS_RTBL_SCENARIO SCE WHERE GRP.EFF_STATUS = 'A' AND GRP.EFFDT = ( SELECT MAX(GRP1.EFFDT) FROM PS_ALLOC_GROUP_TBL GRP1 WHERE GRP1.SETID = GRP.SETID AND GRP1.PROCESS_GROUP = GRP.PROCESS_GROUP AND GRP1.VERSION_GRP = GRP.VERSION_GRP AND GRP1.EFF_STATUS = 'A' AND GRP1.EFFDT <= SCE.ASOFDATE2)

  • Parent record: RTBL_SCENARIO

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    3 PROCESS_GROUP Character(10) VARCHAR2(10) NOT NULL Process Group
    4 VERSION_GRP Number(3,0) SMALLINT NOT NULL Group Version
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DEPLOYED Character(1) VARCHAR2(1) NOT NULL Identify whether an element has been deployed or not.
    N=No
    Y=Yes