School Level Reporting – Basic Enrollment File

When you create the P223 Basic Enrollment File using the Monthly Enrollment Report File option, you will get a text file in which each individual record provides headcount or FTE total like those shown in a hard-copy P-223 Monthly Enrollment, Inter District report, or ALE Reporting into SAFS. Each detail record contains data in this format:

Field Name	Beg.	Len.	Type	T0	Lb	L0
RecordType	1	2	N				✓	09 = 'Basic Enrollment – P223'
Filler	3	1	F				✓	Must be one space ' '
SchoolYearCode	4	9	A				✓	YYYY-YYYY
Filler	13	1	F				✓	Must be one space ' '
Month	14	2	A			✓	✓	'01'-'13' EX: '09' – Sept, '01' – Jan
Filler	16	3	F				✓	Must be spaces ' '
DistrictCode	19	5	N		✓		✓	Current District
Filler	24	5	F				✓	Must be spaces ' '
SchoolCode	29	4	N			✓	✓	Wa_stu_monthly.building Wa_stu_interdist.building Wa_stu_ale.building Use '0000' for district level data(Open Doors)
Filler	33	3	F				✓	Must be spaces ' '
ResidentDistrictCode	36	5	N		✓		✓	wa_stu_interdist.resident_district or wa_stu_monthly.resident_district
Filler	41	10	F				✓	Must be spaces ' '
FieldNumber	51	6	N			✓	✓	See below for field number mapping
Filler	57	1	F				✓	Must be one space ' '
Amount	58	12	N			✓	✓	FTE(value before decimal) Or Headcount
DecimalPoint	70	1	F				✓	Must Be '.' (Decimal Point)
DecimalAmount	71	2	N	✓			✓	FTE (values after decimal) Or 00 for headcount
Filler	73	8	F				✓	Must be spaces ' '

You can read the data knowing the position of the School Code, cross-referencing the Field Number with the list provided below, and then reading the Amount and Decimal Amount values. Field Numbers are as follows:

2017-2018 Field Changes

Beginning with the 2017-18 reporting year, please note the following changes to the P-223 School-Level enrollment file fields:
TBIP fields

Field 174 is no longer reported.
Field 216 reports TBIP Grades K-6 Headcount
Field 217 reports TBIP Grades 7-12 Headcount

Kindergarten fields

Field 55 reports ALE Kindergarten FTE.
Field 56 reports ALE Kindergarten Headcount.
Field 121 reports K-12 Kindergarten FTE
Field 122 reports K-12 Kindergarten Headcount
The following fields are retired: 58, 59, 124, and 125.

High Poverty fields and Remote & Necessary fields

The fields for High Poverty buildings are all retired, including Fields 82 through 89, Field 91, and Field 92.
The fields for students in Remote & Necessary building are all retired, including Fields 135 through 162.