CRDC Specific to Michigan: S_SCH_CRDC_X (ver 17.1.0)
This table is an extension of the [Schools] table and provides CRDC-specific fields for Michigan. 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 | 17.1.0 | Number(10,0) | Primary Key. |
AllMagnetOnly_YN | 17.1.0 | Varchar2(1) | Indicates the entire school population participates in the magnet school program. |
AlternativeSchool_YN | 17.1.0 | Varchar2(1) | Indicates if this is an alternative school. |
AlternativeSchoolAcademic_TF | 17.1.0 | Number(1,0) | Indicates if the alternative school is designed to meet the needs of students with academic difficulties. |
AlternativeSchoolDiscipline_TF | 17.1.0 | Number(1,0) | Indicates if the alternative school is designed to meet the needs of students with discipline problems. |
APSelfParticipate_YN | 17.1.0 | Varchar2(1) | Indicates if the school permits students to enroll through self-selection for all AP courses. |
CharterSchool_YN | 17.1.0 | Varchar2(1) | Indicates if this is a charter school. |
ForDisabilities_YN | 17.1.0 | Varchar2(1) | Indicates if this is a special education school. |
InterschAthletics_YN | 17.1.0 | Varchar2(1) | Indicates if the school has any students who participate in single-sex interscholastic athletics. |
InterschSportsF | 17.1.0 | Number(11,0) | Count of female only sports. |
InterschSportsM | 17.1.0 | Number(11,0) | Count of male only sports. |
InterschTeamsF | 17.1.0 | Number(11,0) | Count of female only teams. |
InterschTeamsM | 17.1.0 | Number(11,0) | Count of male only teams. |
InterschParticipantsF | 17.1.0 | Number(11,0) | Count of female only participants on teams. |
InterschParticipantsM | 17.1.0 | Number(11,0) | Count of male only participants on teams. |
MagnetSchoolOrProgram_YN | 17.1.0 | Varchar2(1) | Indicates if this a magnet school or a school operating a magnet program within a school. |
ProvidesUngraded_YN | 17.1.0 | Varchar2(1) | Indicates if the school has ungraded students. |