HCDL_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.DELEGATOR_ID , A.DELEGATOR_RCD , X.TRANSACTION_NAME , X.TRANS_ALLOWED , A.TRANSACTION_NAME , A.TRANS_ALLOWED , A.FROM_DATE , A.Transaction_Nbr , A.TO_DATE , A.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_HCDL_APPR_XREF X , PS_HCDL_DELEGATION A , PS_EOAW_STEPINST S , PS_EOAW_USERINST U , PS_HCDL_TXN_HDR C WHERE X.DELEGATOR_ID = A.DELEGATOR_ID AND X.DELEGATOR_RCD = A.DELEGATOR_RCD AND X.TRANSACTION_NAME IN ( SELECT A1.TRANSACTION_NAME FROM PS_HCDL_DELEGATION A1 WHERE A1.DELEGATOR_ID = A.DELEGATOR_ID AND A1.DELEGATOR_RCD = A.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.TRANS_ALLOWED = C.TRANS_ALLOWED

  • Related Language Record: HCDL_DLGT_MAPLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
    2 DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number
    3 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    4 TRANS_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 TRANS_NAME_DTL Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    6 TRANS_ALLOWED_DTL 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
    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 END_DAY_IND Character(1) VARCHAR2(1) NOT NULL End Absence Day
    0=End Day No
    1=End Day Yes
    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
    W=Canceled
    X=Suspended/Pending Denial
    23 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
    24 DESCR Character(30) VARCHAR2(30) NOT NULL Description