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]. |