HP_KK_DOC_IDHP_KK_DOC_LINE_NBRFISCAL_YEARHP_BUDGET_YEARI=Invalid
P=Pending
V=Valid
X=Never Encumbered
Y/N Table Edit
HP_DOC_ID_SUMM(SQL Table) |
Index Back |
|---|---|
Doc ID SummaryThis record keeps track of the total encumbered amount per Doc ID. This information will send to Financial for budget check with result return as Valid or Invalid. If the result is valid, then same information will be posted on Doc ID Summary Archive record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HP_KK_DOC_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Commitment Control Document ID |
| 2 | HP_KK_DOC_LINE_NBR |
Number(3,0) | SMALLINT NOT NULL | Commitment Control Document Line # |
| 3 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 4 | HP_BUDGET_YEAR |
Number(4,0) | SMALLINT NOT NULL | Budget Year for Commitment Control |
| 5 | HP_BUDGET_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control budget status
I=Invalid P=Pending V=Valid X=Never Encumbered |
| 6 | HP_TTL_ENCUMB_AMT | Signed Number(25,2) | DECIMAL(23,2) NOT NULL | Total Encumbered Amount |
| 7 | HP_CLEAR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control amount cleared indicator
Y/N Table Edit |
| 8 | HP_LSTUPD_ENC_TIME | DateTime(26) | TIMESTAMP | Last Encumbrance Update Time Stamp |
| 9 | HP_PROCESS_INST | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance from Financial |