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