HCDL_DELEGATION (SQL Table)	Index Back
Delegation Table This record stores the delegated authority information for Manager Desktop applications. Managers can delegate processing authority to other individuals on a transaction-by-transaction basis.

HCDL_DELEGATION

(SQL Table)

Delegation Table

This record stores the delegated authority information for Manager Desktop applications. Managers can delegate processing authority to other individuals on a transaction-by-transaction basis.

# 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 DELEGATOR_OPRID Character(30) VARCHAR2(30) NOT NULL Delegator Oprid

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

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

9 END_DAY_IND Character(1) VARCHAR2(1) NOT NULL End Absence Day
0=End Day No
1=End Day Yes

10 DLGT_REQ_STATUS Character(1) VARCHAR2(1) NOT NULL Request Status
A=Accepted
E=Ended
J=Rejected
R=Revoked
S=Submitted

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

12 NOTIFY_DELEGATOR Character(1) VARCHAR2(1) NOT NULL Notify flag
N=Not Notify Delegator
Y=Notify Delegator

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

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

15 COMMENTS Long Character CLOB Comment

#	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	DELEGATOR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Delegator Oprid
7	PROXY_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
8	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
9	END_DAY_IND	Character(1)	VARCHAR2(1) NOT NULL	End Absence Day 0=End Day No 1=End Day Yes
10	DLGT_REQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Accepted E=Ended J=Rejected R=Revoked S=Submitted
11	DLGT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Delegation Status A=Active I=Inactive
12	NOTIFY_DELEGATOR	Character(1)	VARCHAR2(1) NOT NULL	Notify flag N=Not Notify Delegator Y=Notify Delegator
13	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.
14	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.
15	COMMENTS	Long Character	CLOB	Comment