This table is an extension of the [Schools] table and provides CRDC-specific fields for Maine. 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.2.0 |
Number(10,0) |
Foreign Key to the Schools table. |
|
AllMagnetOnly_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the entire school population participates in a magnet school program. Migrated from: [Schools]CRDC_AllMagnetOnly_YN |
|
AlternativeSchool_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the school is an alternative school. Migrated from: [Schools]CRDC_AlternativeSchool_YN |
|
AlternativeSchoolAcademic_TF |
17.2.0 |
Number(1,0) |
Indicates whether or not the alternative school serves students with academic difficulties. Migrated from: [Schools]CRDC_AlternativeSchoolAcademic_TF |
|
AlternativeSchoolDiscipline_TF |
17.2.0 |
Number(1,0) |
Indicates whether or not the alternative school serves students with discipline problems. Migrated from: [Schools]CRDC_AlternativeSchoolDiscipline_TF |
|
APSelfParticipate_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the students can self-select to participate in AP courses. Migrated from: [Schools]CRDC_APSelfParticipate_YN |
|
CharterSchool_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the school is a charter school. Migrated from: [Schools]CRDC_CharterSchool_YN |
|
ForDisabilities_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the school is a special education school. Migrated from: [Schools]CRDC_ForDisabilities_YN |
|
InterschAthletics_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the school has interscholastic athletics. Migrated from: [Schools]CRDC_InterschAthletics_YN |
|
InterschParticipantsF |
17.2.0 |
Number(11,0) |
Count of interscholastic female only participants. Migrated from: [Schools]CRDC_InterschParticipantsF |
|
InterschParticipantsM |
17.2.0 |
Number(11,0) |
Count of interscholastic male only participants. Migrated from: [Schools]CRDC_InterschParticipantsM |
|
InterschSportsF |
17.2.0 |
Number(11,0) |
Count of interscholastic female only sports. Migrated from: [Schools]CRDC_InterschSportsF |
|
InterschSportsM |
17.2.0 |
Number(11,0) |
Count of interscholastic male only sports. Migrated from: [Schools]CRDC_InterschSportsM |
|
InterschTeamsF |
17.2.0 |
Number(11,0) |
Count of interscholastic female only teams. Migrated from: [Schools]CRDC_InterschTeamsF |
|
InterschTeamsM |
17.2.0 |
Number(11,0) |
Count of interscholastic male only teams. Migrated from: [Schools]CRDC_InterschTeamsM |
|
MagnetSchoolOrProgram_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the school is a magnet school or operates a magnet program within the school. Migrated from: [Schools]CRDC_MagentSchoolOrProgram_YN |
|
ProvidesUngraded_YN |
17.2.0 |
VarChar2(1) |
Indicates whether or not the school has ungraded students. Migrated from: [Schools]CRDC_ProvidesUngraded_YN |