EOAW_CONTPNLAVW

(SQL View)
Index Back

Content Panel View Level 2


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 EOAWPRCS_GROUP Character(30) VARCHAR2(30) NOT NULL Approval Process ID
3 EOAWTHREAD_ID Number(15,0) DECIMAL(15) NOT NULL Approval Framework Thread 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 EOAWAPPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Operator ID
7 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
8 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
9 EOAW_PUSHBACK Character(1) VARCHAR2(1) NOT NULL Pushback
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 EOAWPRCSGROUPDESCR Character(30) VARCHAR2(30) NOT NULL Approval Process Group Description
12 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
13 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.
14 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.
15 EOAW_DATEPERIOD Character(2) VARCHAR2(2) NOT NULL Date Period
W0=This Week
W1=Last Week
W2=Two Weeks Ago
W3=Older
WA=All
16 EOAWGROUPBOX Character(1) VARCHAR2(1) NOT NULL Discussion Groupbox
17 NODE_NAME Character(40) VARCHAR2(40) NOT NULL Node Name
18 EOAW_PRIORITY_FLAG Character(1) VARCHAR2(1) NOT NULL Priority
H=High Priority
L=Low Priority
M=Medium Priority
N=No Priority
19 EOAW_USTEPSSTATUS Character(1) VARCHAR2(1) NOT NULL Special status for fluid approval.
20 EOAW_STATUSLABEL Character(100) VARCHAR2(100) NOT NULL Status Label