EOAW_CONTPNL2VW(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 | 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 |
| 9 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 10 | EOAW_PUSHBACK | Character(1) | VARCHAR2(1) NOT NULL | Pushback |
| 11 | APPROVEOPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver's Oper ID |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | EOAWPRCSGROUPDESCR | Character(30) | VARCHAR2(30) NOT NULL | Approval Process Group Description |
| 14 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 15 | DESCRLONG | Long Character | CLOB | Long Description |
| 16 | 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. |
| 17 | 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. |
| 18 | EOAW_DATEPERIOD | Character(2) | VARCHAR2(2) NOT NULL |
Date Period
W0=This Week W1=Last Week W2=Two Weeks Ago W3=Older WA=All |
| 19 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
C=C N=N Y=Y |
| 20 | EOAWGROUPBOX | Character(1) | VARCHAR2(1) NOT NULL | Discussion Groupbox |
| 21 | NODE_NAME | Character(40) | VARCHAR2(40) NOT NULL | Node Name |
| 22 | EOAW_PRIORITY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Priority
H=High Priority L=Low Priority M=Medium Priority N=No Priority |
| 23 | EOAW_USTEPSSTATUS | Character(1) | VARCHAR2(1) NOT NULL | Special status for fluid approval. |
| 24 | EOAW_STATUSLABEL | Character(100) | VARCHAR2(100) NOT NULL | Status Label |