PV_RUN_CNTL_RPT(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPR_DEF_TBL_FS |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 4 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table: PV_CP_TREE_VW |
| 5 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL |
Node name
Prompt Table: PV_ITEM_CAT_VW |
| 6 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PM_NONVW |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 9 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 11 | REQ_DT | Date(10) | DATE | Requisition Date |
| 12 | FROMDATE | Date(10) | DATE | From Date |
| 13 | THRU_DATE | Date(10) | DATE | Through Date |
| 14 | AS_OF_DATE | Date(10) | DATE |
As of Date
Default Value: %date |
| 15 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 16 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 17 | 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 |
| 18 | APPROVAL_DT | Date(10) | DATE | Date of Approval |
| 19 | WORKLISTNAME | Character(30) | VARCHAR2(30) NOT NULL | Worklist Name |
| 20 | PV_RULEID | Character(12) | VARCHAR2(12) NOT NULL | Rule Id |
| 21 | APPR_INST_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Approval Instance Status
A=Approved D=Denied I=Initiated N=Not Applicable P=Pending R=Recycle S=Skipped |