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(10,0) | DECIMAL(10) NOT NULL | Counter |
13 | EOAWGROUPBOX | Character(1) | VARCHAR2(1) NOT NULL | Discussion Groupbox |