EOAW_SUMMOID_VW (SQL View)	Index Back
Operator Summary View

EOAW_SUMMOID_VW

(SQL View)

Operator Summary View

SELECT A.EOAWAPPROVER_OPRID , A.EOAWTHREAD_ID , A.EOAWPRCS_ID , B.EOAWPARENT_THREAD , B.EOAWTHREAD_STATUS , A.EOAWUSTEP_STATUS , A.EOAWPREV_STATUS , B.EOAWREQUESTOR_ID , B.EOAW_PUSHBACK ,B.APPROVEOPRID , B.DESCR254 , B.DESCRLONG , B.LASTUPDDTTM , B.LASTUPDOPRID FROM PS_EOAW_SUMM_DTL A , PS_EOAW_SUMMARY B WHERE A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

4 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID

5 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
Default Value: N

6 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

7 EOAWPREV_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
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

8 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

9 EOAW_PUSHBACK Character(1) VARCHAR2(1) NOT NULL Pushback
Default Value: N

10 APPROVEOPRID Character(30) VARCHAR2(30) NOT NULL Approver's Oper ID

11 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

12 DESCRLONG Long Character CLOB Long Description

13 LASTUPDDTTM 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.

14 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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	EOAWAPPROVER_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver Operator ID
2	EOAWTHREAD_ID	Number(15,0)	DECIMAL(15) NOT NULL	Approval Framework Thread ID
3	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
4	EOAWPARENT_THREAD	Number(15,0)	DECIMAL(15) NOT NULL	Parent Thread ID
5	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 Default Value: N
6	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
7	EOAWPREV_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 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
8	EOAWREQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
9	EOAW_PUSHBACK	Character(1)	VARCHAR2(1) NOT NULL	Pushback Default Value: N
10	APPROVEOPRID	Character(30)	VARCHAR2(30) NOT NULL	Approver's Oper ID
11	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
12	DESCRLONG	Long Character	CLOB	Long Description
13	LASTUPDDTTM	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.
14	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.