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. |