HP_RTBC_DOC1_VW(SQL View) |
Index Back |
|---|---|
Budget Status by Doc View 1Budget Status by Document ID View 1 Join of HP_DOC_ID_SUMM & BUDGET_ACTUALS |
| SELECT SUMM.HP_KK_DOC_ID , SUMM.HP_KK_DOC_LINE_NBR , SUMM.FISCAL_YEAR , SUMM.HP_BUDGET_YEAR , SUMM.HP_BUDGET_STATUS , BDJ.EMPLID , BDJ.EMPL_RCD , BDJ.POSITION_NBR , BDJ.ENCUMB_PROC_TYPE , BDJ.POSTED_ACTUAL_AMT , BDJ.POSTED_ENCUMB_AMT , BDJ.ANNUAL_ENCUMB_AMT , BDJ.WORK_ENCUMB_AMT , BDJ.BUSINESS_UNIT_GL , BDJ.SETID , BDJ.DEPTID , BDJ.COMPANY , BDJ.PAYGROUP , BDJ.ACCT_CD , BDJ.ACCOUNT , BDJ.POSITION_POOL_ID , BDJ.SETID_JOBCODE , BDJ.JOBCODE FROM PS_HP_DOC_ID_SUMM SUMM , PS_BUDGET_ACTUALS BDJ WHERE SUMM.HP_KK_DOC_ID = BDJ.HP_KK_DOC_ID AND SUMM.HP_KK_DOC_LINE_NBR = BDJ.HP_KK_DOC_LINE_NBR AND SUMM.FISCAL_YEAR = BDJ.FISCAL_YEAR AND SUMM.HP_BUDGET_YEAR = BDJ.HP_BUDGET_YEAR |
| # | 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | EMPL_RCD | Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 8 | POSITION_NBR | Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 9 | 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 |
| 10 | POSTED_ACTUAL_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Actual Amount |
| 11 | POSTED_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Encumbrance Amount |
| 12 | ANNUAL_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Annual Encumbered Amount |
| 13 | WORK_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Work Encumbrance Amount |
| 14 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | General Ledger Unit |
| 15 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 16 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 17 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 18 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 19 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 20 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 21 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 22 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 23 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |