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