The AFR State Revenue Codes upload file is a .txt or .dat (hyphen-separated values) file.
Use this file to import AFR Revenue Crosswalk codes on the PA Annual Financial Report - Load AFR Revenue Crosswalk page.
The following table lists the columns, fields, descriptions, data type, and maximum length for the AFR Revenue Crosswalk upload file.
|
Column |
Field |
Description |
Data Type |
Max Length |
|---|---|---|---|---|
|
1 |
Revenue Code |
The four-digit PA state revenue classification code. Must be exactly four numeric digits; non-numeric or non-four-digit values are skipped. |
Numeric string |
4 characters |
|
2 |
Valid For |
Applicability description identifying which district types the code applies to. The loader scans this field for the keywords listed under Valid For Keyword Mapping. Records where this field equals DELETED are excluded. |
Text |
100 characters |
Valid For Keyword Mapping
The loader uses wildcard pattern matching (*keyword*) against the uppercased Valid For value to set district-type flags in the pa_afrrevcd table.
|
Keyword in file |
District type flag set |
|---|---|
|
SD |
School District = Y |
|
CS |
Charter School = Y |
|
CTC |
Career and Technology Center / Area Vocational Technical School = Y |
|
SS |
Special Program Jointure = Y |
|
All |
All four flags set to Y |
|
DELETED |
Record excluded from upload entirely |
Multiple keywords can appear in a single Valid For value (e.g., SD and CS only set both School District and Charter School flags).
Example Records
6111 - SD only
6500 - All
6600 - CS and SS only
7510 - CTC only
7292 - SD and CS only
6132 - DELETED