EODL_APPR_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 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	EODL_DELEGATOR_OID	Character(30)	VARCHAR2(30) NOT NULL	Delegator User Id
12	EODL_DELEGATOR_RCD	Number(3,0)	SMALLINT NOT NULL	Delegator Record Number
13	TRANSACTION_NAME	Character(25)	VARCHAR2(25) NOT NULL	EDI Transaction Name
14	EODL_TRAN_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
16	EODL_PROXY_OID	Character(30)	VARCHAR2(30) NOT NULL	Proxy Operator Id
17	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.