SETIDDEPTIDFISCAL_YEARHP_BUDGET_YEARACCT_CDACCOUNTACTUALS_DEPT_VW(SQL View) |
Index Back |
|---|---|
Department ActualsACTUALS_DEPT_VW summarizes actual paid and encumbered funds per account code at the department level. These sums can them be compared to the budgeted amount for this department and account code. |
| SELECT SETID , DEPTID , FISCAL_YEAR , HP_BUDGET_YEAR , ACCT_CD , ACCOUNT , SUM(POSTED_ACTUAL_AMT) , SUM(POSTED_ENCUMB_AMT) , SUM(POSTED_ACTUAL_AMT + POSTED_ENCUMB_AMT) , SUM(WORK_ACTUAL_AMT) , SUM(WORK_ENCUMB_AMT) FROM PS_BUDGET_ACTUALS GROUP BY SETID , DEPTID , FISCAL_YEAR , HP_BUDGET_YEAR , 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 | ACCT_CD |
Character(25) | VARCHAR2(25) NOT NULL | Combination Code |
| 6 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 7 | POSTED_ACTUAL_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Actual Amount |
| 8 | POSTED_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Posted Encumbrance Amount |
| 9 | POSTED_SUM_AMT | Signed Number(19,2) | DECIMAL(17,2) NOT NULL | Posted Total Amount |
| 10 | WORK_ACTUAL_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Work Actual Amount |
| 11 | WORK_ENCUMB_AMT | Signed Number(18,2) | DECIMAL(16,2) NOT NULL | Work Encumbrance Amount |