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. |