ALLOC_ALL_VW

(SQL View)
 Index Back

Allocation Steps No Effdt

All Allocation Steps (including Budget Copy ones) without effective-dating. For multiple effective-dated rows, the view will list the one with the latest Effective Date.

SELECT A.SETID , A.PROCESS_STEP , A.DESCR FROM PS_ALLOC_STEP_TBL A WHERE A.VERSION_NUM = 0 AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_ALLOC_STEP_TBL WHERE SETID = A.SETID AND PROCESS_STEP = A.PROCESS_STEP)

  • Related Language Record: ALLC_STP_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    2 PROCESS_STEP Character(10) VARCHAR2(10) NOT NULL Process Step
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description