S_NC_RPT_CRDC_SCH_DETAIL_1 (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 1.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ABILITYGROUPEDMATHERLA | 13.6.0 | NUMBER(1,0) | No longer collected. |
| ALLMAGNETONLY | 13.6.0 | NUMBER(1,0) | Indicates if the only students enrolled at the campus are magnet students. |
| ALTERNATIVESCHOOL | 13.6.0 | NUMBER(1,0) | Indicates if the school is an alternative school |
| ALTERNATIVESCHOOLACADEMIC | 13.6.0 | NUMBER(1,0) | Indicates if the school is an alternative school for students with academic difficulties. |
| ALTERNATIVESCHOOLDISCIPLINE | 13.6.0 | NUMBER(1,0) | Indicates if the school is an alternative school for students with discipline problems. |
| ALTERNATIVESCHOOLOTHER | 13.6.0 | NUMBER(1,0) | No longer collected. |
| CHARTERSCHOOL | 13.6.0 | NUMBER(1,0) | Indicates if the school is a charter school. |
| DUALCREDIT | 13.6.0 | NUMBER(1,0) | Indicates if the school offers dual credit classes. |
| FORSTUDENTDISABILITIES | 13.6.0 | NUMBER(1,0) | Indicates if the school only serves students with disabilities. |
| HASAPMATHSTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates if the school has students taking Advanced Placement Math classes. |
| HASAPOTHERSTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates if the school has students taking Advanced Placement classes other than Math and Science. |
| HASAPSCIENCESTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates if the school has students taking Advanced Placement Science classes. |
| HASAPSTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates if the school has any Advanced Placement students. |
| HASDUALENROLLMENT | 13.6.0 | NUMBER(1,0) | Indicates if the school has students enrolled in Dual Credit classes. |
| HASGIFTEDTALENTEDSTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates if the school has gifted and talented students. |
| HASIBDIPLOMASTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates if the school has students enrolled in International Baccalaureate classes. |
| HASNONIDEAPRESCHSTUAGE3 | 13.6.0 | NUMBER(1,0) | Indicates if the school has pre-school students that are non-IDEA age 3. |
| HASNONIDEAPRESCHSTUAGE4 | 13.6.0 | NUMBER(1,0) | Indicates if the school has pre-school students that are non-IDEA age 4. |
| HASNONIDEAPRESCHSTUAGE5 | 13.6.0 | NUMBER(1,0) | Indicates if the school has pre-school students that are non-IDEA age 5. |
| HASSINGLESEXCLASSSTUDENTS | 13.6.0 | NUMBER(1,0) | Indicates if the school has any single gender classes for students. |
| LAWENFORCEMENTOFFICERS | 13.6.0 | NUMBER(1,0) | No longer collected. |
| MAGNETSCHOOLORPROGRAM | 13.6.0 | NUMBER(1,0) | Indicates if the school is a magnet school or not. |
| NUMADVMATHCLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of advanced math classes taught by a certified teacher. NC does not collect through Powerschool. |
| NUMALGEBRAICLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of Algebra I classes taught by a certified teacher. NC does not collect through Powerschool. |
| NUMALGEBRAIICLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of Algebra II classes taught by a certified teacher. NC does not collect through Powerschool. |
| NUMBIOLOGYCLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of Biology classes taught by a certified teacher. NC does not collect through Powerschool. |
| NUMCALCULUSCLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of Calculus classes taught by a certified teacher. NC does not collect through Powerschool. |
| NUMCHEMISTRYCLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of Chemistry classes taught by a certified teacher. NC does not collect through Powerschool. |
| NUMCLASSESADVMATH | 13.6.0 | NUMBER(10,0) | The number of advanced math classes taught at the school. |
| NUMCLASSESALGEBRAI | 13.6.0 | NUMBER(10,0) | The number of Algebra I classes taught at the school for grade 7-8. |
| NUMCLASSESALGEBRAII | 13.6.0 | NUMBER(10,0) | The number of Algebra II classes taught at the school. |
| NUMCLASSESAPCS | 18.11.0 | NUMBER(10,0) | The number of AP Computer Science classes taught at the school. If the value of this field is greater than 0, then APIB-13 is set to Yes for the School Detail Part 1 view. |
| NUMCLASSESBIOLOGY | 13.6.0 | NUMBER(10,0) | The number of Biology classes taught at the school. |
| NUMCLASSESCALCULUS | 13.6.0 | NUMBER(10,0) | The number of Calculus classes taught at the school. |
| NUMCLASSESCHEMISTRY | 13.6.0 | NUMBER(10,0) | The number of Chemistry classes taught at the school. |
| NUMCLASSESCS | 18.11.0 | NUMBER(10,0) | The number of Computer Science classes taught at the school |
| NUMCLASSESGEOMETRY | 13.6.0 | NUMBER(10,0) | The number of Geometry classes taught at the school grade 8. |
| NUMCLASSESPHYSICS | 13.6.0 | NUMBER(10,0) | The number of Physics classes taught at the school. |
| NUMCOURSESAP | 13.6.0 | NUMBER(10,0) | The number of Advanced Placement courses taught at the school. |
| NUMCOMPUTERCLASSESCERTTEACH | 18.11.0 | NUMBER(10,0) | The number of Computer Science classes taught by a certified teacher. NC does not collect through PowerSchool |
| NUMCREDITRECOVERYSTUDENTS | 18.11.0 | NUMBER(10,0) | The number of students in a credit recovery program. Moved from Sch Detail 2 in 17-18. If this value is greater than 0 then PENR-5 is displayed as Yes in the School Detail View of part 1. |
| NUMGEOMETRYCLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of Geometry classes taught by a certified teacher. NC does not collect through PowerSchool. |
| NUMHSCLASSESALGEBRAI | 13.6.0 | NUMBER(10,0) | The number of Algebra I classes taught at the school for grade 9-12. |
| NUMHSCLASSESGEOMETRY | 13.6.0 | NUMBER(10,0) | The number of Geometry classes taught at the school grade 9-12. |
| NUMMATHCLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of classes taught at the school. NC does not collect through Powerschool. |
| NUMPHYSICSCLASSESCERTTEACH | 13.6.0 | NUMBER(10,0) | The number of physics classes taught at the school by a certified teacher. NC does not collect through PowerSchool. |
| NUMSUTALGGRADE7 | 18.11.0 | NUMBER(10,0) | Indicates the number of students that passed Algebra I in grade 7. Moved from Sch Detail 2 in 17-18. |
| NUMSTUENROLLEDALGEBRAIGRADE7 | 13.6.0 | NUMBER(10,0) | The number of students enrolled in Algebra I in grade 7. |
| NUMSTUENROLLEDGEOMETRYGRADE8 | 13.6.0 | NUMBER(10,0) | The number of students enrolled in Algebra I in grade 8. |
| PART1SCHOOLCOMMENTS | 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 | NUMBER(1,0) | The school offers grade 12. |
| PROVIDESGRADE13 | 13.6.0 | NUMBER(1,0) | This field is no longer collected after the 15-16 collection. |
| 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. |
| PROVIDESKG | 13.6.0 | NUMBER(1,0) | The school offers grade KG. |
| PROVIDESPREKG | 13.6.0 | NUMBER(1,0) | The school offers grade Pre-KG. |
| PROVIDESUNGRADED | 13.6.0 | NUMBER(1,0) | The school offers 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 school id. |
| SCHOOLNAME | 13.6.0 | VARCHAR2(60) | The name of the school |
| SELFPARTICIPATEAP | 13.6.0 | NUMBER(1,0) | Indicates if a student can self-participate in Advanced Placement classes. |
| SINGLESEXCLASSESINCOED | 13.6.0 | NUMBER(1,0) | No longer used. |
| SINGLESEXFALGGEOM | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for female Algebra and Geometry. |
| SINGLESEXFLANGARTS | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for female Language Arts. |
| SINGLESEXFOTHER | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for female other subjects. |
| SINGLESEXFOTHERMATH | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for female other math classes. |
| SINGLESEXFSCIENCE | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for female science. |
| SINGLESEXMALGGEOM | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for male Algebra and Geometry. |
| SINGLESEXMLANGARTS | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for male Language Arts. |
| SINGLESEXMOTHER | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for male other subjects. |
| SINGLESEXMOTHERMATH | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for male other math classes. |
| SINGLESEXMSCIENCE | 13.6.0 | NUMBER(6,0) | The number of single sex classes offered for male science. |
| STUENROLLEDALGEBRAIGRADE7 | 13.6.0 | NUMBER(1,0) | Indicates if the school has students enrolled in Algebra I in grade 7. |
| STUENROLLEDALGEBRAIGRADE8 | 13.6.0 | NUMBER(1,0) | Indicates if the school has students enrolled in Algebra I in grade 8. |
| STUENROLLEDGEOMETRYGRADE8 | 13.6.0 | NUMBER(1,0) | Indicates if the school has students enrolled in Geometry in grade 8. |
| UNGRADEDCHARACTERISTIC | 13.6.0 | VARCHAR2(100) | Indicates the type of students that are coded as ungraded for this school. A is for mainly elementary students, B is for mainly middle school students, and C is for mainly high school students. |