Skip to main content
Skip table of contents

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


Data Type


SchoolsDCID17.1.0Number(10,0)Primary Key.
AllMagnetOnly_YN17.1.0Varchar2(1)Indicates the entire school population participates in the magnet school program.
AlternativeSchool_YN17.1.0Varchar2(1)Indicates if this is an alternative school.
AlternativeSchoolAcademic_TF17.1.0Number(1,0)Indicates if the alternative school is designed to meet the needs of students with academic difficulties.
AlternativeSchoolDiscipline_TF17.1.0Number(1,0)Indicates if the alternative school is designed to meet the needs of students with discipline problems.
APSelfParticipate_YN17.1.0Varchar2(1)Indicates if the school permits students to enroll through self-selection for all AP courses.
CharterSchool_YN17.1.0Varchar2(1)Indicates if this is a charter school.
ForDisabilities_YN17.1.0Varchar2(1)Indicates if this is a special education school.
InterschAthletics_YN17.1.0Varchar2(1)Indicates if the school has any students who participate in single-sex interscholastic athletics.
InterschSportsF17.1.0Number(11,0)Count of female only sports.
InterschSportsM17.1.0Number(11,0)Count of male only sports.
InterschTeamsF17.1.0Number(11,0)Count of female only teams.
InterschTeamsM17.1.0Number(11,0)Count of male only teams.
InterschParticipantsF17.1.0Number(11,0)Count of female only participants on teams.
InterschParticipantsM17.1.0Number(11,0)Count of male only participants on teams.
MagnetSchoolOrProgram_YN17.1.0Varchar2(1)Indicates if this a magnet school or a school operating a magnet program within a school.
ProvidesUngraded_YN17.1.0Varchar2(1)Indicates if the school has ungraded students.
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.