HCSC_USTEP_ATRB (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_USTEP_ATRB

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

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

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

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

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

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

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

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

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

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

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

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

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

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

15 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

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

17 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

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

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