SETIDDEPTIDFISCAL_YEARHP_BUDGET_YEARSETID_JOBCODEJOBCODEACCT_CDACCOUNTACTUALS_JBCD_VW(SQL View) |
Index Back |
|---|---|
Jobcode ActualsACTUALS_JBCD_VW summarizes actual paid and encumbered funds per account code at the jobcode level. These sums can them be compared to the budgeted amount for this jobcode and account code. |
| SELECT SETID , DEPTID , FISCAL_YEAR , HP_BUDGET_YEAR , SETID_JOBCODE , JOBCODE , ACCT_CD , ACCOUNT , SUM(POSTED_ACTUAL_AMT) , SUM(POSTED_ENCUMB_AMT) , SUM(POSTED_ACTUAL_AMT + POSTED_ENCUMB_AMT) FROM PS_BUDGET_ACTUALS GROUP BY SETID , DEPTID , FISCAL_YEAR , HP_BUDGET_YEAR , SETID_JOBCODE , JOBCODE , ACCT_CD , ACCOUNT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 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 | SETID_JOBCODE |
Character(5) | VARCHAR2(5) NOT NULL | Job Code Set ID |
| 6 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 7 | ACCT_CD |
Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 8 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 9 | POSTED_ACTUAL_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Actual Amount |
| 10 | POSTED_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Encumbrance Amount |
| 11 | POSTED_SUM_AMT | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Posted Total Amount |