Skip to main content
California Department of Education Logo

Record Layout for Fall 2017 Suspension Rate

Field names, types, and descriptions for the Academic Indicator (Suspension 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 type School or District Type ES=Elementary School
MS=Middle School
HS=High School
ED=Elementary District
HD=High School District
UD=Unified District
9 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

10 currnumer Number of Students Suspended in 2016-17 Integer
11 currdenom Cummulative Number of Students Enrolled in 2016-17 Integer
12 currstatus CURRENT STATUS - 2016-17 Suspension Rate

(Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)
Decimal
13 priornumer Number of Students Suspended in 2015-16 Integer
14 priordenom Cummulative Number of Students Enrolled in 2015-16 Integer
15 priorstatus PRIOR STATUS - 2015-16 Suspension Rate

(Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)
Decimal
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 2016-17 Suspension Rate and 2015-16 Suspension Rate

Decimal
18 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 High
2=High
3=Medium
4=Low
5=Very Low
0=No Data
19 changelevel Change level

(Determined after calculations and rounding. For further information regarding this data field refer to the CA School Dashboard Technical Guide.)
1=Increased Significantly
2=Increased
3=Maintained
4=Decreased
5=Decreased Significantly
0=No Data
20 color Color 1=Red
2=Orange
3=Yellow
4=Green
5=Blue
0=No Color
21 box If a color was assigned, this value represents the specific 5x5 grid location 10=Very Low, Increased Significantly
20=Very Low, Increased
30=Very Low, Mantained
40=Very Low, Declined
50=Very Low, Declined Significantly
60=Low, Increased Significantly
70=Low, Increased
80=Low, Mantained
90=Low, Declined
100=Low, Declined Significantly
110=Medium, Increased Significantly
120=Medium, Increased
130=Medium, Mantained
140=Medium, Declined
150=Medium, Declined Significantly
160=High, Increased Significantly
170=High, Increased
180=High, Mantained
190=High, Declined
200=High, Declined Significantly
210=Very High, Increased Significantly
220=Very High, Increased
230=Very High, Mantained
240=Very High, Declined
250=Very High, Declined Significantly
0=No Color
22 certifyflag Non-certified data flag.

Districts and schools that did not certify their suspension (or discipline) data in the California Longitudinal Pupil Achievement Data System (CALPADS) for two consecutive years or in the current year or prior year and have at least 30 students in a certified year are automatically are assigned an orange performance level (box 180) if their earned color was originally blue, green, or yellow.

Y or Blank
Y=Did not certify suspension data
23 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