HP_DOCSUMWRK_VW

(SQL View)
 Index Back

Doc ID Summary

This 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.

SELECT HP_EMPLID , HP_EMPL_RCD , HP_POSITION_NBR , HP_JOB_OPENING_ID , HP_KK_DOC_ID , HP_KK_DOC_LINE_NBR , FISCAL_YEAR , HP_BUDGET_YEAR , HP_BUDGET_STATUS , HP_TTL_ENCUMB_AMT , HP_CLEAR_IND , HP_LSTUPD_ENC_TIME , HP_PROCESS_INST FROM PS_HP_DOCSUM_WRK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 HP_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 HP_EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 HP_POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
4 HP_JOB_OPENING_ID Number(15,0) DECIMAL(15) NOT NULL Job Opening Clone
5 HP_KK_DOC_ID Number(31,0) DECIMAL(31) NOT NULL Commitment Control Document ID
6 HP_KK_DOC_LINE_NBR Number(3,0) SMALLINT NOT NULL Commitment Control Document Line #
7 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
8 HP_BUDGET_YEAR Number(4,0) SMALLINT NOT NULL Budget Year for Commitment Control
9 HP_BUDGET_STATUS Character(1) VARCHAR2(1) NOT NULL Commitment Control budget status
I=Invalid
P=Pending
V=Valid
X=Never Encumbered
10 HP_TTL_ENCUMB_AMT Signed Number(25,2) DECIMAL(23,2) NOT NULL Total Encumbered Amount
11 HP_CLEAR_IND Character(1) VARCHAR2(1) NOT NULL Commitment Control amount cleared indicator

Y/N Table Edit

12 HP_LSTUPD_ENC_TIME DateTime(26) TIMESTAMP Last Encumbrance Update Time Stamp
13 HP_PROCESS_INST Number(10,0) DECIMAL(10) NOT NULL Process Instance from Financial