Skip to main content
California Department of Education Logo

Record Layout for Fall 2017 Graduation Rate

Field names, types, and descriptions for the Academic Indicator (Graduation Rate Indicator) 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
SED=Socioeconomically
Disadvantaged
SWD=Students with Disabilities
FOS=Foster Youth
HOM=Homeless Youth

9 currnumer Number of 2015-16 cohort graduates Integer
10 currdenom Total number of 2015-16 cohort students Integer
11 currstatus

CURRENT STATUS - 2015-16 Graduation Rate

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

Decimal
12 priornumer Number of students who graduated in prior 3 years Integer
13 priordenom Total number of students in prior 3 years Integer
14 priorstatus

PRIOR STATUS - 3-year graduation rate average

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

Decimal
15 cal_method Calculation method of 3-year average of 2012-13, 2013-14, and 2014-15 school years

'--'=All 3 years have 0 students
N/A=All 3 years are less than 11 students;
3yr= All 3 years are greater than or equal to 11 students;
2yr=Two of the years are greater than or equal to 11 students;
1yr=One of the years is greater than or equal to 11 students

16 safetynet

Student population less than 150: 3x5 color grid was applied

Safety Net only applies at the School and District levels. It does not apply towards any student groups.

Y/N
17 change CHANGE - Difference between 2015-16 graduation rate and prior 3-year average Decimal
18 prioryear1_numer Number of 2014-15 cohort graduates Integer
19 prioryear1_denom Total number of 2014-15 cohort students Integer
20 prioryear1_status 2014-15 Graduation Rate Decimal
21 prioryear2_numer Number of 2013-14 cohort graduates Integer
22 prioryear2_denom Total number of 2013-14 cohort students Integer
23 prioryear2_status 2013-14 Graduation Rate Decimal
24 prioryear3_numer Number of 2012-13 cohort graduates Integer
25 prioryear3_denom Total number of 2012-13 cohort students Integer
26 prioryear3_status 2012-13 Graduation Rate Decimal
27 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
28 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

29 color Color 1=Red
2=Orange
3=Yellow
4=Green
5=Blue
0=No Color
30 box If a color was assigned, this value represents the specific 5x5 grid location 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
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