S_NC_RPT_CRDC_STU_DETAIL_2 (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 2.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| ABSENT15ORMOREDAYS | 13.6.0 | NUMBER(1,0) | The number of students absent 15 or more days. |
| AGE | 13.6.0 | NUMBER(6,0) | The age of the student. |
| APEXAMQUALIFIEDSCORE | 13.6.0 | NUMBER(1,0) | Indicates this student passed an Advanced Placement exam. |
| ATTEMPTEDACT | 13.6.0 | NUMBER(1,0) | Indicates this student attempted took the ACT exam. |
| ATTEMPTEDAPEXAM | 13.6.0 | NUMBER(1,0) | Indicates this student attempted an Advanced Placement exam. |
| ATTEMPTEDSAT | 13.6.0 | NUMBER(1,0) | Indicates this student took Advance Placement classes. |
| COPORALPUNISHMENT | 13.6.0 | NUMBER(1,0) | Indicates this student received corporal punishment in grade kindergarten or above. |
| CORPORALPUNISHMENTPK | 13.6.0 | NUMBER(10,0) | Indicates this student received corporal punishment in prekindergarten. |
| CORPORALPUNISHMENTPKDIS | 13.6.0 | NUMBER(10,0) | Indicates this student received corporal punishment in prekindergarten and has a disability. |
| CORPORALPUNISHWITHDIS | 13.6.0 | NUMBER(10,0) | Indicates this student received corporal punishment in grade kindergarten and above and has a disability. |
| CORPORALPUNISHWITHOUTDIS | 13.6.0 | NUMBER(10,0) | Indicates this student received corporal punishment in grade kindergarten and above and does not have a disability. |
| CREDIT_RECOVERY | 13.6.0 | NUMBER(10,0) | Indicates this student took a credit recovery class.Moved to Stu Detail 1 in 17-18. |
| DURATION | 13.6.0 | NUMBER(10,2) | |
| ENROLLEDAPCOURSE | 13.6.0 | NUMBER(1,0) | Indicates this student enrolled in an Advanced Placement Course. |
| ENROLLEDDISTLEARNPROG | 13.6.0 | NUMBER(1,0) | Indicates this student enrolled in a Distance Learning Program Moved to Stu Detail 1 in 17-18. |
| ENROLLEDGEDPREPPROG | 13.6.0 | NUMBER(1,0) | Indicates this student enrolled in a High School Equivalency degree program..Moved to Stu Detail 1 in 17-18. |
| ETHNICITY | 13.6.0 | VARCHAR2(10) | The student's ethnicity code. |
| EXPULSIONS | 13.6.0 | NUMBER(1,0) | Indicates this student had an expulsion. |
| EXPULSIONSEDUSERVICE | 13.6.0 | NUMBER(1,0) | Indicates this student was expelled and received education services. |
| EXPULSIONSNOEDUSERVICE | 13.6.0 | NUMBER(1,0) | Indicates this student was expelled and received no education services. |
| EXPULSIONSPK | 20.7.1 | NUMBER(1,0) | Number of instances of preschool suspensions. |
| EXPULSIONSZEROTOLERANCE | 13.6.0 | NUMBER(1,0) | Indicates this student was expelled under a zero tolerance policy. |
| GENDER | 13.6.0 | VARCHAR2(10) | The gender of the student. |
| GRADELEVEL | 13.6.0 | NUMBER(6,0) | The grade level of the student. |
| HARASSDISCDISABILITY | 13.6.0 | NUMBER(1,0) | Indicates this student with disabilities was harassed due to disability. |
| HARASSDISCRACE | 13.6.0 | NUMBER(1,0) | Indicates this student with disabilities was harassed due to race. |
| HARASSDISCSEX | 13.6.0 | NUMBER(1,0) | Indicates this student with disabilities was harassed due to gender. |
| HARASSEDDISABILITY | 13.6.0 | NUMBER(1,0) | Indicates this student without disabilities was harassed due to disability. |
| HARASSEDRACE | 13.6.0 | NUMBER(1,0) | Indicates this student without disabilities was harassed due to race. |
| HARASSEDSEX | 13.6.0 | NUMBER(1,0) | Indicates this student without disabilities was harassed due to gender. |
| HSECREDFROMGEDPROG | 13.6.0 | NUMBER(1,0) | Indicates this student received high school credit from a high school equivalency program. |
| IDEA | 13.6.0 | NUMBER(1,0) | Indicates the student is IDEA. |
| LEPPROGRAM | 13.6.0 | NUMBER(1,0) | Indicates the student is Limited English Proficiency and receives services. |
| LEPQUALIFIED | 13.6.0 | NUMBER(1,0) | Indicates the student is Limited English Proficiency. |
| MISSEDSUS | 13.6.0 | NUMBER(10,0) | The number of days this student missed due to suspension. |
| MISSEDSUSDURATION | 20.7.1 | NUMBER(10,2) | |
| NUMALLEGHARASSSEXUALORI | 13.6.0 | NUMBER(10,0) | Indicates this student was harassed based on sexual orientation. |
| NUMALLEGHARASSSEXUALRELIGION | 13.6.0 | NUMBER(10,0) | Indicates this student was harassed based on religion. |
| NUMINSCHSUSPENSIONS | 13.6.0 | NUMBER(6,0) | Indicates this student was harassed based on sexual orientation. |
| NUMOFFATTEMPRAPE | 13.6.0 | NUMBER(10,0) | The number of instances of attempted rape. |
| NUMOFFHOMICIDE | 13.6.0 | NUMBER(10,0) | The number of instances of homicide. |
| NUMOFFINVSHOOTING | 13.6.0 | NUMBER(10,0) | The number of instances involving a shooting. |
| NUMOFFPHYATTWITHFIREARM | 13.6.0 | NUMBER(10,0) | The number of instances of physical attack with a firearm. |
| NUMOFFPHYATTWITHOUTWEAPON | 13.6.0 | NUMBER(10,0) | The number of instances of physical attack without a weapon. |
| NUMOFFPHYATTWITHWEAPON | 13.6.0 | NUMBER(10,0) | The number of instances of physical attack with a weapon. |
| NUMOFFPOSSFIREARM | 13.6.0 | NUMBER(10,0) | The number of instances of possession of a firearm. |
| NUMOFFROBFIREARM | 13.6.0 | NUMBER(10,0) | The number of instances of robbery with a firearm. |
| NUMOFFROBWEAPON | 13.6.0 | NUMBER(10,0) | The number of instances of robbery with a weapon. |
| NUMOFFROBWITHOUTWEAPON | 13.6.0 | NUMBER(10,0) | The number of instances of robbery without a weapon. |
| NUMOFFSEXASSAULT | 13.6.0 | NUMBER(10,0) | The number of instances of sexual assault. |
| NUMOFFTHREATATTWITHFIREARM | 13.6.0 | NUMBER(10,0) | The number of instances of threat to attack with a firearm. |
| NUMOFFTHREATATTWITHOUTWEAPON | 13.6.0 | NUMBER(10,0) | The number of instances of threat to attack without a weapon. |
| NUMOFFTHREATATTWITHWEAPON | 13.6.0 | NUMBER(10,0) | The number of instances of threat to attack with a weapon. |
| NUMOUTOFSCHSUSPENSIONS | 13.6.0 | NUMBER(6,0) | The number of instances of out of school suspensions for the student. |
| PASSEDALGEBRAI | 13.6.0 | NUMBER(1,0) | Indicates the student passed Algebra I.Moved to Stu Detail 1 in 17-18. |
| REFERREDLAWENFORCEMENT | 13.6.0 | NUMBER(1,0) | Indicates this student was involved in an instance referred to law enforcemnt. |
| RESTRAINTMECHANICAL | 13.6.0 | NUMBER(1,0) | Indicates this student was mechanically restrained |
| RESTRAINTPHYSICAL | 13.6.0 | NUMBER(1,0) | Indicates this student was physically restrained |
| RETAINEDINGRADE1 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 1. |
| RETAINEDINGRADE10 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 10. |
| RETAINEDINGRADE11 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 11. |
| RETAINEDINGRADE12 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 12. |
| RETAINEDINGRADE13 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 13. |
| RETAINEDINGRADE2 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 2. |
| RETAINEDINGRADE3 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 3. |
| RETAINEDINGRADE4 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 4. |
| RETAINEDINGRADE5 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 5. |
| RETAINEDINGRADE6 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 6. |
| RETAINEDINGRADE7 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 7. |
| RETAINEDINGRADE8 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 8. |
| RETAINEDINGRADE9 | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade 9. |
| RETAINEDINGRADEKG | 13.6.0 | NUMBER(1,0) | Indicates the student was retained in grade KG. |
| 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. |
| SCHOOLRELATEDARREST | 13.6.0 | NUMBER(1,0) | Indicates the student had a school related arrest. |
| SECLUSION | 13.6.0 | NUMBER(1,0) | Indicates this student was restrained by seclusion. |
| 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. |
| SUSPENSIONPK | 13.6.0 | NUMBER(10,0) | Indicates the number of PK suspensions. |
| SUSPENSIONPKDIS | 13.6.0 | NUMBER(10,0) | Indicates the number of PK suspensions for students with disabilities. |
| SUSPENSIONWITHDIS504 | 13.6.0 | NUMBER(10,0) | Indicates the number of suspensions for students with a 504 disability. |
| SUSPENSIONWITHDISIDEA | 13.6.0 | NUMBER(10,0) | Indicates the number of suspensions for students with disabilities. |
| SUSPENSIONWITHOUTDIS | 13.6.0 | NUMBER(10,0) | Indicates the number of suspensions for students without disabilities. |
| TRANSPORT | 13.6.0 | NUMBER(10,0) |