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