HCDL_ADMIN_XREF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
2	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
3	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
4	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
5	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
6	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
7	EOAWTHREAD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Thread Status A=Approved C=Complete D=Denied E=Pending Denial H=Hard Deny I=Initial N=Not Active P=Pending S=Awaiting Further Approvals T=Terminated W=Canceled X=Suspended/Pending Denial Default Value: N
8	EOAWPARENT_THREAD	Number(15,0)	DECIMAL(15) NOT NULL	Parent Thread ID
9	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
10	COMMENTS	Long Character	CLOB	Comment
11	DELEGATOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Direct Reports: EMPLID of an individual to whom a process or transaction has been delegated.
12	DELEGATOR_RCD	Number(3,0)	SMALLINT NOT NULL	Delegator Record Number
13	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
14	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
15	FROM_DATE	Date(10)	DATE	From Date