EODL_TXNSAWE_VW

(SQL View)
 Index Back

EODL AWE Transactions

Delegation and Approval Workflow Engine Transactions

SELECT A.TRANSACTION_NAME , A.TRAN_CATEGORY , A.SYSTEM_DATA_FLG , A.DESCR , B.EOAWPRCS_ID , B.EODL_SERVICEID , B.DELEGATION_INIT , B.DELEGATION_APPR , B.EODL_COMBINE_PART , B.EODL_LIMIT_DRILLUP FROM PS_EO_TRANSACTIONS A , PS_EODL_EO_TXN B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME AND A.EOAWPRCS_ID <> ' '

  • Related Language Record: EODL_TXNSAWELVW

    • # 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 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

    Prompt Table: EOAW_TXN

    6 EODL_SERVICEID Character(30) VARCHAR2(30) NOT NULL Services ID
    7 DELEGATION_INIT Character(1) VARCHAR2(1) NOT NULL Delegate Initiation

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    9 EODL_COMBINE_PART Character(1) VARCHAR2(1) NOT NULL Combine Partial

    Y/N Table Edit

    Default Value: N

    10 EODL_LIMIT_DRILLUP Character(1) VARCHAR2(1) NOT NULL Limit Drill Up

    Y/N Table Edit

    Default Value: N