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

The default file names for the PA Annual Financial Detail – Revenues report are:

.rpt file - AFRrevdet.rpt
.pdf file - AFRrevdet_<#####>.pdf
.xlsx file - AFRrevdetrpt<####_#####>.xlsx

The file layout differs depending on whether Full Account Structure (FAS) is turned off or enabled:

FAS Off

The following table shows the columns, column names, descriptions, and data sources or valid values for the PA Annual Financial Detail - Revenue report’s .xlsx file format when FAS is turned off.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year associated with the revenue record.	Populated during the file creation process. Retrieved from the Year field on the PA Annual Financial Report - Revenue Detail page.
B	AFR FUND	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.
C	AFR REVENUE CODE	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.
D	REVENUE SOURCE	Revenue source category derived from the first digit of the AFR Revenue Code: LOCAL (6xxx) STATE (7xxx) FEDERAL (8xxx) OTHER (9xxx)	Calculated during the file creation process. The calculated value represents the revenue source category derived from the first digit of the AFR Revenue Code. Codes beginning with 6 resolve to LOCAL, 7 to STATE, 8 to FEDERAL, and 9 to OTHER.
E	BUDGET UNIT	The last level (low organization) in the reporting structure, as defined in the Fund Accounting Profile.	Populated during the file creation process. Retrieved from the BUDGET UNIT field on the PA Annual Financial Report - Revenue Detail page.
F	ACCOUNT	The revenue account.	Populated during the file creation process. Retrieved from the Account field on the PA Annual Financial Report - Revenue Detail page.
G	REVENUE AMOUNT	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.
H	CURRENT YEAR ACCRUAL AMOUNT	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.
I	PRIOR YEAR ACCRUAL AMOUNT	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.

FAS On

The following table shows the columns, column names, descriptions, and data sources or valid values for the PA Annual Financial Detail - Revenue report’s .xlsx file format when FAS is enabled.

Column	Column Name	Description	Data Source or Valid Values
A	YEAR	The fiscal year associated with the revenue record.	Populated during the file creation process. Retrieved from the Year field on the PA Annual Financial Report - Revenue Detail page.
B	AFR FUND	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.
C	AFR REVENUE CODE	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.
D	REVENUE SOURCE	Revenue source category derived from the first digit of the AFR Revenue Code: LOCAL (6xxx) STATE (7xxx) FEDERAL (8xxx) OTHER (9xxx)	Calculated during the file creation process. The calculated value represents the revenue source category derived from the first digit of the AFR Revenue Code. Codes beginning with 6 resolve to LOCAL, 7 to STATE, 8 to FEDERAL, and 9 to OTHER.
E	ACCOUNT NUMBER	The full account string for the revenue account. This is the combined account string built from all segments defined by the Full Account Structure configuration.	Populated during the file creation process. Retrieved from the Full Account field on the PA Annual Financial Report - Revenue Detail page. When Full Account Structure is enabled, the separate Key Organization and Account fields are replaced by a single Full Account field.
F	TITLE	The title of the revenue account, as stored in the revenue ledger.	Populated during the file creation process. Retrieved from the Title field on the Revenue Budgets page for the account identified by the full account string.
G	REVENUE AMOUNT	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.
H	CURRENT YEAR ACCRUAL AMOUNT	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.
I	PRIOR YEAR ACCRUAL AMOUNT	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.