Skip to main content
Skip table of contents

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


Data Type





Primary key.

AllMagnetOnly_YN17.6.0Varchar2(1)The entire school population participate in the magnet school program. Migrated from Schools.CRDC_AllMagnetOnly_YN.
AlternativeSchool_YN17.6.0Varchar2(1)Alternative school. Migrated from Schools.CRDC_AlternativeSchool_YN.
AlternativeSchoolAcademic_TF17.6.0Number(1,0)Students with Academic Difficulties. Migrated from Schools.CRDC_AlternativeSchoolAcademic_TF.
AlternativeSchoolDiscipline_TF17.6.0Number(1,0)Students with Discipline Problems. Migrated from Schools.CRDC_AlternativeSchoolDiscipline_TF.
APSelfParticipate_YN17.6.0Varchar2(1)Enrollment via self-selection by students permitted for all AP courses offered by the school. Migrated from Schools.CRDC_APSelfParticipate_YN.
CharterSchool_YN17.6.0Varchar2(1)Is this school a charter school. Migrated from Schools.CRDC_CharterSchool_YN.
ForDisabilities_YN17.6.0Varchar2(1)Is this school a special education school. Migrated from Schools.CRDC_ForDisabilities_YN.
InterschAthletics_YN17.6.0Varchar2(1)Students who participate in single-sex interscholastic athletics. Migrated from Schools.CRDC_InterschAthletics_YN.
InterschParticipantsF17.6.0Number(10,0)The count of female only participants on teams. Migrated from Schools.CRDC_InterschParticipantsF.
InterschParticipantsM17.6.0Number(10,0)The count of male only participants on teams. Migrated from Schools.CRDC_InterschParticipantsM.
InterschSportsF17.6.0Number(10,0)The count of female only sports. Migrated from Schools.CRDC_InterschSportsF.
InterschSportsM17.6.0Number(10,0)The count of male only sports. Migrated from Schools.CRDC_InterschSportsM.
InterschTeamsF17.6.0Number(10,0)The count of female only teams. Migrated from Schools.CRDC_InterschTeamsF.
InterschTeamsM17.6.0Number(10,0)The count of female only teams. Migrated from Schools.CRDC_InterschTeamsM.
MagnetSchoolOrProgram_YN17.6.0Varchar2(1)The School either a magnet school or a school operating a magnet program within the school. Migrated from Schools.CRDC_MagentSchoolOrProgram_YN.
ProvidesUngraded_YN17.6.0Varchar2(1)The School have ungraded students. Migrated from Schools.CRDC_ProvidesUngraded_YN.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.