SETIDDEPTIDFISCAL_YEARHP_BUDGET_YEAREMPLIDEMPL_RCDACCT_CDACCOUNTACTUALS_APPT_VW(SQL View) |
Index Back |
|---|---|
Appointment ActualsACTUALS_APPT_VW summarizes actual paid and encumbered funds per account code at the appointment level. These sums can them be compared to the budgeted amount for this appointment and account code. |
| SELECT SETID , DEPTID , FISCAL_YEAR , HP_BUDGET_YEAR , EMPLID , EMPL_RCD , 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 , EMPLID , EMPL_RCD , 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 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 |