SEQ_NBRA=Active
I=Inactive
EOAW_DECISION(SQL Table) |
Index Back |
|---|---|
Mass Approvals Action TableContains an action that is to be taken in the Mass Approvals Framework. The record is update upon completion of the action taken. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 2 | EOAWDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Framework Definition ID |
| 3 | EOAWPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 4 | EOAWTHREAD_ID | Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 5 | EOAWPARENT_THREAD | Number(15,0) | DECIMAL(15) NOT NULL | Parent Thread ID |
| 6 | EOAWAPPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver Operator ID |
| 7 | EOAWACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 8 | EOAWCOMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 9 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 10 | EOAWDONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Approval Framework Mass Approval Flag |
| 11 | EOAWMA_STATUS | Long Character | CLOB | Used to store the detailed status of the action performed on that particular thread. |