EOAWMAPPRTRANVW(SQL View) |
Index Back |
|---|---|
Mass Approval Transactions |
| SELECT ' ' , ' ' , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_INSTALLATION |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EOAWAPPROVER_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | Approver Operator ID |
| 2 | EOAWPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 3 | EOAWTHREAD_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 4 | 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 |
| 5 | 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 |
| 6 | EOAW_PREVIEWSTATUS | Character(1) | VARCHAR2(1) NOT NULL | Preview |
| 7 | EOAWERROR_MSG_TXT | Long Character(256) | VARCHAR2(256) | Error Message |
| 8 | EOAW_MA_LABELMSG | Character(254) | VARCHAR2(254) NOT NULL | Label Messaage |
| 9 | EOAW_MA_DISPLAYTLE | Character(254) | VARCHAR2(254) NOT NULL | Display Title |
| 10 | EOAW_MA_CONFIRMMSG | Character(254) | VARCHAR2(254) NOT NULL | Confirm Msg |