HCM_EO_TXN_VW

(SQL View)
 Index Back

HCM Transactions

HCM Delegatiion and AWE Transactions

SELECT A.TRANSACTION_NAME , A.TRAN_CATEGORY , A.SYSTEM_DATA_FLG , A.DESCR , B.EOAWPRCS_ID , B.HR_PTCS_SERVICEID , B.DELEGATION_INIT , B.DELEGATION_APPR , B.HR_COMBINE_PARTIAL , B.HR_DR_LIMIT_DRILUP FROM PS_EO_TRANSACTIONS A , PS_HCM_EO_TXN B WHERE A.TRANSACTION_NAME = B.TRANSACTION_NAME

  • Related Language Record: HCM_EO_TXN_LVW

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

    Prompt Table: EOAW_TXN

    6 HR_PTCS_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 HR_COMBINE_PARTIAL Character(1) VARCHAR2(1) NOT NULL Combine Partial
    10 HR_DR_LIMIT_DRILUP Character(1) VARCHAR2(1) NOT NULL Limit Drill Up