CRDC Specific to Ohio: S_SCH_CRDC_X (ver 15.9.0)
This table is an extension of the [SCHOOLS] table. This table provides CRDC-specific fields for Ohio.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| SchoolsDCID | 15.9.0 | Number(10,0) | Foreign key. |
| AllMagnetOnly_YN | 15.9.0 | VarChar2(1) | Does the entire school population participate in the magnet school program? |
| AlternativeSchool_YN | 15.9.0 | VarChar2(1) | Is this school an alternative school? |
| AlternativeSchoolAcademic_TF | 15.9.0 | Number(1,0) | This alternative school is designated to meet the needs of students with academic difficulties. |
| AlternativeSchoolDiscipline_TF | 15.9.0 | Number(1,0) | This alternative school is designated to meet the needs of students with discipline problems. |
| APSelfParticipate_YN | 15.9.0 | VarChar2(1) | Indicates if enrollment is via self-selection by students permitted for all AP courses offered by the school. |
| CharterSchool_YN | 15.9.0 | VarChar2(1) | Indicates if this school is a charter school. |
| ForDisabilties_YN | 15.9.0 | VarChar2(1) | Indicates if this school is a special education school. |
| IncStaffDetdNotRespRape | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Determined Not Responsible) - Rape or attempted rape. |
| IncStaffDetdNotRespSexAsslt | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Determined Not Responsible) - Sexual assault (other than rape). |
| IncStaffDetdPendRape | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Determination Pending) - Rape or attempted rape. |
IncStaffDetdPendSexAsslt | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Determination Pending)- Sexual assault (other than rape). |
| IncStaffDetdRespRape | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Determined Responsible) - Rape or attempted rape. |
| IncStaffDetdRespSexAsslt | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Determined Responsible) - Sexual assault (other than rape). |
| IncStaffDutyReasgmntRape | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Duty Reassignment) - Rape or attempted rape. |
| IncStaffDutyReasgmntSexAslt | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Duty Reassignment) - Sexual assault (other than rape). |
| IncStaffRape | 15.9.0 | Number(11,0) | Number of Incidents Committed by School Staff - Rape or attempted rape. |
| IncStaffResgnOrRetdSexAsslt | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Resignation or Retirement) - Rape or attempted rape. |
| IncStaffResignOrRetdRape | 15.9.0 | Number(11,0) | Number of Allegations Against School Staff (Resignation or Retirement) - Sexual assault (other than rape). |
| IncStaffSexAsslt | 15.9.0 | Number(11,0) | Number of Incidents Committed by School Staff - Sexual assault (other than rape). |
| InstructionType | 15.9.0 | VarChar2(1) | Schools select the option that best describes the effect of the coronavirus pandemic on instruction during the 2020–21 school year at this school:
|
| InterschAthletics_YN | 15.9.0 | VarChar2(1) | Indicates if this school has interscholastic athletics. |
| InterschParticipantsF | 15.9.0 | Number(11,0) | Count of female only participants on interscholastic athletic teams. |
| InterschParticipantsM | 15.9.0 | Number(11,0) | Count of male only participants on interscholastic athletic teams. |
| InterschSportsF | 15.9.0 | Number(11,0) | Count of female only sports. |
| InterschSportsM | 15.9.0 | Number(11,0) | Count of male only sports. |
| InterschTeamsF | 15.9.0 | Number(11,0) | Count of female only teams. |
| InterschTeamsM | 15.9.0 | Number(11,0) | Count of male only teams. |
| MagentSchoolOrProgram_YN | 15.9.0 | VarChar2(1) | Indicates if this school is either a magnet school or a school operating a magnet program within the school? |
| NoOfFTECounselors | 15.9.0 | Number(11,2) | Number of FTE school counselors. |
| NoOfFTELawEnforcement | 15.9.0 | Number(11,2) | Number of FTE sworn law enforcement officers. |
| NoOfFTENurses | 15.9.0 | Number(11,2) | Number of FTE nurses. |
| NoOfFTEPsychologists | 15.9.0 | Number(11,2) | Number of FTE psychologists. |
| NoOfFTESecGuards | 15.9.0 | Number(11,2) | Number of FTE security guards. |
| NoOfFTESocWorkers | 15.9.0 | Number(11,2) | Number of FTE social workers. |
| NoOfFTETeachers | 15.9.0 | Number(11,2) | Total number of full-time equivalent (FTE) teachers. |
| NoOfFTETeachersCert | 15.9.0 | Number(11,2) | Number of FTE teachers who are certified. |
| NoOfFTETeachersNotCert | 15.9.0 | Number(11,2) | Number of FTE teachers who are not certified. |
| ProvidesUngraded_YN | 15.9.0 | VarChar2(1) | Indicates if this school offers an ungraded grade level. |
| VirtualInstructionType | 15.9.0 | VarChar2(1) | Describes the school's virtual instruction setting:
|