CRDC: S_SCH_CRDC_X (ver 15.11.0)
This table is an extension of the [Schools] table and provides CRDC-specific fields for Alaska. 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.11.0 | Number(10,0) | Primary Key |
AllMagnetOnly_YN | 15.11.0 | Varchar2(1) | AllMagnetOnly. Migrated from [Schools.CRDC_AllMagnetOnly_YN]. |
| AlternativeSchool_YN | 15.11.0 | Varchar2(1) | Is an alternative school. Migrated from [Schools.CRDC_AlternativeSchool_YN]. |
| AlternativeSchoolAcademic_TF | 15.11.0 | Boolean | Students with Academic Difficulties. Migrated from [Schools.CRDC_AlternativeSchoolAcademic_TF]. |
| AlternativeSchoolDiscipline_TF | 15.11.0 | Boolean | Students with Discipline Problems. Migrated from [Schools.CRDC_AlternativeSchoolDiscipline_TF]. |
| APSelfParticipate_YN | 15.11.0 | Varchar2(1) | Self-selection for all AP. Migrated from [Schools.CRDC_ForDisabilities_YN]. |
| CharterSchool_YN | 15.11.0 | Varchar2(1) | Is a charter school. Migrated from [Schools.CRDC_CharterSchool_YN]. |
| ForDisabilities_YN | 15.11.0 | Varchar2(1) | Is a special education school. Migrated from [Schools.CRDC_ForDisabilities_YN]. |
| InterschAthletics_YN | 15.11.0 | Varchar2(1) | Interscholastic athletics. Migrated from [Schools.CRDC_InterschAthletics_YN]. |
| InterschParticipantsF | 15.11.0 | Number(10,0) | Female only participants count. Migrated from [Schools.CRDC_InterschParticipantsF]. |
| InterschParticipantsM | 15.11.0 | Number(10,0) | Male only participants count. Migrated from [Schools.CRDC_InterschParticipantsM]. |
| InterschSportsF | 15.11.0 | Number(10,0) | Female only sports count. Migrated from [Schools.CRDC_InterschSportsF]. |
| InterschSportsM | 15.11.0 | Number(10,0) | Male only sports count. Migrated from Schools.CRDC_InterschSportsM. |
| InterschTeamsF | 15.11.0 | Number(10,0) | Female only teams count. Migrated from [Schools.CRDC_InterschTeamsF]. |
| InterschTeamsM | 15.11.0 | Number(10,0) | Male only teams count. Migrated from [Schools.CRDC_InterschTeamsM]. |
| MagnetSchoolOrProgram_YN | 15.11.0 | Varchar2(1) | Is a magnet school or operating a magnet program. Migrated from [Schools.CRDC_MagentSchoolOrProgram_YN]. |
| ProvidesUngraded_YN | 15.11.0 | Varchar2(1) | Provides ungraded students. Migrated from [Schools.CRDC_ProvidesUngraded_YN]. |