S_NH_LOG_X (ver 17.5.0)
This table is an extension of the [Log] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Logdcid | 14.7.0 | Number(10,0) | Primary Key. |
CRDC_Corporal_Punishment_TF | 14.7.0 | Number(1,0) | Student received Corporal Punishment. |
CRDC_Exp_ZeroTolerance_TF | 14.7.0 | Number(1,0) | Student received an Expulsion under Zero Tolerance Policies. |
| CRDC_Harass_Role | 16.1.0 | Varchar2(1) | Role of Student (v=Victim or o=Offender) |
| CRDC_Harass_Sex_TF | 16.1.0 | Number(1,0) | Harassment or Bullying on the basis of Gender |
| CRDC_Harass_Race_TF | 16.1.0 | Number(1,0) | Harassment or Bullying on the basis of Race |
| CRDC_Harass_Disability_TF | 16.1.0 | Number(1,0) | Harassment or Bullying on the basis of Disability |
| CRDC_Harass_Religion_TF | 16.1.0 | Number(1,0) | Harassment or Bullying on the basis of Religion |
| CRDC_Harass_Orientation_TF | 16.1.0 | Number(1,0) | Harassment or Bullying on the basis of Sexual Orientation |
| CRDC_Offense_Category | 16.1.0 | Varchar2(4) | Offense Category |
| SS_Restraint_Injury_TF | 16.5.1 | Number(1,0) | Student restraint that resulted in bodily injury |
| SS_Investigation_Status | 16.7.1 | Varchar2(5) | Investigation Status (A=Active/On-going investigation or C=Closed) |
| CRDC_Law_Enf_Referral_TF | 16.11.1 | Number(1,0) | Student was Referred to Law Enforcement |
| CRDC_Mechanical_Restraint_TF | 16.11.1 | Number(1,0) | Student was subjected to mechanical restraint |
| CRDC_Physical_Restraint_TF | 16.11.1 | Number(1,0) | Student was subjected to physical restraint |
| CRDC_Resulting_Arrest_TF | 16.11.1 | Number(1,0) | Student was Arrested as a result of this incident |
| CRDC_Seclusion_TF | 16.11.1 | Number(1,0) | Student was subjected to seclusion |
| Safe_Schools | 16.11.1 | Number(1,0) | Obsolete - SR 21.8.2.0 Include incident in the Safe Schools Submission |
| SS_Bombthreat | 16.11.1 | Number(1,0) | Bomb Threat |
| SS_Harass_Disability_TF | 16.11.1 | Number(1,0) | Harassment and Bullying - Disability |
| SS_Harass_Gender_TF | 16.11.1 | Number(1,0) | Harassment and Bullying - Gender |
| SS_Harass_Other_TF | 16.11.1 | Number(1,0) | Harassment and Bullying - Any other basis |
| SS_Harass_Physical_TF | 16.11.1 | Number(1,0) | Harassment and Bullying - Physical Characteristics |
| SS_Harass_Race_TF | 16.11.1 | Number(1,0) | Harassment and Bullying - Race, color or national origin |
| SS_Harass_Sex_TF | 16.11.1 | Number(1,0) | Harassment and Bullying - Gender |
| SS_PDS_arson_TF | 16.11.1 | Number(1,0) | Persistently Dangerous Schools - Arson |
| SS_PDS_assault_TF | 16.11.1 | Number(1,0) | Persistently Dangerous Schools - First or second degree assault |
| SS_PDS_firearms_TF | 16.11.1 | Number(1,0) | Persistently Dangerous Schools - Firearms possession or sale |
| SS_PDS_homicide_TF | 16.11.1 | Number(1,0) | Persistently Dangerous Schools - Homicide |
| SS_PDS_robbery_TF | 16.11.1 | Number(1,0) | Persistently Dangerous Schools - Robbery (armed, violent or threatening) |
| SS_PDS_sexualassault_TF | 16.11.1 | Number(1,0) | Persistently Dangerous Schools - Aggravated felonious sexual assault |
| SS_TIX_Admissions_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Admissions |
| SS_TIX_Athletics_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Athletics |
| SS_TIX_Counseling_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Counseling |
| SS_TIX_Course_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Course offerings and access |
| SS_TIX_Education_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Educational programs and activities |
| SS_TIX_Employment_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Employment assistance |
| SS_TIX_Facilities_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Facilities |
| SS_TIX_Financialaid_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Financial aid |
| SS_TIX_Health_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Health and insurance benefits and services |
| SS_TIX_Marital_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Marital and parental status discrimination |
| SS_TIX_Recruitment_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Recruitment |
| SS_TIX_Scholarships_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Scholarships |
| SS_TIX_Sexualharassment_TF | 16.11.1 | Number(1,0) | Title IX Complaint Category - Sexual harassment |
| SS_Bullying_Cat | 16.11.1 | Varchar2(5 | Bullying Category |
| SS_Category | 16.11.1 | Varchar2(5) | School Safety Category |
| SS_Discipline_Cat | 16.11.1 | Varchar2(5) | Student Discipline |
| SS_firearm_Action | 16.11.1 | Varchar2(5) | Discipline of Students disciplined for possessing a firearm |
| SS_Rpt_Status | 16.11.1 | Varchar2(5) | Reporting Status |
| SS_Relationship | 16.11.1 | Varchar2(5) | Harassment Relationship |
| SS_Restraint_Injury_Death_TF | 17.5.0 | Number(1,0) | Identifies if a restraint resulted in “serious injury or death”. |
| SS_Weapon | 16.11.1 | Varchar2(5) | Gun Free Schools Act of 1994 |
| handicapping_conditions | 16.11.1 | Varchar2(5) | Student Identified as Disabled |
| SS_incidentID | 16.11.1 | Number(11,0) | Incident ID |
| SS_Restraint_OtherLoc_TF | 19.10.1.0 | Boolean | Student restraint at different location |
| SS_Seclusion_OtherLoc_TF | 19.10.1.0 | Boolean | Student seclusion at different location |
| CRDC_Harass_RelAffiliation | 21.6.2 | Varchar2(2) | Perceived Religious Affiliation |