Skip to main content
California Department of Education Logo

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 CDS 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: Academic Accountability Team | aau@cde.ca.gov | 916-319-0863 
Last Reviewed: Thursday, December 7, 2017
Recently Posted in Accountability