HR_I9_AWEDF_LVW

(SQL View)
 Index Back

RW AWE Processes

Get the list of available HR process IDs.

SELECT TXN.EOAWPRCS_ID , PRCS.EOAWDEFN_ID ,LNG.LANGUAGE_CD , PRCS.DESCR FROM PS_EOAW_TXN TXN , PS_EOAW_PRCS PRCS ,PS_EOAW_PRCS_LNG lng WHERE TXN.EOAWPRCS_ID = PRCS.EOAWPRCS_ID AND prcs.EOAWPRCS_ID=lng.EOAWPRCS_ID

  • Related Language Record for HR_I9_AWEDFN_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description