SETIDDEPTIDFISCAL_YEARPOSITION_NBRACCT_CDACCOUNTACTUALS_POSN_VW(SQL View) |
Index Back |
|---|---|
Position ActualsACTUALS_POSN_VW summarizes actual paid and encumbered funds per account code at the position level. These sums can them be compared to the budgeted amount for this position and account code. |
| SELECT SETID , DEPTID , FISCAL_YEAR , POSITION_NBR , 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_NBR , 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_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Position Number |
| 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 |