Record Layout for 2019 Suspension Indicator
Field names, types, and descriptions for the 2019 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 2018-19 | Integer |
| 12 | currdenom | Cummulative Number of Students Enrolled in 2018-19 | Integer |
| 13 | currstatus | CURRENT STATUS -2018-19 Suspension Rate
|
Decimal |
| 14 | priornumer | Number of Students Suspended in 2017-18 | Integer |
| 15 | priordenom | Cummulative Number of Students Enrolled in 2017-18 | Integer |
| 16 | priorstatus | PRIOR STATUS - 2017-18 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 2018-19 Suspension Rate and 2017-18 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, Maintained 40=Very Low, Declined 50=Very Low, Declined Significantly 60=Low, Increased Significantly 70=Low, Increased 80=Low, Maintained 90=Low, Declined 100=Low, Declined Significantly 110=Medium, Increased Significantly 120=Medium, Increased 130=Medium, Maintained 140=Medium, Declined 150=Medium, Declined Significantly 160=High, Increased Significantly 170=High, Increased 180=High, Maintained 190=High, Declined 200=High, Declined Significantly 210=Very High, Increased Significantly 220=Very High, Increased 230=Very High, Maintained 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 |