Record Layout for 2018 Suspension Indicator
Field names, types, and descriptions for the 2018 Suspension Indicator Data File.| Field # | Field Name | Description | Acceptable Values |
|---|---|---|---|
| 1 | cdscode | CDS Code | Text |
| 2 | rtype | Record Type | S=School Record D=District/LEA Record X=State 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 | dass_flag | Dashboard Alternative School Status (DASS) School Flag |
Y or blank |
| 9 | type | School or District Type | ES=Elementary School MS=Middle School HS=High School ED=Elementary District HD=High School District UD=Unified District |
| 10 | studentgroup | Student Group | ALL=All Students |
| 11 | currnumer | Number of Students Suspended in 2017-18 | Integer |
| 12 | currdenom | Cummulative Number of Students Enrolled in 2017-18 | Integer |
| 13 | currstatus | CURRENT STATUS -2017-18 Suspension Rate
|
Decimal |
| 14 | priornumer | Number of Students Suspended in 2016-17 | Integer |
| 15 | priordenom | Cummulative Number of Students Enrolled in 2016-17 | Integer |
| 16 | priorstatus | PRIOR STATUS - 2016-17 Suspension Rate (Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
Decimal |
| 17 | safetynet | Student population less than 150: 3x5 color grid was applied
Safety Net applies at the School, District, and Student Group levels |
Y/N |
| 18 | change | CHANGE - Difference between 2017-18 Suspension Rate and 2016-17 Suspension Rate
(Rounded after calculations. For further information regarding this data field refer to the CA School Dashboard Technical Guide.) |
Decimal |
| 19 | 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 |
| 20 | 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 |
| 21 | color | Color | |
| 22 | 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 |
| 23 | 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 any of the dashboard current or prior years that qualifies for a color at their overall level or student group levels 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 |
| 24 | reportingyear | Reporting year. | Text |