OPRIDRUN_CNTL_IDFISCAL_YEARI=Invalid
P=Pending
V=Valid
X=Never Encumbered
Prompt Table: SETID_TBL
Prompt Table: DEPT_TBL
Prompt Table: COMPANY_TBL
Prompt Table: PAYGROUP_TBL
A=Expense
E=Encumbrance
RUN_CNTL_RTBC(SQL Table) |
Index Back |
|---|---|
RTBC Error Reports Run ControlRun Control for Real Time Budget Check Error Reports. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | HP_RUN_DT | Date(10) | DATE | Run control date. |
| 5 | HP_THRU_DT_RUN | Date(10) | DATE | Run control field. |
| 6 | HP_BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control budget status
I=Invalid P=Pending V=Valid X=Never Encumbered |
| 7 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL |
Department
Prompt Table: DEPT_TBL |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 10 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table: PAYGROUP_TBL |
| 11 | HP_TRAN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Financial transactions type.
A=Expense E=Encumbrance |