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 | County-District-School 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 |
| 10 | currnumer | Number of Students Suspended in 2016-17 | Integer |
| 11 | currdenom | Cumulative 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 | Cumulative 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. |
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, 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 |
| 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 |