HP_RTBC_DC_SRCH(SQL View) |
Index Back |
|---|---|
Budget Status by Doc SearchBudget Status by Document ID Search Record |
| SELECT SUMM.HP_KK_DOC_ID , SUMM.HP_KK_DOC_LINE_NBR , SUMM.FISCAL_YEAR , SUMM.HP_BUDGET_YEAR , SUMM.HP_BUDGET_STATUS , XRF.SETID , XRF.DEPTID , XRF.ENCUMB_PROC_TYPE , XRF.COMPANY , XRF.PAYGROUP , XRF.BUSINESS_UNIT_GL , XRF.ACCT_CD , XRF.ACCOUNT FROM PS_HP_DOC_ID_XREF XRF , PS_HP_DOC_ID_SUMM SUMM WHERE XRF.HP_KK_DOC_ID = SUMM.HP_KK_DOC_ID AND XRF.HP_KK_DOC_LINE_NBR = SUMM.HP_KK_DOC_LINE_NBR |
| # | 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 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 7 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 8 | ENCUMB_PROC_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Indicate the encumbrance type on Budget Actuals and Encumbrance Distribution record.
ED=Encumber Deduction EE=Encumber Salary ET=Encumber Tax PD=Postiion PreEncumber Deduction PE=Position PreEncumber Salary PT=Position PreEncumber Tax RD=Job Req PreEncumber Deduction RE=Job Req PreEncumber Salary RT=Job Req PreEncumber Tax |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 10 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 11 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | General Ledger Unit |
| 12 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 13 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |