HCDL_MYDLGTOR

(SQL View)
 Index Back

My Delegator View

Key by Proxy ID. Use Proxy ID to get all delegators of the proxy.

SELECT A.PROXY_ID , A.DELEGATOR_ID , A.DELEGATOR_RCD , A.TRANSACTION_NAME , A.TRANS_ALLOWED , H.DESCR , T.PNLGRPNAME , A.FROM_DATE , A.TO_DATE , A.END_DAY_IND , A.DELEGATOR_OPRID , A.DLGT_REQ_STATUS , A.DLGT_STATUS , A.NOTIFY_DELEGATOR , NM.NAME_DISPLAY , J.JOBCODE , JC.DESCR , J.SETID_DEPT , J.DEPTID , DEP.DESCR , A.GROUP_SEQ_NUM , A.COMMENTS FROM PS_HCDL_DELEGATION A , PS_HCDL_TXN_HDR H , PS_HCDL_TXN T , PS_JOB J , PS_NAMES NM , PS_JOBCODE_TBL JC , PS_DEPT_TBL DEP WHERE A.TRANSACTION_NAME = H.TRANSACTION_NAME AND A.TRANS_ALLOWED = H.TRANS_ALLOWED AND H.TRANSACTION_NAME = T.TRANSACTION_NAME AND H.TRANS_ALLOWED = T.TRANS_ALLOWED AND T.STATUS = 'A' AND T.EFFDT = ( SELECT MAX(T1.EFFDT) FROM PS_HCDL_TXN T1 WHERE T.TRANSACTION_NAME = T1.TRANSACTION_NAME AND T.TRANS_ALLOWED = T1.TRANS_ALLOWED AND T1.EFFDT <= %CurrentDateIn) AND A.DELEGATOR_ID = J.EMPLID AND A.DELEGATOR_RCD = J.EMPL_RCD AND J.EFFDT = ( SELECT MAX (J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD AND J1.EFFDT <= %CurrentDateIn) AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT = J.EFFDT) AND A.DELEGATOR_ID = NM.EMPLID AND NM.NAME_TYPE = 'PRI' AND NM.EFFDT = ( SELECT MAX(NM1.EFFDT) FROM PS_NAMES NM1 WHERE NM1.EMPLID = NM.EMPLID AND NM1.NAME_TYPE = NM.NAME_TYPE AND NM1.EFFDT <= %CurrentDateIn ) AND J.SETID_JOBCODE = JC.SETID AND J.JOBCODE = JC.JOBCODE AND JC.EFF_STATUS = 'A' AND JC.EFFDT = ( SELECT MAX(JC1.EFFDT) FROM PS_JOBCODE_TBL JC1 WHERE JC1.JOBCODE = JC.JOBCODE AND JC1.SETID = JC.SETID AND JC1.EFFDT <= %CurrentDateIn ) AND J.SETID_DEPT = DEP.SETID AND J.DEPTID = DEP.DEPTID AND DEP.EFFDT = ( SELECT MAX(DEP1.EFFDT) FROM PS_DEPT_TBL DEP1 WHERE DEP1.SETID = DEP.SETID AND DEP1.DEPTID = DEP.DEPTID AND DEP1.EFFDT <= %CurrentDateIn)

  • Related Language Record: HCDL_DLGT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROXY_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
    2 DELEGATOR_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
    3 DELEGATOR_RCD Number(3,0) SMALLINT NOT NULL Delegator Record Number
    4 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    5 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
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name
    8 FROM_DATE Date(10) DATE From Date
    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 DELEGATOR_OPRID Character(30) VARCHAR2(30) NOT NULL Delegator Oprid
    12 DLGT_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Request Status
    A=Accepted
    E=Ended
    J=Rejected
    R=Revoked
    S=Submitted
    13 DLGT_STATUS Character(1) VARCHAR2(1) NOT NULL Delegation Status
    A=Active
    I=Inactive
    14 NOTIFY_DELEGATOR Character(1) VARCHAR2(1) NOT NULL Notify flag
    N=Not Notify Delegator
    Y=Notify Delegator
    15 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
    16 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    17 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title
    18 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    19 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

    Prompt Table: DEPT_TBL

    20 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name
    21 GROUP_SEQ_NUM Number(6,0) INTEGER NOT NULL Specifies the system-assigned sequence number of a pending item within a group. A group is a postable entity that may be entered online or created by the system. In either case the group sequence number is automatically generated.
    22 COMMENTS Long Character CLOB Comment