HCDL_DLGT_HDR_V (SQL View)	Index Back
Delegation Request This view is used to retrieve delegation request info for HTML approval email.

HCDL_DLGT_HDR_V

(SQL View)

Delegation Request

This view is used to retrieve delegation request info for HTML approval email.

SELECT A.DELEGATOR_ID , A.DELEGATOR_RCD , A.TRANSACTION_NAME , A.TRANS_ALLOWED , A.FROM_DATE , A.TO_DATE , %Sql(HR_HT_EMAIL_DATE, A.FROM_DATE) , %Sql(HR_HT_EMAIL_DATE, A.TO_DATE) , A.GROUP_SEQ_NUM , A.TRANSACTION_NBR , A.DLGT_STATUS , B.NAME_DISPLAY , A.PROXY_ID , C.NAME_DISPLAY , E.ORIGINATORID , E.EOAWDTTM_MODIFIED , G.NAME_DISPLAY , G.NAME_DISPLAY , A.COMMENTS , 'X' FROM PS_HCDL_DELEGATION A , PS_PERSON_NAME B , PS_PERSON_NAME C , PSOPRDEFN D , PS_HCDL_APPR_XREF E , PSOPRDEFN F , PS_PERSON_NAME G WHERE A.DELEGATOR_ID = B.EMPLID AND A.PROXY_ID = C.EMPLID AND A.DELEGATOR_OPRID = D.OPRID AND A.DELEGATOR_ID = E.DELEGATOR_ID AND A.DELEGATOR_RCD = E.DELEGATOR_RCD AND A.TRANSACTION_NAME = E.TRANSACTION_NAME AND A.TRANS_ALLOWED = E.TRANS_ALLOWED AND A.FROM_DATE = E.FROM_DATE AND E.ORIGINATORID = F.OPRID AND F.EMPLID = G.EMPLID

# 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 FROM_DATE Date(10) DATE From Date

6 TO_DATE Date(10) DATE Latest Date to be sent to PYR

7 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr

8 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2

9 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.

10 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.

11 DLGT_STATUS Character(1) VARCHAR2(1) NOT NULL Delegation Status
A=Active
I=Inactive

12 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

13 PROXY_ID Character(11) VARCHAR2(11) NOT NULL Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.

14 NAME_DISPLAY1 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

15 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier

16 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified

17 NAME_DISPLAY2 Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country

18 REQUESTOR_NAME Character(60) VARCHAR2(60) NOT NULL Requestor name

19 COMMENTS Long Character CLOB Comment

20 DESCR_COMMENTS_HIS Long Character CLOB This field is used in a complex query that shows many descr fields.

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