HCDL_DLGT_LOG

#	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	DLGT_REQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Request Status A=Accepted E=Ended J=Rejected R=Revoked S=Submitted
6	FROM_DATE	Date(10)	DATE	From Date
7	TO_DATE	Date(10)	DATE	Latest Date to be sent to PYR
8	END_DAY_IND	Character(1)	VARCHAR2(1) NOT NULL	End Absence Day 0=End Day No 1=End Day Yes
9	DELEGATOR_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Delegator Oprid
10	PROXY_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
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	ACTION_DT	Date(10)	DATE	Action Date
14	DATETIME_STAMP	DateTime(26)	TIMESTAMP	DateTime Stamp Default Value: %datetime