HCSC_DLGT_HDR_V

(SQL View)
 Index Back

Delegation Request

This view is used to retrieve delegation request info for HTML approval email. This view is replica of HCSC_DLGT_HDR_V used for display of HCM specific info on approval summary page.

SELECT A.EODL_DELEGATOR_OID , A.EODL_DELEGATOR_RCD , A.TRANSACTION_NAME , A.EODL_TRAN_ALLOWED , A.FROM_DATE , A.EODL_PROXY_OID , A.TO_DATE , %Sql(HR_HT_EMAIL_DATE, A.FROM_DATE) , %Sql(HR_HT_EMAIL_DATE, A.TO_DATE) , A.EODL_GROUP_SEQ_NUM , A.TRANSACTION_NBR , A.EODL_DLGT_STATUS , B.NAME_DISPLAY , A.EODL_PROXY_ID , C.NAME_DISPLAY , E.ORIGINATORID , E.EOAWDTTM_MODIFIED , G.NAME_DISPLAY , G.NAME_DISPLAY , A.COMMENTS , 'X' FROM PS_EODL_DELEGATION A , PS_PERSON_NAME B , PS_PERSON_NAME C , PSOPRDEFN D , PS_EODL_APPR_XREF E , PSOPRDEFN F , PS_PERSON_NAME G WHERE A.EODL_DELEGATOR_ID = B.EMPLID AND A.EODL_PROXY_OID = C.EMPLID AND A.EODL_DELEGATOR_OID = D.OPRID AND A.EODL_DELEGATOR_OID = E.EODL_DELEGATOR_OID AND A.EODL_DELEGATOR_RCD = E.EODL_DELEGATOR_RCD AND A.TRANSACTION_NAME = E.TRANSACTION_NAME AND A.EODL_TRAN_ALLOWED = E.EODL_TRAN_ALLOWED AND A.FROM_DATE = E.FROM_DATE AND A.EODL_PROXY_OID = E.EODL_PROXY_OID AND E.ORIGINATORID = F.OPRID AND F.EMPLID = G.EMPLID

# 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 FROM_DATE Date(10) DATE From Date
6 EODL_PROXY_OID Character(30) VARCHAR2(30) NOT NULL Proxy Operator Id
7 TO_DATE Date(10) DATE Latest Date to be sent to PYR
8 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
9 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
10 EODL_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.
11 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.
12 EODL_DLGT_STATUS Character(1) VARCHAR2(1) NOT NULL Delegation Status
A=Active
I=Inactive
13 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
14 EODL_PROXY_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
15 NAME_DISPLAY1 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
16 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
17 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
18 NAME_DISPLAY2 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country
19 REQUESTOR_NAME Character(60) VARCHAR2(60) NOT NULL Requestor name
20 COMMENTS Long Character CLOB Comment
21 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.