HP_KK_DOC_IDHP_KK_DOC_LINE_NBRFISCAL_YEARHP_BUDGET_YEARHP_SEQ_NBRY/N Table Edit
HP_DOC_ID_ARCH(SQL Table) |
Index Back |
|---|---|
Doc ID Summary ArchiveThis record keeps an audit trial of the total encumbered amount and total expense amount per Doc ID. |
| # | 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_SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 6 | HP_TTL_ENCUMB_AMT | Signed Number(25,2) | DECIMAL(23,2) NOT NULL | Total Encumbered Amount |
| 7 | HP_TTL_EXPENSE_AMT | Signed Number(25,2) | DECIMAL(23,2) NOT NULL | Total Expense Amount |
| 8 | HP_CLEAR_IND | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control amount cleared indicator
Y/N Table Edit |
| 9 | HP_LSTUPD_ENC_TIME | DateTime(26) | TIMESTAMP | Last Encumbrance Update Time Stamp |
| 10 | HP_LSTUPD_EXP_TIME | DateTime(26) | TIMESTAMP | Last Expense Update Time Stamp |