EOAW_SUMMRY_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
4	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
5	ORIGINATORID	Character(30)	VARCHAR2(30) NOT NULL	Originator Identifier
6	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
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	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
10	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
11	LASTUPDDTTM	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.
12	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	EOAW_PUSHBACK	Character(1)	VARCHAR2(1) NOT NULL	Pushback Default Value: N
14	APPROVEOPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver's Oper ID
15	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
16	DESCRLONG	Long Character	CLOB	Long Description