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 | Version | Data Type | Description |
|---|---|---|---|
SchoolsDCID | 15.7.3 | Number (10,0) | Primary key that relates the extended table back to the [Schools] table. |
| AllMagnetOnly_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not the entire school population participates in a magnet school program. Migrates from [Schools]CRDC_AllMagnetOnly_YN. |
| AlternativeSchool_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not the school is an alternative school. Migrates from [Schools]CRDC_AlternativeSchool_YN. |
| AlternativeSchoolAcademic_TF | 15.7.3 | Number (1,0) | Indicates whether or not the alternative school serves students with academic difficulties. Migrates from [Schools]CRDC_AlternativeSchoolAcademic_TF. |
| AlternativeSchoolDiscipline_TF | 15.7.3 | Number (1,0) | Indicates whether or not the alternative school serves students with discipline problems. Migrates from [Schools]CRDC_AlternativeSchoolDiscipline_TF. |
| APSelfParticipate_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not the students can self-select to participate in AP courses. Migrates from [Schools]CRDC_APSelfParticipate_YN. |
| CharterSchool_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not the school is a charter school. Migrates from [Schools]CRDC_CharterSchool_YN. |
| ForDisabilities_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not the school is a special education school. Migrates from [Schools]CRDC_ForDisabilities_YN. |
| InterschAthletics_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not the school has interscholastic athletics. Migrates from [Schools]CRDC_InterschAthletics_YN. |
| InterschParticipantsF | 15.7.3 | Number (11,0) | Count of interscholastic female only participants. Migrates from [Schools]CRDC_InterschParticipantsF. |
| InterschParticipantsM | 15.7.3 | Number (11,0) | Count of interscholastic male only participants. Migrates from [Schools]CRDC_InterschParticipantsM. |
| InterschSportsF | 15.7.3 | Number (11,0) | Count of interscholastic female only sports. Migrates from [Schools]CRDC_InterschSportsF. |
| InterschSportsM | 15.7.3 | Number (11,0) | Count of interscholastic male only sports. Migrates from [Schools]CRDC_InterschSportsM. |
| InterschTeamsF | 15.7.3 | Number (11,0) | Count of interscholastic female only teams. Migrates from [Schools]CRDC_InterschTeamsF. |
| InterschTeamsM | 15.7.3 | Number (11,0) | Count of interscholastic male only teams. Migrates from [Schools]CRDC_InterschTeamsM. |
| MagnetSchoolOrProgram_YN | 15.7.3 | VarChar2 (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_YN | 15.7.3 | VarChar2 (1) | Indicates whether or not the school has ungraded students. Migrates from [Schools]CRDC_ProvidesUngraded_YN. |