CRDC Specific to South Carolina: S_SCH_CRDC_X (ver 16.1.0)
This table is an extension of the [Schools] table and provides CRDC-specific fields for South Carolina. 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 | 16.1.0 | Number(10,0) | Foreign Key. |
AllMagnetOnly_YN | 16.1.0 | Varchar2(1) | Does the entire school population participate in the magnet school program? Migrated from [Schools.CRDC_AllMagnetOnly_YN]. |
AlternativeSchool_YN | 16.1.0 | Varchar2(1) | Is this school an alternative school? Migrated from [Schools.CRDC_AlternativeSchool_YN]. |
AlternativeSchoolAcademic_TF | 16.1.0 | Number(1,0) | This alternative school is designed to meet the needs of students with academic difficulties. Migrated from [Schools.CRDC_AAlternativeSchoolAcademic_TF]. |
AlternativeSchoolDiscipline_TF | 16.1.0 | Number(1,0) | This alternative school is designed to meet the needs of students with discipline problems. Migrated from [Schools.CRDC_AlternativeSchoolDiscipline_TF]. |
APSelfParticipate_YN | 16.1.0 | Varchar2(1) | SCH 26. Is enrollment via self-selection by students permitted for all AP courses offered by the school? Migrated from [Schools.CRDC_APSelfParticipate_YN]. |
CharterSchool_YN | 16.1.0 | Varchar2(1) | Is this school a charter school? Migrated from [Schools.CRDC_CharterSchool_YN]. |
ForDisabilities_YN | 16.1.0 | Varchar2(1) | Is this school a special education school? Migrated from [Schools.CRDC_ForDisabilities_YN]. |
InterschAthletics_YN | 16.1.0 | Varchar2(1) | Does this school have interscholastic athletics? Migrated from [Schools.CRDC_InterschAthletics_YN]. |
InterschParticipantsF | 16.1.0 | Number(11,0) | What is the count of female only participants on teams? Migrated from [Schools.CRDC_InterschParticipantsF]. |
InterschParticipantsM | 16.1.0 | Number(11,0) | What is the count of male only participants on teams? Migrated from [Schools.CRDC_InterschParticipantsM]. |
InterschSportsF | 16.1.0 | Number(11,0) | What is the count of female only sports? Migrated from [Schools.CRDC_InterschSportsF]. |
InterschSportsM | 16.1.0 | Number(11,0) | What is the count of male only sports? Migrated from [Schools.CRDC_InterschSportsM]. |
InterschTeamsF | 16.1.0 | Number(11,0) | What is the count of female only teams? Migrated from [Schools.CRDC_InterschTeamsF]. |
InterschTeamsM | 16.1.0 | Number(11,0) | What is the count of male only teams? Migrated from [Schools.CRDC_InterschTeamsM]. |
MagnetSchoolOrProgram_YN | 16.1.0 | Varchar2(1) | Is this school either a magnet school or a school operating a magnet program within the school? Migrated from [Schools.CRDC_MagnetSchoolOrProgram_YN]. |
ProvidesUngraded_YN | 16.1.0 | Varchar2(1) | Does this school have ungraded students? Migrated from [Schools.CRDC_ProvidesUngraded_YN]. |