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