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 | County-District-School Code | 14-character string |
| 2 | rtype | Record Type | S=School 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 |
| 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 |
| 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 |
| 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, Maintained 40=Very High, Increased 50=Very High, Increased Significantly 60=High, Declined Significantly 70=High, Declined 80=High, Maintained 90=High, Increased 100=High, Increased Significantly 110=Medium, Declined Significantly 120=Medium, Declined 130=Medium, Maintained 140=Medium, Increased 150=Medium, Increased Significantly 160=Low, Declined Significantly 170=Low, Declined 180=Low, Maintained 190=Low, Increased 200=Low, Increased Significantly 210=Very Low, Declined Significantly 220=Very Low, Declined 230=Very Low, Maintained 240=Very Low, Increased 250=Very Low, Increased Significantly 0=No Color |
| 31 | reportingyear | Reporting year | Text |