S_OH_SCH_CRDC_SNAP_C ver (19.5.1.0)
This table is a child of the SCHOOLS table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 19.5.1.0 | Number(10,0) | Primary key that relates the extended table back to the Schools table. |
| AllMagnetOnly_YN | 19.5.1.0 | VarChar(1) | Does the entire school population participate in the magnet school program? |
| AlternativeSchool_YN | 19.5.1.0 | VarChar(1) | Is this school an alternative school? |
| AlternativeSchoolAcademic_TF | 19.5.1.0 | VarChar(1) | This alternative school is designed to meet the needs of the following: Students with Academic Difficulties |
| AlternativeSchoolDiscipline_TF | 19.5.1.0 | VarChar(1) | This alternative school is designed to meet the needs of the following: Students with Discipline Problems |
| APSelfParticipate_YN | 19.5.1.0 | VarChar(1) | Is enrollment via self-selection by students permitted for all AP courses offered by the school? |
| CharterSchool_YN | 19.5.1.0 | VarChar(1) | Is this school a charter school? |
| FiscalYear | 19.5.1.0 | Number(11,0) | Indicates the fiscal year the data represents. |
| ForDisabilities_YN | 19.5.1.0 | VarChar(1) | Is this school a special education school? |
High_Grade | 19.5.1.0 | Number(11,0) | Override used to report a different school high grade value. |
| InterschAthletics_YN | 19.5.1.0 | VarChar(1) | Does this school have any students who participate in single-sex interscholastic athletics? |
| InterschParticipantsF | 19.5.1.0 | Number(11,0) | What is the count of female only participants on teams? |
| InterschParticipantsM | 19.5.1.0 | Number(11,0) | What is the count of male only participants on teams? |
| InterschSportsF | 19.5.1.0 | Number(11,0) | What is the count of female only sports? |
| InterschSportsM | 19.5.1.0 | Number(11,0) | What is the count of male only sports? |
| InterschTeamsF | 19.5.1.0 | Number(11,0) | What is the count of female only teams? |
| InterschTeamsM | 19.5.1.0 | Number(11,0) | What is the count of male only teams? |
| JusticeFacilityDays | 19.5.1.0 | Number(11,0) | Enter the number of days that make up the justice facility's regular school year |
| JusticeFacilityHours | 19.5.1.0 | Number(11,0) | Indicate the hours per week that the educational program is offered during the regular school year |
| JusticeFacilityType | 19.5.1.0 | VarChar(1) | If this school is a justice facility, indicate the type that best describes the facility. |
Low_Grade | 19.5.1.0 | Number(11,0) | Override used to report a different school low grade value. |
| MagnetSchoolOrProgram_YN | 19.5.1.0 | VarChar(1) | Is this school either a magnet school or a school operating a magnet program within the school? |
| NonLEAFacility_YN | 19.5.1.0 | VarChar(1) | Is the school a non-LEA facility? |
| Num_Adv_Math_High_Cert | 19.5.1.0 | Number(11,0) | Number of Advanced Mathematics classes for students in grades 9-12 taught by certified teachers. |
| Num_Algebra_II_High_Cert | 19.5.1.0 | Number(11,0) | Number of Algebra 1 classes for students in grades 9-12 taught by certified teachers. |
| Num_Algebra_I_High_Cert | 19.5.1.0 | Number(11,0) | Number of Algebra 2 classes for students in grades 9-12 taught by certified teachers. |
| Num_Algebra_I_Middle_Cert | 19.5.1.0 | Number(11,0) | Number of Algebra 1 classes for students in grades 7-8 taught by certified teachers. |
| Num_Biology_High_Cert | 19.5.1.0 | Number(11,0) | Number of Biology classes for students in grades 9-12 taught by certified teachers. |
| Num_Calculus_High_Cert | 19.5.1.0 | Number(11,0) | Number of Calculus classes for students in grades 9-12 taught by certified teachers. |
| Num_Chemistry_High_Cert | 19.5.1.0 | Number(11,0) | Number of Chemistry classes for students in grades 9-12 taught by certified teachers. |
| Num_CompSci_High_Cert | 19.5.1.0 | Number(11,0) | Number of Computer Science classes for students in grades 9-12 taught by certified teachers. |
| Num_Geometry_High_Cert | 19.5.1.0 | Number(11,0) | Number of Geometry classes for students in grades 9-12 taught by certified teachers. |
| Num_Physics_High_Cert | 19.5.1.0 | Number(11,0) | Number of Physics classes for students in grades 9-12 taught by certified teachers. |
| PreKGAgeNonIDEA3_YN | 19.5.1.0 | VarChar(1) | Does this school provide preschool to non-IDEA students age 3? |
| PreKGAgeNonIDEA4_YN | 19.5.1.0 | VarChar(1) | Does this school provide preschool to non-IDEA students age 4? |
| PreKGAgeNonIDEA5_YN | 19.5.1.0 | VarChar(1) | Does this school provide preschool to non-IDEA students age 5? |
| PrimarySchoolRecord_TF | 19.5.1.0 | VarChar(1) | Is this the primary record if more than two schools are combined? |
| ProvidesUngraded_YN | 19.5.1.0 | VarChar(1) | Does this school provide services to ungraded students? |
| SchInternetFiber_YN | 19.5.1.0 | VarChar(1) | Is this school connected to the internet through a fiber-optic connection? |
| SchInternetSchDev_YN | 19.5.1.0 | VarChar(1) | Does this school allow students to take home school-issued devices that can be used to access the internet for student learning? |
| SchInternetStuDev_YN | 19.5.1.0 | VarChar(1) | Does this school allow students to bring to school student-owned devices that can be used to access the internet for classroom or student learning? |
| SchInternetWiFi_YN | 19.5.1.0 | VarChar(1) | Does this school have Wi-Fi access in every classroom? |
| UngradedDetail | 19.5.1.0 | VarChar(1) | Indicates whether the ungraded school has mainly elementary, middle, and/or high school students. |
| WiFiEnabledDevices | 19.5.1.0 | Number(11,0) | Enter the number of Wi-Fi enabled devices provided by the school to students for student learning use. |