HCSC_USTPAT_HST (SQL Table)	Index Back
HCM Shared Components This record is used to store userinformation for eThis record is used to store user information for each stepinstance in the AWE process. This allows the system to track and resolve multiple jobs within the approval framework. Only used with the delivered HCSC_USERLIST_UTILS application class based userlistsach step instance

HCSC_USTPAT_HST

(SQL Table)

HCM Shared Components

This record is used to store userinformation for eThis record is used to store user information for each stepinstance in the AWE process. This allows the system to track and resolve multiple jobs within the approval framework. Only used with the delivered HCSC_USERLIST_UTILS application class based userlistsach step instance

# 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 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

4 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

5 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

6 EOAWPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID

7 EOAWSTAGE_NBR Number(3,0) SMALLINT NOT NULL Approval Framework Stage Number

8 EOAWSTEP_NBR Number(6,2) DECIMAL(5,2) NOT NULL Sequence number of step in its path

9 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID

10 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.

11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

12 OPRID_TO Character(30) VARCHAR2(30) NOT NULL User ID

13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

14 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

15 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To

16 EMPL_RCD_TO Number(3,0) SMALLINT NOT NULL Empl Record

17 ACCESS_TYPE Character(1) VARCHAR2(1) NOT NULL Access Type
1=By Dept Security Tree
2=By Supervisor ID
3=By Department Manager ID
4=By Reports To Position
5=By Part Posn Mgmt Supervisor
6=By Part Posn Mgmt Dept Mgr ID
7=By Group ID

18 EOAWSTEP_TYPE Character(1) VARCHAR2(1) NOT NULL Type of step instance--Defined, Adhoc, Error
E=Error
H=Adhoc
N=Normal
S=Self Approved

19 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

20 EOAWADHOC_BY Character(30) VARCHAR2(30) NOT NULL User ID

#	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	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
4	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
5	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
6	EOAWPATH_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Path ID
7	EOAWSTAGE_NBR	Number(3,0)	SMALLINT NOT NULL	Approval Framework Stage Number
8	EOAWSTEP_NBR	Number(6,2)	DECIMAL(5,2) NOT NULL	Sequence number of step in its path
9	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
10	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.
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	OPRID_TO	Character(30)	VARCHAR2(30) NOT NULL	User ID
13	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
14	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
15	EMPLID_TO	Character(11)	VARCHAR2(11) NOT NULL	Empl ID To
16	EMPL_RCD_TO	Number(3,0)	SMALLINT NOT NULL	Empl Record
17	ACCESS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Access Type 1=By Dept Security Tree 2=By Supervisor ID 3=By Department Manager ID 4=By Reports To Position 5=By Part Posn Mgmt Supervisor 6=By Part Posn Mgmt Dept Mgr ID 7=By Group ID
18	EOAWSTEP_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of step instance--Defined, Adhoc, Error E=Error H=Adhoc N=Normal S=Self Approved
19	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
20	EOAWADHOC_BY	Character(30)	VARCHAR2(30) NOT NULL	User ID