EOAW_INTPNL3VW

(SQL View)
 Index Back

Integration Panel View Level 3


SELECT EOAWPRCS_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_EOAW_TXN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID
2 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
3 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
X=Suspended/Pending Denial
4 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
5 EOAWAPPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Operator ID
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
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
10 APPROVEOPRID Character(30) VARCHAR2(30) NOT NULL Approver's Oper ID
11 EOPCNAMEHASH Character(28) VARCHAR2(28) NOT NULL Field Name Hash
12 EOPCVALUEHASH Character(28) VARCHAR2(28) NOT NULL Value Hash
13 EOAWAPPKEYS Long Character CLOB EOAW App Keys
14 EOAWAPPKEYSVALUE Long Character CLOB EOAW App Keys Value
15 EOAWTHREADLIST Long Character CLOB Thread List
16 EOPCOBJ_L1ROW Long Character CLOB Page HTML Field: Level 1 Row
17 EOPCOBJ_L1 Long Character CLOB Page HTML Field: Level 1
18 EOPCOBJ_L1_A Long Character CLOB Page HTML Field: Level 1_A
19 EOPCOBJ_L1_B Long Character CLOB Page HTML Field: Level 1_B
20 EOPCOBJ_L1_C Long Character CLOB Page HTML Field: Level 1_C
21 EOPCOBJ_L1_D Long Character CLOB Page HTML Field: Level 1_D
22 EOAWERROR_MSG_TXT Long Character(256) VARCHAR2(256) Error Message