HCDL_BATCH_XREF

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTAFTHREAD_ID	Number(10,0)	DECIMAL(10) NOT NULL	Thread ID
2	PTAFPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
3	PTAFDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Definition ID
4	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
5	PTAFREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
6	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
7	PTAFTHREAD_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=Suspended T=Terminated X=Suspended/Pending Denial Default Value: N
8	PTAFPARENT_THREAD	Number(10,0)	DECIMAL(10) NOT NULL	Parent Thread ID
9	PTAFDTTM_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