PTAI_ITEM_IDPTAITHREAD_IDPTAIPRCS_IDA=Approved
D=Denied
N=Not Applicable
P=Pending Approval
T=Terminated/Cancelled
X=Partially Approved
PTAI_EOAW(SQL Table) |
Index Back |
|---|---|
AG-AWE IntegrationTable to store thread ID corresponding to Action Item ID. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTAI_ITEM_ID |
Character(31) | VARCHAR2(31) NOT NULL | Action Items - Action Item ID |
| 2 | PTAITHREAD_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Approval Framework Thread ID |
| 3 | PTAIPRCS_ID |
Character(30) | VARCHAR2(30) NOT NULL | Approval Process ID |
| 4 | PTAI_AWE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AWE Status Field
A=Approved D=Denied N=Not Applicable P=Pending Approval T=Terminated/Cancelled X=Partially Approved |