Skip to main content
California Department of Education Logo

Record Layout for Fall 2017 ELPI

Field names, types, and descriptions for the Academic Indicator (English Language Progress Indicator) Data File.
Field # Field Name Description Acceptable Values
1 cds CDS Code 14-character string
2 rtype Record Type S=School Record
D=LEA/District 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 currtesters

Current year number of annual CELDT testers with prior CELDT Score.

Integer
9 curradvanced Current year number of annual CELDT testers who increased at least one CELDT performance level Integer
10 currmaintained Current year number of annual CELDT testers who maintained Early Advanced Proficient, or Advanced Proficient Integer
11 currrfeps Number of EL students who were reclassified between July 1, 2015 and June 30, 2016 Integer
12 currltels Current year number of LTEL students who increased at least one CELDT performance level. Integer
13 currnumer Current year number of annual CELDT testers who increased at least one performance level in CELDT or who maintained Early Advanced/Advanced Proficient plus ELs who were reclassified between July 1, 2015 and June 30, 2016 plus LTEL students who increased at least one CELDT performance level. Integer
14 currdenom Current year number of annual CELDT testers with a prior score plus ELs who were reclassified between July 1, 2015 and June 30, 2016. Integer
15 currstatus CURRENT STATUS

Percent calculation: Current year annual CELDT testers plus ELs who reclassified in the prior year divided by (1) current year ELs who increased at least one CELDT performance level, plus (2) current year ELs who maintained Early Advanced/Advanced Proficient, plus (3) former ELs who were reclassified between July 1, 2015 and June 30, 2016, plus (4) bonus count for LTELs who increased at least one performance level on current year CELDT.

(Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)

Decimal
16 priortesters Prior year number of annual CELDT testers with a prior CELDT score. Integer
17 prioradvanced Prior year number of annual CELDT testers who increased at least one CELDT performance level. Integer
18 priormaintaned Prior year number of annual CELDT testers who maintained Early Advanced Proficient, or Advanced Proficient. Integer
19 priorrfeps Number of EL students who were reclassified between July 1, 2014 and June 30, 2015 Integer
20 priorltels Prior year number of LTEL students who increased at least one CELDT performance level. Integer
21 priornumer Prior number of annual CELDT testers who increased at least one performance level in CELDT or who maintained Early Advanced/Advanced Proficient plus ELs who were reclassified between July 1, 2014 and June 30, 2015 plus prior year LTEL students who increased at least one CELDT performance level. Integer
22 priordenom Prior year number of annual CELDT testers with a prior score plus ELs who were reclassified between July 1, 2014 and June 30, 2015. Integer
23 priorstatus PRIOR STATUS

Percent calculation: Prior year annual CELDT testers plus former ELs reclassified between July 1, 2014 and June 30, 2015 divided by (1) prior year ELs who increased at least one CELDT performance level, plus (2) prior year ELs who maintained Early Advanced/Advanced Proficient, plus (3) former ELs who were reclassified between July 1, 2014 and June 30, 2015, plus (4) bonus count for prior year LTELs who increased at least one performance level on prior year CELDT.

(Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)
Decimal
24 change CHANGE
Difference between current status and prior status
Decimal
25 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
26 changelevel

Change level

(Determined after calculations and rounding. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)(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
27 color Color 1=Red
2=Orange
3=Yellow
4=Green
5=Blue
0=No Color
28 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, Mantained
40=Very High, Increased
50=Very High, Increased Significantly
60=High, Declined Significantly
70=High, Declined
80=High, Mantained
90=High, Increased
100=High, Increased Significantly
110=Medium, Declined Significantly
120=Medium, Declined
130=Medium, Mantained
140=Medium, Increased
150=Medium, Increased Significantly
160=Low, Declined Significantly
170=Low, Declined
180=Low, Mantained
190=Low, Increased
200=Low, Increased Significantly
210=Very Low, Declined Significantly
220=Very Low, Declined
230=Very Low, Mantained
240=Very Low, Increased
250=Very Low, Increased Significantly
0=No Color
29 flag50pct Tested less than 50% of EL population flag.

Districts and schools that did not test at least 50 percent of their English learner population on the California English Language Development Test (CELDT) in grades 3 through 8 and 11 are assigned an orange performance level (box 180), unless they have a red performance level. The 50 percent determination is based on the number of English learners (i.e., does not include reclassified students) who took the 2015 Smarter Balanced Summative Assessments in mathematics in grades 3 through 8 and 11.

Y or blank
Y=School did not test at least 50% of their EL population
30 nsize_met Both the current year number of annual CELDT records with a prior score (i.e., currtesters) and the prior year number of annual CELDT records with a prior score (i.e., priortesters) is 30 or more. Except for schools or LEAs with a ‘Y’ reported in the ‘flag50pct’ field, both the current and prior number of annual CELDTs must be 30 or more for a ‘color’ to be displayed.

Y=School or LEA had 30 or more annual CELDT records with a prior score in the current year and in the prior year

N=In the current and/or prior years, the school or LEA had fewer than 30 annual CELDT records with a prior score
31 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