PA Annual Financial Report – Supplemental Expenditure Schedule - File Layout and Data Mapping
The default file names for the PA Annual Financial report - Supplemental Expenditure Schedule are:
.rpt file - AFRexpsup.rpt
.pdf and .xlsx files - AFRexpsuprpt<XXXX_XXXXX>.<extension>
The following table shows the columns, column names, descriptions, and data sources or valid values for the PA Annual Financial report - Supplemental Expenditure Schedule’s .xlsx file format.
Column | Column Name | Description | Data Source or Valid Values |
|---|---|---|---|
A | YEAR | The fiscal year associated with the expenditure record. | Retrieved from the Year field on the PA Annual Financial Report - Expenditure Detail page. |
B | AFR FUND | The AFR expenditure fund code. | Retrieved from the AFR Fund field on the PA Annual Financial Report - Expenditure Detail page. |
C | AFR FUNCTION | The AFR expenditure function code. | Retrieved from the AFR Function field on the PA Annual Financial Report - Expenditure Detail page. |
D | AFR OBJECT | The AFR expenditure object code. | Retrieved from the AFR Object field on the PA Annual Financial Report - Expenditure Detail page. |
E | FINAL AMOUNT | The final dollar amount. | Retrieved from the Final field on the PA Annual Financial Report - Expenditure Detail page. |
F | ELEMENTARY AMOUNT | The dollar amount for Kindergarten through Sixth Grade expenditures. | Retrieved from the Elementary field on the PA Annual Financial Report - Expenditure Detail page. |
G | SECONDARY AMOUNT | The dollar amount for Seventh Grade through Twelfth Grade expenditures. | Retrieved from the Secondary field on the PA Annual Financial Report - Expenditure Detail page. |
H | FEDERAL AMOUNT | The dollar amount for costs funded by federal revenues. | Retrieved from the Federal field on the PA Annual Financial Report - Expenditure Detail page. |
I | TOTAL AMOUNT | The total dollar amount. | Retrieved from the Total field on the PA Annual Financial Report - Expenditure Detail page. |