S_NC_RPT_CRDC_SCH_DETAIL_2 (ver 13.6.0)
This table is a stand alone table that stores information about the School detail for the Civil Rights Data Collection Part 2.
Column Name | Version | Data Type | Description |
---|---|---|---|
CORPORALPUNISHMENT | 13.6.0 | NUMBER(1,0) | Indicates that the school allows corporal punishment. |
CORPORALPUNISHMENTPK | 13.6.0 | NUMBER(10,0) | This counts as an instance of PK Corporal Punishment. |
CORPORALPUNISHMENTPKDIS | 13.6.0 | NUMBER(10,0) | This counts as an instance of PK Corporal Punishment with disability. |
CORPORALPUNISHWITHDIS | 13.6.0 | NUMBER(10,0) | This counts as an instance of Corporal Punishment grade KG and older. |
CORPORALPUNISHWITHOUTDIS | 13.6.0 | NUMBER(10,0) | This counts as an instance of Corporal Punishment grade KG and older with disability. |
HASCREDITRECOVERYSTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates the school has Credit Recovery students. In 17-18 this field was moved to Sch Detail Part 1. |
HASRETAINEDINGRADE1 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 1. |
HASRETAINEDINGRADE10 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 10. |
HASRETAINEDINGRADE11 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 11. |
HASRETAINEDINGRADE12 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 12. |
HASRETAINEDINGRADE13 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 13. After 15-16 this field is no longer collected. |
HASRETAINEDINGRADE2 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 2. |
HASRETAINEDINGRADE3 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 3. |
HASRETAINEDINGRADE4 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 4.. |
HASRETAINEDINGRADE5 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 5. |
HASRETAINEDINGRADE6 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 6 |
HASRETAINEDINGRADE7 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 7. |
HASRETAINEDINGRADE8 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 8. |
HASRETAINEDINGRADE9 | 13.6.0 | NUMBER(1,0) | Has students retained in grade 9. |
HASRETAINEDINGRADEKG | 13.6.0 | NUMBER(1,0) | Has students retained in grade KG. |
JUSTICEFACILTYPE | 13.6.0 | VARCHAR2(100) | Indicates the school is a justice facility type. A indicates a Pre-adjudication/Pre-conviction facility. B indicates a Post-adjudication/Pre-conviction facility. C indicates Pre- and Post-adjudication/conviction facility. |
JUSTICETOTHRSWEEKEDUPROG | 13.6.0 | NUMBER(6,0) | The number hours the justice facility is in operation per week. |
JUSTICETOTREGSCHDAYS | 13.6.0 | NUMBER(6,0) | The number of regular school days the justice facility is in operation. |
JUSTICETOTSTU15TO30DAYS | 13.6.0 | NUMBER(6,0) | The number of students that attended the justice facility 15 to 30 days during the year. |
JUSTICETOTSTU31TO90DAYS | 13.6.0 | NUMBER(6,0) | The number of students that attended the justice facility 31 - 90 days during the year. |
JUSTICETOTSTU91TO180DAYS | 13.6.0 | NUMBER(6,0) | The number of students that attended the justice facility 91 - 180 days during the year. |
JUSTICETOTSTULT15DAYS | 13.6.0 | NUMBER(6,0) | The number of students that attended the justice facility less than 15 days during the year. |
JUSTICETOTSTUMT180DAYS | 13.6.0 | NUMBER(6,0) | The number of students that attended the justice facility more than 180 days during the year. |
NUMALLEGHARASSDISABILITY | 13.6.0 | NUMBER(6,0) | The number of alleged instances of harassment or bullying based on disability. |
NUMALLEGHARASSRACE | 13.6.0 | NUMBER(6,0) | The number of alleged instances of harassment or bullying based on race. |
NUMALLEGHARASSSEX | 13.6.0 | NUMBER(6,0) | The number of alleged instances of harassment or bullying based on gender. |
NUMALLEGHARASSSEXUALORI | 13.6.0 | NUMBER(10,0) | The number of alleged instances of harassment or bullying based on sexual orientation. |
NUMALLEGHARASSSEXUALRELIGION | 13.6.0 | NUMBER(10,0) | The number of alleged instances of harassment or bullying based on religion. |
NUMCREDITRECOVERYSTUDENTS | 13.6.0 | NUMBER(10,0) | The number of students in a credit recovery program. Moved to Sch Detail 1 in 17-18. |
NUMIDEAMECHRESTR | 13.6.0 | NUMBER(6,0) | The number of IDEA students with mechanical restraints. |
NUMIDEAPHYSRESTR | 13.6.0 | NUMBER(6,0) | The number of IDEA students with physical restraints. |
NUMIDEASECLUSION | 13.6.0 | NUMBER(6,0) | The number of IDEA students with seclusion restraints. |
NUMINTERSCHPRTCPTSFEMALE | 13.6.0 | NUMBER(6,0) | The number of female students that participated in interscholastic sports. |
NUMINTERSCHPRTCPTSMALE | 13.6.0 | NUMBER(6,0) | The number of male students that participated in interscholastic sports. |
NUMINTERSCHPRTCPTSTOTAL | 13.6.0 | NUMBER(6,0) | The total number of students that participated in interscholastic sports. |
NUMINTERSCHSPORTSFEMALE | 13.6.0 | NUMBER(6,0) | The number of female interscholastic sports offered at the school. |
NUMINTERSCHSPORTSMALE | 13.6.0 | NUMBER(6,0) | The number of male interscholastic sports offered at the school. |
NUMINTERSCHSPORTSTOTAL | 13.6.0 | NUMBER(6,0) | The total number of single gender interscholastic sports offered at the school. |
NUMINTERSCHTEAMSFEMALE | 13.6.0 | NUMBER(6,0) | The number of female team interscholastic sports offered at the school. |
NUMINTERSCHTEAMSMALE | 13.6.0 | NUMBER(6,0) | The number of male team interscholastic sports offered at the school. |
NUMINTERSCHTEAMSTOTAL | 13.6.0 | NUMBER(6,0) | The total number of single gender team interscholastic sports offered at the school. |
NUMNONDISABLEMECHRESTR | 13.6.0 | NUMBER(6,0) | The number of non-IDEA students with mechanical restraints. |
NUMNONDISABLEPHYSRESTR | 13.6.0 | NUMBER(6,0) | The number of non-IDEA students with physical restraints. |
NUMNONDISABLESECLUSION | 13.6.0 | NUMBER(6,0) | The number of non-IDEA students with seclusion restraints. |
NUMOFFATTEMPRAPE | 13.6.0 | NUMBER(10,0) | The number of attempted rape offenses. |
NUMOFFHOMICIDE | 13.6.0 | NUMBER(10,0) | The number of homicide offenses. |
NUMOFFINVSHOOTING | 13.6.0 | NUMBER(10,0) | The number of offenses involving a shooting. |
NUMOFFPHYATTWITHFIREARM | 13.6.0 | NUMBER(10,0) | The number of physical attack with a firearm offenses. |
NUMOFFPHYATTWITHOUTWEAPON | 13.6.0 | NUMBER(10,0) | The number of physical attack without a weapon offenses. |
NUMOFFPHYATTWITHWEAPON | 13.6.0 | NUMBER(10,0) | The number of physical attack with a weapon offenses. |
NUMOFFPOSSFIREARM | 13.6.0 | NUMBER(10,0) | The number of possession of a firearm offenses. |
NUMOFFROBFIREARM | 13.6.0 | NUMBER(10,0) | The number of robbery with a firearm offenses. |
NUMOFFROBWEAPON | 13.6.0 | NUMBER(10,0) | The number of robbery with a weapon offenses. |
NUMOFFROBWITHOUTWEAPON | 13.6.0 | NUMBER(10,0) | The number of robbery without a weapon offenses. |
NUMOFFSEXASSAULT | 13.6.0 | NUMBER(10,0) | The number of sexual assault offenses. |
NUMOFFTHREATATTWITHFIREARM | 13.6.0 | NUMBER(10,0) | The number of threats of attack with a firearm. |
NUMOFFTHREATATTWITHOUTWEAPON | 13.6.0 | NUMBER(10,0) | The number of threats of attack without a weapon. |
NUMOFFTHREATATTWITHWEAPON | 13.6.0 | NUMBER(10,0) | The number of threats of attack with a weapon. |
NUMSEC504MECHRESTR | 13.6.0 | NUMBER(6,0) | The number of 504 students with a mechanical restraint. |
NUMSEC504PHYSRESTR | 13.6.0 | NUMBER(6,0) | The number of 504 students with a physical restraint. |
NUMSEC504SECLUSION | 13.6.0 | NUMBER(6,0) | The number of 504 students with a seclusion restraint. |
NUMSUTALGGRADE7 | 13.6.0 | NUMBER(10,0) | The number of students passing Algebra I in Grade 7. In 17-18 moved to Sch Detail 1. |
PART2SCHOOLCOMMENTS | 13.6.0 | VARCHAR2(4000) | No longer collected. |
PROVIDESGRADE1 | 13.6.0 | NUMBER(1,0) | The school offers grade 1. |
PROVIDESGRADE10 | 13.6.0 | NUMBER(1,0) | The school offers grade 10. |
PROVIDESGRADE11 | 13.6.0 | NUMBER(1,0) | The school offers grade 11. |
PROVIDESGRADE12 | 13.6.0 | NUMBER2(1,0) | The school offers grade 12. |
PROVIDESGRADE13 | 13.6.0 | NUMBER(1,0) | The school offers grade 13. |
PROVIDESGRADE2 | 13.6.0 | NUMBER(1,0) | The school offers grade 2. |
PROVIDESGRADE3 | 13.6.0 | NUMBER(1,0) | The school offers grade 3. |
PROVIDESGRADE4 | 13.6.0 | NUMBER(1,0) | The school offers grade 4. |
PROVIDESGRADE5 | 13.6.0 | NUMBER(1,0) | The school offers grade 5. |
PROVIDESGRADE6 | 13.6.0 | NUMBER(1,0) | The school offers grade 6. |
PROVIDESGRADE7 | 13.6.0 | NUMBER(1,0) | The school offers grade 7. |
PROVIDESGRADE8 | 13.6.0 | NUMBER(1,0) | The school offers grade 8. |
PROVIDESGRADE9 | 13.6.0 | NUMBER(1,0) | The school offers grade 9. |
PROVIDESINTERSCHATHLETICS | 13.6.0 | NUMBER(1,0) | The school offers insterscholastic athletics. |
PROVIDESKG | 13.6.0 | NUMBER(1,0) | The school offers grade KG. |
PROVIDESPREKG | 13.6.0 | NUMBER(1,0) | The school offers grade PreK. |
PROVIDESUNGRADED | 13.6.0 | NUMBER(1,0) | The school has ungraded students. |
RPT_RUN_ID | 13.6.0 | NUMBER(10,0) | Indicates the unique report run ID for this run. This links to the S_NC_RPT_RUN table to identify the LEA, School, Report Type, Instance ID, and Year ID. |
SCHOOLID | 13.6.0 | NUMBER(10,0) | The internal number for the school. |
SCHOOLNAME | 13.6.0 | VARCHAR2(60) | The name of the school. |
SUSPENSIONPK | 13.6.0 | NUMBER(10,0) | The number of suspensions for prekindergarten students. |
SUSPENSIONPKDIS | 13.6.0 | NUMBER(10,0) | The number of suspensions for prekindergarten students with disabilities. |
SUSPENSIONWITHDIS504 | 13.6.0 | NUMBER(10,0) | The number of suspensions for 504 studnets. |
SUSPENSIONWITHDISIDEA | 13.6.0 | NUMBER(10,0) | The number of suspensions for students with disabilities. |
SUSPENSIONWITHOUTDIS | 13.6.0 | NUMBER(10,0) | The number of suspensions for students without disabilities. |