Skip to main content
Skip table of contents

CRDC Specific to Connecticut: S_SCH_CRDC_X (ver 15.7.3)

This table is an extension of the [Schools] table and provides CRDC-specific fields for Connecticut. 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




Number (10,0)

Primary key that relates the extended table back to the [Schools] table.



VarChar2 (1)

Indicates whether or not the entire school population participates in a magnet school program. Migrates from [Schools]CRDC_AllMagnetOnly_YN.
AlternativeSchool_YN15.7.3VarChar2 (1)Indicates whether or not the school is an alternative school. Migrates from [Schools]CRDC_AlternativeSchool_YN.
AlternativeSchoolAcademic_TF15.7.3Number (1,0)Indicates whether or not the alternative school serves students with academic difficulties. Migrates from [Schools]CRDC_AlternativeSchoolAcademic_TF.
AlternativeSchoolDiscipline_TF15.7.3Number (1,0)Indicates whether or not the alternative school serves students with discipline problems. Migrates from [Schools]CRDC_AlternativeSchoolDiscipline_TF.
APSelfParticipate_YN15.7.3VarChar2 (1)Indicates whether or not the students can self-select to participate in AP courses. Migrates from [Schools]CRDC_APSelfParticipate_YN.
CharterSchool_YN15.7.3VarChar2 (1)Indicates whether or not the school is a charter school. Migrates from [Schools]CRDC_CharterSchool_YN.
ForDisabilities_YN15.7.3VarChar2 (1)Indicates whether or not the school is a special education school. Migrates from [Schools]CRDC_ForDisabilities_YN.
InterschAthletics_YN15.7.3VarChar2 (1)Indicates whether or not the school has interscholastic athletics. Migrates from [Schools]CRDC_InterschAthletics_YN.
InterschParticipantsF15.7.3Number (11,0)Count of interscholastic female only participants. Migrates from [Schools]CRDC_InterschParticipantsF.
InterschParticipantsM15.7.3Number (11,0)Count of interscholastic male only participants. Migrates from [Schools]CRDC_InterschParticipantsM.
InterschSportsF15.7.3Number (11,0)Count of interscholastic female only sports. Migrates from [Schools]CRDC_InterschSportsF.
InterschSportsM15.7.3Number (11,0)Count of interscholastic male only sports. Migrates from [Schools]CRDC_InterschSportsM.
InterschTeamsF15.7.3Number (11,0)Count of interscholastic female only teams. Migrates from [Schools]CRDC_InterschTeamsF.
InterschTeamsM15.7.3Number (11,0)Count of interscholastic male only teams. Migrates from [Schools]CRDC_InterschTeamsM.
MagnetSchoolOrProgram_YN15.7.3VarChar2 (1)Indicates whether or not the school is a magnet school or operates a magnet program within the school. Migrates from [Schools]CRDC_MagentSchoolOrProgram_YN.
ProvidesUngraded_YN15.7.3VarChar2 (1)Indicates whether or not the school has ungraded students. Migrates 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.