SEQ_NBRA=Active
I=Inactive
PTAFAW_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 | PTAFDEFN_ID | Character(30) | VARCHAR2(30) NOT NULL | Definition ID |
| 3 | PTAFPRCS_ID | Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 4 | PTAFTHREAD_ID | Number(10,0) | DECIMAL(10) NOT NULL | Thread ID |
| 5 | PTAFPARENT_THREAD | Number(10,0) | DECIMAL(10) NOT NULL | Parent Thread ID |
| 6 | PTAFAPPROVER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Approver Oprid |
| 7 | PTAFACTION | Character(3) | VARCHAR2(3) NOT NULL | Action |
| 8 | PTAFCOMMENT1 | Character(254) | VARCHAR2(254) NOT NULL | Comments |
| 9 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 10 | PTAFDONE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Done Flag |
| 11 | PTAFMA_STATUS | Long Character | CLOB | Used to store the detailed status of the action performed on that particular thread. |