HP_ENCUMBER_CTL(SQL Table) |
Index Back |
|---|---|
Encumbrance Process ControlThis is the control record for encumbrance process. It keep tracks of the last doc id used, the current fiscal year and log if batch jobs are in progress. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SET_VLD_FS_02 |
| 2 | CALENDAR_ID | Character(2) | VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table: CAL_DEFN_TBL |
| 3 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL |
Fiscal Year
Prompt Table: CAL_FISYR_VW |
| 4 | DIST_PRORATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Prorate Option
C=Calendar Days I=For Internal System Use Only N=Not Applicable W=Work Days Default Value: C |
| 5 | HP_LAST_KK_DOC_ID | Number(31,0) | DECIMAL(31) NOT NULL |
Last Commitment Control Document ID
Default Value: 0 |
| 6 | HP_BATCH_IN_PROG | Character(1) | VARCHAR2(1) NOT NULL |
This field is to indicate if batch encumbrance or batch expense is in progress. If it is "Encumbrance" or "Actual Expense", then no RTBC activities are allowed.
A=Distribution in Progress E=Encumbrance in Progress G=GL Interface in Progress N=None P=Pending Encumbrance Calc Y=Year End in Progress Default Value: N |
| 7 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 8 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |