S_NC_RPT_CRDC_CLS_DETAIL_1 (ver 13.6.0)
This table is a stand alone table that stores information about the classes detail for the Civil Rights Data Collection Part 1.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| APCOURSE | 13.6.0 | NUMBER(1,0) | Indicates the course counts as an Advanced Placement course. |
| APSECTION | 13.6.0 | NUMBER(1,0) | Indicates the section counts as an Advanced Placement section. |
| CERTTEACH | 13.6.0 | NUMBER(1,0) | Indicates the section is taught by a certified teacher. |
| COURSE_NAME | 13.6.0 | VARCHAR2(40) | The name of the course. |
| COURSE_NUMBER | 13.6.0 | VARCHAR2(20) | The number of the course. |
| CRSADVMATH | 13.6.0 | NUMBER(1,0) | Indicates the class counts as an advanced math course. |
| CRSALGEBRAI | 13.6.0 | NUMBER(1,0) | Indicates the class counts as a middle school Algebra I class. |
| CRSALGEBRAII | 13.6.0 | NUMBER(1,0) | Indicates the class counts as an Algebra II class. |
| CRSAPCOMPUTERSCIENCE | 18.11.0 | NUMBER(1,0) | Indicates the class counts as an AP Computer Science class |
| CRSBIOLOGY | 13.6.0 | NUMBER(1,0) | Indicates the class counts as a Biology class. |
| CRSCALCULUS | 13.6.0 | NUMBER(1,0) | Indicates the class counts as a Calculus class. |
| CRSCHEMISTRY | 13.6.0 | NUMBER(1,0) | Indicates the class counts as a Chemistry class. |
| CRSCOMPUTERSCIENCE | 18.11.0 | NUMBER(1,0) | Indicates the class counts as a Computer Science class. |
| CRSGEOMETRY | 13.6.0 | NUMBER(1,0) | Indicates the class counts as a Geometry class. |
| CRSPHYSICS | 13.6.0 | NUMBER(1,0) | Indicates the class counts as a Physics class. |
| CRSSUBJECTCAT | 13.6.0 | VARCHAR2(10) | Indicates the subject category that the class counts if it is an Advanced Placement Class. |
| 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) | Indicates the school id where the class was taught. |
| SECADVMATH | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 advanced math class. |
| SECALGEBRAI | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 Algebra I class. |
| SECALGEBRAII | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 Algebra II class. |
| SECAPCOMPUTERSCIENCE | 18.11.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 AP computer science class |
| SECBIOLOGY | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 Biology class. |
| SECCALCULUS | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 calculus class. |
| SECCHEMISTRY | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 chemistry class. |
| SECCOMPUTERSCIENCE | 18.11.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 computer science class |
| SECGEOMETRY | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 geometry class. |
| SECPHYSICS | 13.6.0 | NUMBER(1,0) | Indicates the section counts as a grade 9 - 12 physics class. |
| SECSUBJECTCAT | 13.6.0 | VARCHAR2(10) | Indicates the subject category that the class counts if it is an grade 9-12 course. |
| SECTIONID | 13.6.0 | NUMBER(10,0) | The internal section id of the class. |
| SECTION_NUMBER | 13.6.0 | VARCHAR2(20) | The section number of the class. |
| SINGLESEX | 13.6.0 | VARCHAR2(10) | Indicates if the class is taught as a single gender class at a mixed-gender campus. |