EODL_TRANS_VW

(SQL View)
 Index Back

EODL Transactions

EODL Delegation and AWE Transactions

SELECT A.TRANSACTION_NAME , A.TRAN_CATEGORY , A.SYSTEM_DATA_FLG , A.DESCR , B.EOAWPRCS_ID , B.DELEGATION_INIT , B.DELEGATION_APPR FROM PS_EO_TRANSACTIONS A , PS_EODL_EO_TXN B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.EOAWPRCS_ID = ' '

  • Related Language Record: EO_TRANS_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    2 TRAN_CATEGORY Character(15) VARCHAR2(15) NOT NULL Transaction Category

    Prompt Table: EO_TRAN_CAT

    3 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: N

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    6 DELEGATION_INIT Character(1) VARCHAR2(1) NOT NULL Delegate Initiation

    Y/N Table Edit

    Default Value: N

    7 DELEGATION_APPR Character(1) VARCHAR2(1) NOT NULL Delegate Approvals

    Y/N Table Edit

    Default Value: N