HGA_ABS_APPR_VW

(SQL View)
 Index Back

Absence workflow details

Absence final approver view

SELECT XREF.TRANSACTION_NBR , USR.EOAWUSTEP_INST_ID , XREF.EMPLID , XREF.EMPL_RCD , XREF.EOAWTHREAD_ID , XREF.EOAWTHREAD_STATUS , STEP.EOAWSTEP_STATUS , USR.OPRID , USR.EOAWORIG_OPRID , USR.EOAWSTEP_STATUS , OPR.EMPLID ,USR.EOAWDTTM_MODIFIED ,USR.DTTM_CREATED ,XREF.EOAWDTTM_MODIFIED FROM PS_GP_ABSSS_V_XREF XREF , PS_EOAW_STEPINST STEP , PS_EOAW_USERINST USR , PSOPRDEFN OPR WHERE XREF.EOAWTHREAD_ID = STEP.EOAWTHREAD_ID AND XREF.EOAWPRCS_ID = STEP.EOAWPRCS_ID AND XREF.EOAWDEFN_ID = STEP.EOAWDEFN_ID AND STEP.EOAWSTEP_INSTANCE = USR.EOAWSTEP_INSTANCE AND STEP.EOAWSTEP_INSTANCE = ( SELECT MAX(STEP1.EOAWSTEP_INSTANCE) FROM PS_EOAW_STEPINST STEP1 WHERE STEP1.EOAWPRCS_ID = STEP.EOAWPRCS_ID AND STEP1.EOAWDEFN_ID = STEP.EOAWDEFN_ID AND STEP1.EOAWTHREAD_ID = STEP.EOAWTHREAD_ID ) AND USR.EOAWUSTEP_INST_ID = ( SELECT MAX(USR1.EOAWUSTEP_INST_ID) FROM PS_EOAW_USERINST USR1 WHERE USR1.EOAWSTEP_INSTANCE = USR.EOAWSTEP_INSTANCE ) AND XREF.EOAWPARENT_THREAD = ( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_GP_ABSSS_V_XREF X1 WHERE XREF.TRANSACTION_NBR = X1.TRANSACTION_NBR ) AND OPR.OPRID = USR.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
2 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.
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
6 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
W=Canceled
X=Suspended/Pending Denial
7 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
8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
9 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID
10 EOAWUSTEP_STATUS Character(1) VARCHAR2(1) NOT NULL Approver Status
A=Approved
B=Pushed back
C=Auto Approved
D=Denied
E=Administrator denied
F=Deleted
G=Bypassed
H=Hold
K=Skipped
L=Terminated
M=Administrator approved
N=Not Active
P=Pending
S=Skipped
T=Terminated
U=Auto approved
W=Canceled
X=Deleted
Y=Bypassed
11 EMPLID_CURR_APPR Character(11) VARCHAR2(11) NOT NULL Stores the Employee ID of the Current Approver in Federal Self-Service Transactions.
12 EOAWDTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified
13 DTTM_CREATED DateTime(26) TIMESTAMP Datetime Created
14 DTTM_MODIFIED DateTime(26) TIMESTAMP Datetime modified