EODL_DLGT_MAP_V

(SQL View)
 Index Back

AdHoc Sal Chg - Pending Txn Vw

This view is intended to select all rows that are in the approval process that have not yet reached final approval as well as the associated Approval Process Id

SELECT A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , X.TRANSACTION_NAME , X.EODL_TRAN_ALLOWED , A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , A.FROM_DATE , A.Transaction_Nbr , A.TO_DATE , A.EODL_END_DAY_IND , X.ORIGINATORID , U.EOAWSTEP_STATUS , S.EOAWPRCS_ID , S.EOAWDEFN_ID , A.FROM_DATE , U.OPRID , U.EOAWORIG_OPRID , %DatePart(U.DTTM_CREATED) , S.EOAWTHREAD_ID , U.EOAWDTTM_COMPLETE , X.EOAWREQUESTOR_ID , X.EOAWTHREAD_STATUS , X.EOAWDTTM_MODIFIED , C.DESCR FROM PS_EODL_APPR_XREF X , PS_EODL_DELEGATION A , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_EODL_TXN_HDR C WHERE X.EODL_DELEGATOR_OID = A.EODL_DELEGATOR_OID AND X.EODL_DELEGATOR_RCD = A.EODL_DELEGATOR_RCD AND X.EODL_PROXY_OID = A.EODL_PROXY_OID AND X.TRANSACTION_NAME IN ( SELECT A1.TRANSACTION_NAME FROM PS_EODL_DELEGATION A1 WHERE A1.EODL_DELEGATOR_OID = A.EODL_DELEGATOR_OID AND A1.EODL_DELEGATOR_RCD = A.EODL_DELEGATOR_RCD AND A1.FROM_DATE = A.FROM_DATE AND A1.Transaction_Nbr = A.Transaction_Nbr) AND X.FROM_DATE = A.FROM_DATE AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND A.TRANSACTION_NAME = C.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = C.EODL_TRAN_ALLOWED

  • Related Language Record: EODL_DLGT_MAPLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODL_DELEGATOR_OID Character(30) VARCHAR2(30) NOT NULL Delegator User Id
    2 EODL_DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number
    3 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    4 EODL_TRAN_ALLOWED Character(1) VARCHAR2(1) NOT NULL Stores the Transaction Type for every HCM transaction registered in the Delegation Framework. The type can be either Approve or Initiate.
    A=Approve
    I=Initiate
    5 EODL_TRAN_NAME_DTL Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    6 EODL_TRAN_ALLOWED2 Character(1) VARCHAR2(1) NOT NULL Stores the Transaction Type for every HCM transaction registered in the Delegation Framework. The type can be either Approve or Initiate.
    7 FROM_DATE Date(10) DATE From Date
    8 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
    9 TO_DATE Date(10) DATE Latest Date to be sent to PYR
    10 EODL_END_DAY_IND Character(1) VARCHAR2(1) NOT NULL End Absence Day

    Y/N Table Edit

    11 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    12 EOAWSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Step Instance Status
    A=Approved
    B=Pushed back
    C=Auto Approved
    D=Denied
    E=Administrator denied
    F=Deleted
    G=Bypassed
    H=On Hold
    I=No Action Taken
    K=Skipped
    L=Terminated
    M=Administrator approved
    N=Not Active
    P=Pending
    R=No longer in role
    T=Terminated
    U=Auto approved
    X=Deleted
    Z=Pending Denial
    13 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
    14 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID
    15 EFFDT Date(10) DATE Effective Date
    16 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    17 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
    18 EOAWSTART_DT Date(10) DATE Start Date
    19 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
    20 EOAWDTTM_COMPLETE DateTime(26) TIMESTAMP Date/Time Completed
    21 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
    22 EOAWTHREAD_STATUS Character(1) VARCHAR2(1) NOT NULL Thread Status
    A=Approved
    C=Complete
    D=Denied
    E=Pending Denial
    H=Hard Deny
    I=Initial
    N=Not Active
    P=Pending
    S=Awaiting Further Approvals
    T=Terminated
    X=Suspended/Pending Denial
    23 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    24 DESCR Character(30) VARCHAR2(30) NOT NULL Description