HR_I9_AWEDFN_VW

(SQL View)
 Index Back

RW AWE Processes

Get the list of available HR process IDs.

SELECT TXN.EOAWPRCS_ID , PRCS.EOAWDEFN_ID , PRCS.DESCR FROM PS_EOAW_TXN TXN , PS_EOAW_PRCS PRCS WHERE TXN.EOAWPRCS_ID = PRCS.EOAWPRCS_ID

  • Related Language Record: HR_I9_AWEDF_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description