SETIDDEPTIDFISCAL_YEARPOSITION_POOL_IDACCT_CDACCOUNTACTUALS_POOL_VW(SQL View) |
Index Back |
|---|---|
Position Pool ActualsACTUALS_POOL_VW summarizes actual paid and encumbered funds per account code at the position pool level. These sums can them be compared to the budgeted amount for this position pool and account code. |
| SELECT SETID , DEPTID , FISCAL_YEAR , POSITION_POOL_ID , 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 , POSITION_POOL_ID , 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 | POSITION_POOL_ID |
Character(3) | VARCHAR2(3) NOT NULL | Position Pool ID |
| 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 |