S_NC_RPT_CRDC_STU_DETAIL_1 (ver 20.7.1)
This table is a stand alone table that stores information about the Student detail for the Civil Rights Data Collection Part 1.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AGE | 13.6.0 | NUMBER(6,0) | The student's age on snapshot. |
| CREDIT_RECOVERY | 18.11.0 | NUMBER(10,0) | Indicates this student took a credit recovery class.Moved from Stu Detail 2 in 17-18. |
| CROSSENROLLEDSCHOOL | 20.7.1 | NUMBER(10,0) | Cross enrolled school name. |
| DUALENROLL | 13.6.0 | NUMBER(10,0) | Indicates the student took dual enrollment classes. |
| ENROLLEDADVMATH | 13.6.0 | NUMBER(1,0) | Indicates the student took advanced math classes. |
| ENROLLEDALGEBRAI | 13.6.0 | NUMBER(1,0) | Indicates the student took Algebra I classes. |
| ENROLLEDALGEBRAII | 13.6.0 | NUMBER(1,0) | Indicates the student took Algebra II classes. |
| ENROLLEDAP | 13.6.0 | NUMBER(1,0) | Indicates the student took Advance Placement classes. |
| ENROLLEDAPCS | 18.11.0 | NUMBER(1,0) | Indicates the student took Advanced Placement Computer Science classes. |
| ENROLLEDAPMATH | 13.6.0 | NUMBER(1,0) | Indicates the student took Advanced Placement Math classes. |
| ENROLLEDAPOTHER | 13.6.0 | NUMBER(1,0) | Indicates the student took Advanced Placement Other classes. |
| ENROLLEDAPSCIENCE | 13.6.0 | NUMBER(1,0) | Indicates the student took Advanced Placement Science classes. |
| ENROLLEDBIOLOGY | 13.6.0 | NUMBER(1,0) | Indicates the student took Biology classes. |
| ENROLLEDCALCULUS | 13.6.0 | NUMBER(1,0) | Indicates the student took Calculus classes. |
| ENROLLEDCHEMISTRY | 13.6.0 | NUMBER(1,0) | Indicates the student took Chemistry classes. |
| ENROLLEDCOMPUTERSCIENCE | 18.11.0 | NUMBER(1,0) | Indicates the student took Computer Science classes. |
| ENROLLEDDISTLEARNPROG | 18.11.0 | NUMBER(1,0) | Indicates this student enrolled in a Distance Learning Program Moved from Stu Detail 2 in 17-18. |
| ENROLLEDGEDPREPPROG | 18.11.0 | NUMBER(1,0) | Indicates this student enrolled in a High School Equivalency degree program..Moved from Stu Detail 2 in 17-18. |
| ENROLLEDGEOMETRY | 13.6.0 | NUMBER(1,0) | Indicates the student took Geometry classes. |
| ENROLLEDIBDIPLOMAPROGRAM | 13.6.0 | NUMBER(1,0) | Indicates the student is in the International Baccalaureate program. |
| ENROLLEDPHYSICS | 13.6.0 | NUMBER(1,0) | Indicates the student took Physic classes. |
| ENROLLEDSINGLESEX | 13.6.0 | NUMBER(1,0) | Indicates the student took single gender classes. |
| ETHNICITY | 13.6.0 | VARCHAR2(10) | The student's ethnicity code. |
| GENDER | 13.6.0 | VARCHAR2(10) | Has student's gender. |
| GIFTEDTALENTED | 13.6.0 | NUMBER(1,0) | Indicates the student is gifted and talented. |
| GRADELEVEL | 13.6.0 | NUMBER(6,0) | The student's grade level. |
| IDEA | 13.6.0 | NUMBER(1,0) | Indicates the student is IDEA. |
| ISCROSSENROLLED | 20.7.1 | NUMBER(1,0) | It indicates that student is enrolled in multiple school. |
| LEPPROGRAM | 13.6.0 | NUMBER(1,0) | Indicates the student is being served in the Limited English Proficiency program. |
| LEPQUALIFIED | 13.6.0 | NUMBER(1,0) | Indicates the student is identified as Limited English Proficiency. |
| NUMINTSCHSINGSEXSPORT | 20.7.1 | NUMBER(10,0) | Number of single-gender interscholastic sports. |
| PASSEDALGEBRAI | 18.11.0 | NUMBER(1,0) | Indicates the student passed Algebra I.Moved from Stu Detail 2 in 17-18. |
| 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 id number of the school. |
| SECTION504 | 13.6.0 | NUMBER(1,0) | Indicates the student is 504. |
| STUDENTDCID | 13.6.0 | NUMBER(10,0) | Foreign key to link to the students table. |
| STUDENTID | 13.6.0 | NUMBER(10,0) | The internal id of the student. |