PV_WF_ESCA_AET(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PV_AE_BU | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PV_AE_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 4 | REQ_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Req status
A=Approved C=Complete D=Denied I=Initial LA=Line Approved O=Open P=Pending Approval V=Preview X=Canceled |
| 5 | PV_AE_BU_FROM | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 6 | PV_AE_BU_TO | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 7 | PV_WF_ESCALATION | Character(1) | VARCHAR2(1) NOT NULL |
WF Escalation process
Y/N Table Edit |
| 8 | PV_WF_VCHR | Character(1) | VARCHAR2(1) NOT NULL |
Vouchered POs with No Receipts
Y/N Table Edit |
| 9 | PV_WF_ALL_BU | Character(1) | VARCHAR2(1) NOT NULL |
All Business Units
Y/N Table Edit |
| 10 | PV_RULEID | Character(12) | VARCHAR2(12) NOT NULL | Rule Id |
| 11 | STEP | Number(2,0) | SMALLINT NOT NULL | Step |
| 12 | PV_WORKFLOW_URL | Long Character | CLOB | ePro Workflow URL |