S_NC_CRDC_SCHOOLS (ver 13.6.0)
This table is an extension of the Schools table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ABILITY_GROUPED_MATHERLA | 13.6.0 | VARCHAR2(1) | No longer used. |
| ALTERNATIVE_SCHOOL | 13.6.0 | VARCHAR2(1) | Indicates this is an alternative school. |
| ALTERNATIVE_SCHOOL_ACADEMIC | 13.6.0 | VARCHAR2(1) | Indicates this is an alternative school for academic purposes. |
| ALTERNATIVE_SCHOOL_DISCIPLINE | 13.6.0 | VARCHAR2(1) | Indicates this is an alternative school for discipline. |
| ALTERNATIVE_SCHOOL_OTHER | 13.6.0 | VARCHAR2(1) | No longer used. |
| AP_SELF_PARTICIPATE | 13.6.0 | VARCHAR2(1) | Indicates that students are allowed to self-participate in AP classes. |
| CHARTER_SCHOOL | 13.6.0 | VARCHAR2(1) | Indicates this is a charter school. |
| CORPORAL_PUNISHMENT | 14.7.0 | VARCHAR2(1) | Indicates this school allows corporal punishment. |
| CRDC_NONLEAFACILITY_YN | 16.8.0 | VARCHAR2(1) | Indicates this is a non-LEA facility. |
| CREDIT_RECOVERY_COURSE | 14.7.0 | VARCHAR2(1) | Indicates this school offers credit recovery courses. |
| DISABILITY_FOCUSED | 13.6.0 | VARCHAR2(1) | Indicates this school focuses on students with disabilities. |
| DISTANCE_LEARNING_COURSE | 14.7.0 | VARCHAR2(1) | Indicates this school offers distance learning courses. |
| DUAL_CREDIT_COURSE | 14.7.0 | VARCHAR2(1) | Indicates this school offers dual credit courses. |
| EXCLUDE_CRDC | 16.8.0 | VARCHAR2(1) | Indicates this school is excluded from the CRDC |
| GIFTED_TALENTED | 13.6.0 | VARCHAR2(1) | Indicates this school offers a gifted and talented program. |
| HOMICIDE_DEATH | 14.7.0 | VARCHAR2(1) | Indicates this school had a homicide. |
| INTERSCH_ATHLETICS | 14.7.0 | VARCHAR2(1) | Indicates if the school offers interscholastic athletics. |
| INTERSCH_PARTIC_F | 14.7.0 | NUMBER(11,0) | The number of female interscholastic athletes. |
| INTERSCH_PARTIC_M | 14.7.0 | NUMBER(11,0) | The number of male interscholastic athletes. |
| INTERSCH_SPORTS_F | 14.7.0 | NUMBER(11,0) | The number of female only individual sports. |
| INTERSCH_SPORTS_M | 14.7.0 | NUMBER(11,0) | The number of male only individual sports. |
| INTERSCH_TEAMS_F | 14.7.0 | NUMBER(11,0) | the number of female only team sports. |
| INTERSCH_TEAMS_M | 14.7.0 | NUMBER(11,0) | The number of male only team sports. |
| INSTRUCTIONTYPE | VARCHAR2(1) | ||
| JUSTICE_FACILITY_TYPE | 14.7.0 | VARCHAR2(2) | Indicates if this school is a justice facility. |
| LAW_ENFORCEMENT_OFFICERS | 14.7.0 | VARCHAR2(1) | No longer used. |
| MAGNET_ONLY | 13.6.0 | VARCHAR2(1) | Indicates if this is a magnet school. |
| MAGNET_SCHOOL_OR_PROGRAM | 13.6.0 | VARCHAR2(1) | Indicates if the school serves only magnet students. |
| PRE_KG_IDEA_ONLY | 14.7.0 | VARCHAR2(1) | No longer used. |
| PRE_KG_NON_IDEA_AGE_3 | 14.7.0 | VARCHAR2(1) | No longer used. |
| PRE_KG_NON_IDEA_AGE_4 | 14.7.0 | VARCHAR2(1) | No longer used. |
| PRE_KG_NON_IDEA_AGE_5 | 14.7.0 | VARCHAR2(1) | No longer used. |
| PROVIDES_UNGRADED | 13.6.0 | VARCHAR2(1) | Indicates the school has ungraded students. |
| SCHOOLSDCID | 13.6.0 | NUMBER(19,0) | Foreign key. |
| SCHOOL_PART1_COMMENTS | 14.7.0 | VARCHAR2(500) | No longer used. |
| SCHOOL_PART2_COMMENTS | 14.7.0 | VARCHAR2(500) | No longer used. |
| SHOOTING | 14.7.0 | VARCHAR2(1) | Indicates a shooting occurred at the school. |
| SINGLESEXCLASSESINCOED | 14.7.0 | VARCHAR2(1) | indicates the school offers single sex academic classes. |
| UNGRADED | 14.7.0 | VARCHAR2(1) | Indicates the type of students that are ungraded. |
| VIRTUALINSTRUCTIONTYPE | VARCHAR2(1) |