HP_RTBC_JOB1_VW(SQL View) |
Index Back |
|---|---|
Budget Status by Job View 1Budget Status by Job Data View 1 Join of HP_BDCK_LOG_JOB, BUDGET_ACTUALS, & HP_DOC_ID_SUMM SUMM |
| SELECT LG.EMPLID , LG.EMPL_RCD , LG.HP_BUDGET_STATUS , BDJ.HP_KK_DOC_ID , BDJ.HP_KK_DOC_LINE_NBR , BDJ.FISCAL_YEAR , BDJ.HP_BUDGET_YEAR , SUMM.HP_BUDGET_STATUS , BDJ.BUSINESS_UNIT_GL , BDJ.COMPANY , BDJ.PAYGROUP , BDJ.ACCT_CD , BDJ.ACCOUNT , BDJ.SETID , BDJ.DEPTID , BDJ.POSITION_POOL_ID , BDJ.SETID_JOBCODE , BDJ.JOBCODE , BDJ.ENCUMB_PROC_TYPE , BDJ.POSTED_ACTUAL_AMT , BDJ.POSTED_NE_ACT_AMT , BDJ.POSTED_ENCUMB_AMT , BDJ.ANNUAL_ENCUMB_AMT , BDJ.WORK_ACTUAL_AMT , BDJ.WORK_ENCUMB_AMT FROM PS_HP_BDCK_LOG_JOB LG , PS_BUDGET_ACTUALS BDJ , PS_HP_DOC_ID_SUMM SUMM WHERE LG.EMPLID = BDJ.EMPLID AND LG.EMPL_RCD = BDJ.EMPL_RCD AND BDJ.HP_KK_DOC_ID = SUMM.HP_KK_DOC_ID AND BDJ.HP_KK_DOC_LINE_NBR = SUMM.HP_KK_DOC_LINE_NBR AND BDJ.FISCAL_YEAR = SUMM.FISCAL_YEAR AND BDJ.HP_BUDGET_YEAR = SUMM.HP_BUDGET_YEAR AND BDJ.ENCUMB_PROC_TYPE LIKE 'E%' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | HP_BUDGET_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control budget status
I=Invalid P=Pending V=Valid X=Never Encumbered |
| 4 | HP_KK_DOC_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Commitment Control Document ID |
| 5 | HP_KK_DOC_LINE_NBR |
Number(3,0) | SMALLINT NOT NULL | Commitment Control Document Line # |
| 6 | FISCAL_YEAR |
Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 7 | HP_BUDGET_YEAR |
Number(4,0) | SMALLINT NOT NULL | Budget Year for Commitment Control |
| 8 | HP_BUDGET_STATUS2 | Character(1) | VARCHAR2(1) NOT NULL |
Commitment Control budget status
I=Invalid P=Pending V=Valid X=Never Encumbered |
| 9 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | General Ledger Unit |
| 10 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 11 | PAYGROUP | Character(3) | VARCHAR2(3) NOT NULL | Pay Group |
| 12 | ACCT_CD | Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 13 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 14 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 15 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 16 | POSITION_POOL_ID | Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 17 | SETID_JOBCODE | Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 18 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 19 | 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 |
| 20 | POSTED_ACTUAL_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Actual Amount |
| 21 | POSTED_NE_ACT_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted not Encumbered Actual Amount |
| 22 | POSTED_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Encumbrance Amount |
| 23 | ANNUAL_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Annual Encumbered Amount |
| 24 | WORK_ACTUAL_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Work Actual Amount |
| 25 | WORK_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Work Encumbrance Amount |