Record Layout for Fall 2017 ELA Grades 3-8

Field names, types, and descriptions for the Academic Indicator (English Language Arts/Literacy Grades 3-8) Data File.

Field #	Field Name	Description	Acceptable Values
1	cds	County-District-School Code	14-character string
2	rtype	Record Type	S= School Record D=District/LEA Record
3	schoolname	School Name	Text
4	districtname	District Name	Text
5	countyname	County Name	Text
6	charter_flag	Charter School Flag	Y or blank
7	coe_flag	County Office of Education Flag	Y or blank
8	studentgroup	Student Group	ALL=All Students AA=Black/African American AI=American Indian or Alaska Native AS=Asian FI=Filipino HI=Hispanic PI=Pacific Islander WH=White MR=Multiple Races/Two or More EL=English Learner ELO=English Learners Only RFP=RFEPs Only EO=English Only SED=Socioeconomically Disadvantaged SWD=Students with Disabilities FOS=Foster Youth HOM=Homeless Youth
9	currdenom	Current year number of valid students who took the Smarter Balanced summative assessment in ELA	Integer
10	currstatus	Current Status - Average distance from level 3 of students who took the Smarter Balanced summative assessment in ELA (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)	Decimal
11	priordenom	Prior year number of valid students who took the Smarter Balanced summative assessment in ELA	Integer
12	priorstatus	Prior Status - Average distance from level 3 of students who took the Smarter Balanced summative assessment in ELA (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)	Decimal
13	change	CHANGE - Difference between current status and prior status	Decimal
14	statuslevel	Status Level (Determined after calculations and rounding. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)	1=Very Low 2=Low 3=Medium 4=High 5=Very High 0=No Data
15	changelevel	Change Level (Determined after calculations and rounding. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)	1=Decreased Significantly 2=Decreased 3=Maintained 4=Increased 5=Increased Significantly 0=No Data
16	color	Color	1=Red 2=Orange 3=Yellow 4=Green 5=Blue 0=No Color
17	box	If a color was assigned, this value represents the specific 5x5 grid location	10=Very High, Declined Significantly 20=Very High, Declined 30=Very High, Maintained 40=Very High, Increased 50=Very High, Increased Significantly 60=High, Declined Significantly 70=High, Declined 80=High, Maintained 90=High, Increased 100=High, Increased Significantly 110=Medium, Declined Significantly 120=Medium, Declined 130=Medium, Maintained 140=Medium, Increased 150=Medium, Increased Significantly 160=Low, Declined Significantly 170=Low, Declined 180=Low, Maintained 190=Low, Increased 200=Low, Increased Significantly 210=Very Low, Declined Significantly 220=Very Low, Declined 230=Very Low, Maintained 240=Very Low, Increased 250=Very Low, Increased Significantly 0=No Color
18	caa_denom	Current year number of valid students who took the California Alternate Assessment in ELA Only populated for records where studentgroup=ALL If the school or district did not test any students under the California Alternate Assessment, this value will be zero.	Integer
19	caa_level1_num	Current year number of valid students who took the California Alternate Assessment in ELA and scored achievement level 1 Only populated for records where studentgroup=ALL and caa_denom>=11	Integer
20	caa_level1_pct	Current year percent of valid students who took the California Alternate Assessment in ELA and scored achievement level 1 Only populated for records where studentgroup=ALL and caa_denom>=11	Decimal
21	caa_level2_num	Current year number of valid students who took the California Alternate Assessment in ELA and scored achievement level 2 Only populated for records where studentgroup=ALL and caa_denom>=11	Integer
22	caa_level2_pct	Current year percent of valid students who took the California Alternate Assessment in ELA and scored achievement level 2 Only populated for records where studentgroup=ALL and caa_denom>=11	Decimal
23	caa_level3_num	Current year number of valid students who took the California Alternate Assessment in ELA and scored achievement level 3 Only populated for records where studentgroup=ALL and caa_denom>=11	Integer
24	caa_level3_pct	Current year percent of valid students who took the California Alternate Assessment in ELA and scored achievement level 3 Only populated for records where studentgroup=ALL and caa_denom>=11	Decimal
25	reportingyear	Reporting year.	Text

Questions: Analysis Measurement and Accountability Reporting Division | Dashboard@cde.ca.gov

Last Reviewed: Wednesday, October 30, 2024

Trending in Accountability

Recently Posted in Accountability

Downloadable SARC Data Files 2024–25 (added 30-Oct-2025)
Template table names, downloadable data files, and mapping document to populate School Accountability Report Card (SARC) Reports.
Updates to SARC Data 2024–25 (added 30-Oct-2025)
Description of updates to data contained in the 2024–25 School Accountability Report Card (SARC) data files.
2023–24 SARC (added 19-Sep-2025)
Templates and data files for the School Accountability Report Card (SARC) for 2023–24.