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