EOAW_CONTPNL3VW

(SQL View)
Index Back

Content Panel View Level 3


SELECT EOAWPRCS_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , ' ' 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread ID
4 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
C=C
N=N
Y=Y
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
6 EOAWPARENT_THREAD Number(15,0) DECIMAL(15) NOT NULL Parent Thread ID
7 EOAWAPPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Operator ID
8 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
9 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
10 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
11 EOAW_PUSHBACK Character(1) VARCHAR2(1) NOT NULL Pushback
12 APPROVEOPRID Character(30) VARCHAR2(30) NOT NULL Approver's Oper ID
13 EOAWAPPDATAROW Number(5,0) INTEGER NOT NULL EOAW App Data Row Number
14 EOAWGROUPBOX Character(1) VARCHAR2(1) NOT NULL Discussion Groupbox