EOAWMA_SRCH_VW(SQL View) |
Index Back |
|---|---|
Integration serach parameters |
| 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 | APPROVEOPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver's Oper ID |
| 3 | ORIGINATORID | Character(30) | VARCHAR2(30) NOT NULL | Originator Identifier |
| 4 | EOAWREQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 5 | EOAWMODIFIED_DT | Date(10) | DATE | Date Last Modification |
| 6 | EOAWSTEP_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Step Instance Status
A=Approved B=Pushed back C=Auto Approved D=Denied E=Administrator denied F=Deleted G=Bypassed H=On Hold I=No Action Taken K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role T=Terminated U=Auto approved X=Deleted Z=Pending Denial |
| 7 | 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 X=Suspended/Pending Denial |
| 8 | EOAWAPPROVR_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=On Hold K=Skipped L=Terminated M=Administrator approved N=Not Active P=Pending R=No longer in role S=Skipped T=Terminated U=Self approved X=Unknown Y=Bypassed Z=Pending denial |
| 9 | EOAW_FROM_DT | Date(10) | DATE | From Date |