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 W=Canceled 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 |