AM_SS_RET_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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
13	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
14	DATE_SUBMITTED	Date(10)	DATE	Date Submitted