CRDC: S_SCH_CRDC_X (ver 15.11.0)
This table is an extension of the [Schools] table and provides CRDC-specific fields for Utah. To view additional CRDC fields used by all states, refer to S_SCH_CRDC_X in the All States Data Dictionary.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 15.11.0 | Number(10,0) | Primary Key |
| AllMagnetOnly_YN | 15.11.0 | Varchar2(1) | Entire school in magnet school program. Migrated from [Schools.CRDC_AllMagnetOnly_YN]. |
AlternativeSchool_YN | 15.11.0 | Varchar2(1) | Alternative school. Migrated from [Schools.CRDC_AlternativeSchool_YN]. |
| AlternativeSchoolAcademic_TF | 15.11.0 | Boolean | Students with Academic Difficulties. Migrated from [Schools.CRDC_AlternativeSchoolAcademic_TF]. |
| AlternativeSchoolDiscipline_TF | 15.11.0 | Boolean | Students with Discipline Problems. Migrated from [Schools.CRDC_AlternativeSchoolDiscipline_TF]. |
| APSelfParticipate_YN | 15.11.0 | Varchar2(1) | Self-selection by students permitted for all AP courses. Migrated from [Schools.CRDC_APSelfParticipate_YN]. |
| CharterSchool_YN | 15.11.0 | Varchar2(1) | Charter school. Migrated from [Schools.CRDC_CharterSchool_YN]. |
| ForDisabilities_YN | 15.11.0 | Varchar2(1) | Special education school. Migrated from [Schools.CRDC_ForDisabilities_YN]. |
| InterschAthletics_YN | 15.11.0 | Varchar2(1) | Interscholastic athletics. Migrated from [Schools.CRDC_InterschAthletics_YN]. |
| InterschParticipantsF | 15.11.0 | Number(10,0) | Count of female only participants on teams. Migrated from [Schools.CRDC_InterschParticipantsF]. |
| InterschParticipantsM | 15.11.0 | Number(10,0) | Count of male only participants on teams. Migrated from [Schools.CRDC_InterschParticipantsM]. |
| InterschSportsF | 15.11.0 | Number(10,0) | Count of female only sports. Migrated from [Schools.CRDC_InterschSportsF]. |
| InterschSportsM | 15.11.0 | Number(10,0) | Count of male only sports. Migrated from [Schools.CRDC_InterschSportsM]. |
| InterschTeamsF | 15.11.0 | Number(10,0) | Count of female only teams. Migrated from [Schools.CRDC_InterschTeamsF]. |
| InterschTeamsM | 15.11.0 | Number(10,0) | Count of male only teams. Migrated from [Schools.CRDC_InterschTeamsM]. |
| MagnetSchoolOrProgram_YN | 15.11.0 | Varchar2(1) | Magnet school or a school operating a magnet program. Migrated from [Schools.CRDC_MagnetSchoolOrProgram_YN]. |
| ProvidesUngraded_YN | 15.11.0 | Varchar2(1) | Ungraded students. Migrated from [Schools.CRDC_ProvidesUngraded_YN]. |