HMAF_STEP_VW

(SQL View)
 Index Back

Approval Framework View

This view joins EOAW_STEPINST and EOAW_USERINST for convenience. This view is used by the HMAP_APPROVAL application class for mobile approvals.

SELECT S.EOAWPRCS_ID , S.EOAWDEFN_ID , S.EFFDT , S.EOAWSTAGE_NBR , S.EOAWPATH_ID , S.EOAWSTEP_NBR , S.EOAWTHREAD_ID , S.EOAWSTEP_INSTANCE , U.EOAWUSTEP_INST_ID , S.EOAWSTEP_TYPE , U.EOAWUSER_TYPE , U.OPRID , U.EOAWORIG_OPRID , U.EOAWSTEP_STATUS , S.EOAWADHOC_BY , U.DTTM_CREATED , U.EOAWDTTM_MODIFIED FROM PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE S.EOAWSTEP_INSTANCE = U.EOAWSTEP_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 EOAWSTAGE_NBR Number(3,0) SMALLINT NOT NULL Approval Framework Stage Number
5 EOAWPATH_ID Character(30) VARCHAR2(30) NOT NULL Approval Path ID
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 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.
10 EOAWSTEP_TYPE Character(1) VARCHAR2(1) NOT NULL Type of step instance--Defined, Adhoc, Error
E=Error
H=Adhoc
N=Normal
S=Self Approved
11 EOAWUSER_TYPE Character(3) VARCHAR2(3) NOT NULL Approval Workflow Events for Notification
A=Approver
Q=Requester
R=Reviewer
12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: PSOPRDEFN

13 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
14 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
15 EOAWADHOC_BY Character(30) VARCHAR2(30) NOT NULL User ID
16 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
17 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified