EOAW_MYMLTXN_VW

(SQL View)
Index Back

Left Panel Txn View


SELECT EOAWPRCS_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 99 , ' ' 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 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
4 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
5 EOAWREQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id
6 EOAWAPPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Operator ID
7 EOAW_DATEPERIOD Character(2) VARCHAR2(2) NOT NULL Date Period
W0=This Week
W1=Last Week
W2=Two Weeks Ago
W3=Older
WA=All
8 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.
9 EOAW_PRIORITY_FLAG Character(1) VARCHAR2(1) NOT NULL Priority
H=High Priority
L=Low Priority
M=Medium Priority
N=No Priority
10 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
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description
12 COUNT1 Number(12,0) DECIMAL(12) NOT NULL AUS WGEA counts
13 EOAWGROUPBOX Character(1) VARCHAR2(1) NOT NULL Discussion Groupbox