TL_APP_PAY_M_VW (SQL View)	Index Back
TL pending payable approvals TL pending payable time approvals from the AWE where the approval process has multiple stages/steps.

TL_APP_PAY_M_VW

(SQL View)

TL pending payable approvals

TL pending payable time approvals from the AWE where the approval process has multiple stages/steps.

SELECT DISTINCT X.EMPLID ,X.EMPL_RCD ,X.DUR ,X.SEQ_NBR ,U.OPRID ,U.EOAWSTEP_STATUS ,X.EOAWDEFN_ID ,X.EOAWTHREAD_STATUS ,X.TRANSACTIONID ,U.EOAWORIG_OPRID FROM PS_TL_APP_PAY_XRF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE AND U.EOAWSTEP_STATUS = 'P' AND X.EOAWTHREAD_ID IN ( SELECT EOAWTHREAD_ID FROM PS_EOAW_STEPINST GROUP BY EOAWTHREAD_ID HAVING COUNT(*) > 1)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 DUR Date(10) DATE Date Under Report associates time being reported, scheduled or paid, to a specific date.

4 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

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

6 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

7 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

8 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

9 TRANSACTIONID Number(10,0) DECIMAL(10) NOT NULL Transaction Identifier

10 EOAWORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	DUR	Date(10)	DATE	Date Under Report associates time being reported, scheduled or paid, to a specific date.
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
6	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
7	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
8	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
9	TRANSACTIONID	Number(10,0)	DECIMAL(10) NOT NULL	Transaction Identifier
10	EOAWORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID