PowerSchool ERP Pennsylvania

PA Annual Financial Report – Revenues - AFR File - File Layout and Data Mapping

The default file name for the PA Annual Financial Revenues report – AFR File is AFRExpFile.txt.

The following table lists the field names, descriptions, data sources or valid values, and whether the field is required for the PA Annual Financial Revenues report – AFR File.

Field Name

Description

Data Source or Valid Values

FundCode

The AFR revenue fund code.

Populated during the file creation process.

Retrieved from the AFR Fund Code field on the PA Annual Financial Report - Revenue Detail page.

RevenueCode

The four-character Pennsylvania state-assigned revenue classification code from the AFR Revenue Codes table (e.g., 6111).

Populated during the file creation process.

Retrieved from the AFR Revenue Code field on the PA Annual Financial Report - Revenue Detail page.

RevenueAmount

Total revenue dollar amount recorded for the account in the specified fiscal year.

Populated during the file creation process.

Retrieved from the Amount field on the PA Annual Financial Report - Revenue Detail page.

CurrentYearAccrualAmount

Current fiscal year accrual adjustment amount entered manually for the account.

Populated during the file creation process.

Retrieved from the Current Year Accrual Amount field on the PA Annual Financial Report - Revenue Detail page.

PriorYearAccrualAmount

Prior fiscal year accrual adjustment amount entered manually for the account.

Populated during the file creation process.

Retrieved from the Prior Year Accrual Amount field on the PA Annual Financial Report - Revenue Detail page.