EM_VCHL_APRU_VW (SQL View)	Index Back
eSettlements Line Approvers eSettlements AWE Line Level Approvers

EM_VCHL_APRU_VW

(SQL View)

eSettlements Line Approvers

eSettlements AWE Line Level Approvers

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , 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_EMVLN_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_EMVLN_AF_XREF AA WHERE AA.BUSINESS_UNIT = A.BUSINESS_UNIT AND AA.VOUCHER_ID = A.VOUCHER_ID AND AA.VOUCHER_LINE_NUM = A.VOUCHER_LINE_NUM AND AA.DISTRIB_LINE_NUM = A.DISTRIB_LINE_NUM) AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWDEFN_ID = B.EOAWDEFN_ID 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 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number

4 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line

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

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

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

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

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

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

11 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

12 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	VOUCHER_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Voucher Line Number
4	DISTRIB_LINE_NUM	Number(5,0)	INTEGER NOT NULL	Distribution Line
5	EOAWPATH_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Path ID
6	EOAWSTAGE_NBR	Number(3,0)	SMALLINT NOT NULL	Approval Framework Stage Number
7	EOAWSTEP_NBR	Number(6,2)	DECIMAL(5,2) NOT NULL	Sequence number of step in its path
8	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
9	CURRENT_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Current Project Status
10	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
11	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
12	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.