EOWC_APP_CNT_VW (SQL View)	Index Back
Approval View for Workcenter Approval View for displaying count in Fluid workcenter

EOWC_APP_CNT_VW

(SQL View)

Approval View for Workcenter

Approval View for displaying count in Fluid workcenter

SELECT S.EOAWPARENT_THREAD , D.EOAWPRCS_ID , D.EOAWAPPROVER_OPRID , D.EOAWUSTEP_STATUS FROM PS_EOAW_SUMMARY S , PS_EOAW_SUMM_DTL D WHERE S.EOAWTHREAD_ID = S.EOAWPARENT_THREAD AND S.EOAWTHREAD_ID = D.EOAWPARENT_THREAD AND S.EOAWPRCS_ID = D.EOAWPRCS_ID AND D.EOAWUSTEP_STATUS IN ('P', 'H') AND EXISTS ( SELECT 'X' FROM PS_FIN_MBL_TYPE FIN WHERE FIN.EOAWPRCS_ID=S.EOAWPRCS_ID AND FIN.HMAP_INCL_APPR = 'Y') GROUP BY S.EOAWPARENT_THREAD, D.EOAWPRCS_ID, D.EOAWAPPROVER_OPRID, D.EOAWUSTEP_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

3 EOAWAPPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Operator ID

4 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	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
2	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
3	EOAWAPPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Operator ID
4	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