EM_VCHR_APRU_VW (SQL View)	Index Back
eSettlements Approval Users eSettlements Approval user view

EM_VCHR_APRU_VW

(SQL View)

eSettlements Approval Users

eSettlements Approval user view

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.EOAWPATH_ID , B.EOAWSTAGE_NBR , B.EOAWSTEP_NBR , E.EOAWAPPROVER_LIST , CASE WHEN B.EOAWSTEP_STATUS = 'P' THEN 'Y' ELSE 'N' END , C.OPRID , C.EOAWSTEP_STATUS , C.EOAWDTTM_MODIFIED FROM PS_EMVCH_AF_XREF A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C , PS_VOUCHER D , PS_EOAW_STEP E WHERE A.EOAWTHREAD_ID = ( SELECT MAX(AA.EOAWTHREAD_ID) FROM PS_EMVCH_AF_XREF AA WHERE AA.BUSINESS_UNIT = A.BUSINESS_UNIT AND AA.VOUCHER_ID = A.VOUCHER_ID) AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWDEFN_ID = B.EOAWDEFN_ID AND B.EOAWSTEP_STATUS = 'P' AND C.EOAWSTEP_INSTANCE = B.EOAWSTEP_INSTANCE AND C.EOAWUSER_TYPE = 'A' AND C.EOAWSTEP_STATUS IN ('A','D','P') AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND D.VCHR_APPRVL_FLG = 'W' AND D.VCHR_SRC IN ('SSI','XML','DCM','EXL') AND E.EOAWPRCS_ID = B.EOAWPRCS_ID AND E.EOAWDEFN_ID = B.EOAWDEFN_ID AND E.EFFDT = B.EFFDT AND E.EOAWSTAGE_NBR = B.EOAWSTAGE_NBR AND E.EOAWPATH_ID = B.EOAWPATH_ID AND E.EOAWSTEP_NBR = B.EOAWSTEP_NBR UNION SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.EOAWPATH_ID , B.EOAWSTAGE_NBR , B.EOAWSTEP_NBR , E.EOAWAPPROVER_LIST , CASE WHEN B.EOAWSTEP_STATUS = 'P' THEN 'Y' ELSE 'N' END , C.OPRID , C.EOAWSTEP_STATUS , C.EOAWDTTM_MODIFIED FROM PS_VCHR_AF_XREF A , PS_EOAW_STEPINST B , PS_EOAW_USERINST C , PS_VOUCHER D , PS_EOAW_STEP E WHERE A.EOAWTHREAD_ID = ( SELECT MAX(AA.EOAWTHREAD_ID) FROM PS_VCHR_AF_XREF AA WHERE AA.BUSINESS_UNIT = A.BUSINESS_UNIT AND AA.VOUCHER_ID = A.VOUCHER_ID) AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWDEFN_ID = B.EOAWDEFN_ID AND B.EOAWSTEP_STATUS = 'P' AND C.EOAWSTEP_INSTANCE = B.EOAWSTEP_INSTANCE AND C.EOAWUSER_TYPE = 'A' AND C.EOAWSTEP_STATUS IN ('A','D','P') AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND D.VCHR_APPRVL_FLG = 'W' AND D.VCHR_SRC IN ('SSI','XML','DCM', 'EXL') AND E.EOAWPRCS_ID = B.EOAWPRCS_ID AND E.EOAWDEFN_ID = B.EOAWDEFN_ID AND E.EFFDT = B.EFFDT AND E.EOAWSTAGE_NBR = B.EOAWSTAGE_NBR AND E.EOAWPATH_ID = B.EOAWPATH_ID AND E.EOAWSTEP_NBR = B.EOAWSTEP_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID

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

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

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

6 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

7 CURRENT_STATUS Character(1) VARCHAR2(1) NOT NULL Current Project Status

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

9 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

10 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	VOUCHER_ID	Character(8)	VARCHAR2(8) NOT NULL	Voucher ID
3	EOAWPATH_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Path ID
4	EOAWSTAGE_NBR	Number(3,0)	SMALLINT NOT NULL	Approval Framework Stage Number
5	EOAWSTEP_NBR	Number(6,2)	DECIMAL(5,2) NOT NULL	Sequence number of step in its path
6	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
7	CURRENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Current Project Status
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
9	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
10	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.