S_SCH_CRDC_X (ver 16.6.0)
This table is an extension of the [Schools] table and provides CRDC-specific fields for Virginia. 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 | 16.6.0 | Number(10,0) | Foreign Key to the Schools table. |
| AllMagnetOnly_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_AllMagnetOnly_YN |
| AlternativeSchool_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_AlternativeSchool_YN |
| AlternativeSchoolAcademic_TF | 16.6.0 | Number(1,0) | Migrated from: [Schools]CRDC_AlternativeSchoolAcademic_TF |
| AlternativeSchoolDiscipline_TF | 16.6.0 | Number(1,0) | Migrated from: [Schools]CRDC_AlternativeSchoolDiscipline_TF |
| APSelfParticipate_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_APSelfParticipate_YN |
| CharterSchool_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_CharterSchool_YN |
| ForDisabilities_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_ForDisabilities_YN |
| InterschAthletics_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_InterschAthletics_YN |
| InterschParticipantsF | 16.6.0 | Number(11,0) | Migrated from: [Schools]CRDC_InterschParticipantsF |
| InterschParticipantsM | 16.6.0 | Number(11,0) | Migrated from: [Schools]CRDC_InterschParticipantsM |
| InterschSportsF | 16.6.0 | Number(11,0) | Migrated from: [Schools]CRDC_InterschSportsF |
| InterschSportsM | 16.6.0 | Number(11,0) | Migrated from: [Schools]CRDC_InterschSportsM |
| InterschTeamsF | 16.6.0 | Number(11,0) | Migrated from: [Schools]CRDC_InterschTeamsF |
| InterschTeamsM | 16.6.0 | Number(11,0) | Migrated from: [Schools]CRDC_InterschTeamsM |
| MagnetSchoolOrProgram_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_MagentSchoolOrProgram_YN |
| ProvidesUngraded_YN | 16.6.0 | Varchar2(1) | Migrated from: [Schools]CRDC_ProvidesUngraded_YN |