HGA_APPR_PND_VW (SQL View)	Index Back
Pending Approver for Abs Req Pending Approver for Abs Req

HGA_APPR_PND_VW

(SQL View)

Pending Approver for Abs Req

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 FROM PS_GP_ABSSS_V_XREF XREF , PS_EOAW_STEPINST STEP , PS_EOAW_USERINST USR WHERE XREF.EOAWTHREAD_ID = STEP.EOAWTHREAD_ID AND XREF.EOAWPRCS_ID = STEP.EOAWPRCS_ID AND XREF.EOAWDEFN_ID = STEP.EOAWDEFN_ID AND XREF.EOAWTHREAD_STATUS = 'P' AND STEP.EOAWSTEP_STATUS = 'P' AND STEP.EOAWSTEP_INSTANCE = USR.EOAWSTEP_INSTANCE AND USR.EOAWSTEP_STATUS = 'P' AND USR.EOAWUSTEP_INST_ID = ( SELECT MAX(USR1.EOAWUSTEP_INST_ID) FROM PS_EOAW_USERINST USR1 WHERE USR1.EOAWSTEP_INSTANCE = USR.EOAWSTEP_INSTANCE AND USR1.EOAWSTEP_STATUS = 'P') AND XREF.EOAWPARENT_THREAD = ( SELECT MAX(X1.EOAWTHREAD_ID) FROM PS_GP_ABSSS_V_XREF X1 WHERE XREF.TRANSACTION_NBR = X1.TRANSACTION_NBR AND X1.EOAWTHREAD_STATUS = 'P')

# 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

#	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