S_SCH_CRDC_X (ver 17.6.0)
This table is an extension of the [Schools] table and provides CRDC-specific fields for Tennessee. 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 | 17.6.0 | Number(10,0) | Primary key. |
| AllMagnetOnly_YN | 17.6.0 | Varchar2(1) | The entire school population participate in the magnet school program. Migrated from Schools.CRDC_AllMagnetOnly_YN. |
| AlternativeSchool_YN | 17.6.0 | Varchar2(1) | Alternative school. Migrated from Schools.CRDC_AlternativeSchool_YN. |
| AlternativeSchoolAcademic_TF | 17.6.0 | Number(1,0) | Students with Academic Difficulties. Migrated from Schools.CRDC_AlternativeSchoolAcademic_TF. |
| AlternativeSchoolDiscipline_TF | 17.6.0 | Number(1,0) | Students with Discipline Problems. Migrated from Schools.CRDC_AlternativeSchoolDiscipline_TF. |
| APSelfParticipate_YN | 17.6.0 | Varchar2(1) | Enrollment via self-selection by students permitted for all AP courses offered by the school. Migrated from Schools.CRDC_APSelfParticipate_YN. |
| CharterSchool_YN | 17.6.0 | Varchar2(1) | Is this school a charter school. Migrated from Schools.CRDC_CharterSchool_YN. |
| ForDisabilities_YN | 17.6.0 | Varchar2(1) | Is this school a special education school. Migrated from Schools.CRDC_ForDisabilities_YN. |
| InterschAthletics_YN | 17.6.0 | Varchar2(1) | Students who participate in single-sex interscholastic athletics. Migrated from Schools.CRDC_InterschAthletics_YN. |
| InterschParticipantsF | 17.6.0 | Number(10,0) | The count of female only participants on teams. Migrated from Schools.CRDC_InterschParticipantsF. |
| InterschParticipantsM | 17.6.0 | Number(10,0) | The count of male only participants on teams. Migrated from Schools.CRDC_InterschParticipantsM. |
| InterschSportsF | 17.6.0 | Number(10,0) | The count of female only sports. Migrated from Schools.CRDC_InterschSportsF. |
| InterschSportsM | 17.6.0 | Number(10,0) | The count of male only sports. Migrated from Schools.CRDC_InterschSportsM. |
| InterschTeamsF | 17.6.0 | Number(10,0) | The count of female only teams. Migrated from Schools.CRDC_InterschTeamsF. |
| InterschTeamsM | 17.6.0 | Number(10,0) | The count of female only teams. Migrated from Schools.CRDC_InterschTeamsM. |
| MagnetSchoolOrProgram_YN | 17.6.0 | Varchar2(1) | The School either a magnet school or a school operating a magnet program within the school. Migrated from Schools.CRDC_MagentSchoolOrProgram_YN. |
| ProvidesUngraded_YN | 17.6.0 | Varchar2(1) | The School have ungraded students. Migrated from Schools.CRDC_ProvidesUngraded_YN. |