EOAW_USRIST_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	EOAWUSTEP_INST_ID	Number(15,0)	DECIMAL(15) NOT NULL	Object id of a step instance. Generated off the main thread id for the approval process.
4	EOAWSTEP_INSTANCE	Number(15,0)	DECIMAL(15) NOT NULL	Object id of a step instance. Generated off the main thread id for the approval process.
5	EOAWUSER_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Approval Workflow Events for Notification A=Approver Q=Requester R=Reviewer
6	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: PSOPRDEFN
7	EOAWORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
8	EOAWSTEP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Step Instance Status A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial
9	DTTM_CREATED	DateTime(26)	TIMESTAMP	Datetime Created
10	EOAWDTTM_MODIFIED	DateTime(26)	TIMESTAMP	Datetime modified
11	EOAWDTTM_COMPLETE	DateTime(26)	TIMESTAMP	Date/Time Completed