S_WI_LOG_CRDC_X (ver 16.2.2)
This table is an extension of the [Log] table. This table provides CRDC-specific fields for Wisconsin.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Logdcid | 16.2.2 | Number(10,0) | Primary Key. |
| Harass_Orientation_TF | 16.2.2 | Number(1,0) | Harassment or Bullying on the basis of Sexual Orientation. |
Harass_Religion_TF | 16.2.2 | Number(1,0) | Harassment or Bullying on the basis of Religion. |
| Offense_Category | 16.2.2 | Varchar2(4) | Offense Category. |
| Transfer_Alternative_School_YN | 16.3.2 | Varchar2(1) | Student was transferred to an Alternative School or Regular School for disciplinary reasons. |
| Harass_Disability_TF | 16.10.1 | Number(1,0) | Harassment or Bullying on the basis of Disabiltiy. |
| Harass_Race_TF | 16.10.1 | Number(1,0) | Harassment or Bullying on the basis of Race. |
| Harass_Sex_TF | 16.10.1 | Number(1,0) | Harassment or Bullying on the basis of Gender. |
| Expelled_zerotolerance_TF | 16.10.1 | Number(1,0) | Student was Expelled under zero-tolerance policies. |
| Law_Enf_Referral_TF | 16.10.1 | Number(1,0) | Student was Referred to Law Enforcement. |
| Mechanical_Restraint_TF | 16.10.1 | Number(1,0) | Student was Subjected to Mechanical Restraint. |
| Physical_Restraint_TF | 16.10.1 | Number(1,0) | Student was Subjected to Physical Restraint. |
| Resulting_Arrest_TF | 16.10.1 | Number(1,0) | Student was Arrested as a result of this incident. |
| Seclusion_TF | 16.10.1 | Number(1,0) | Student was Subjected to Seclusion. |
| Harass_Role | 16.10.1 | Varchar2(5) | Role of student in the incident (v = Victim, o = Offender). |
| Harass_ReligiousAffiliation | 21.6.2.0 | Varchar2(2) | Harassment or Bullying on the basis of Religious Affiliation. |