S_WI_LOG_ISES_X (ver 16.10.1)
This table is an extension of the [Log] table. This table provides ISES Discipline Reporting specific fields for Wisconsin.
Column Name | Version | Data Type | Description |
|---|---|---|---|
Logdcid | 16.10.1 | Number(10,0) | Primary Key. |
| Behavior_Detail_Description | 17.12.0 | Varchar2(300) | A description of the incident when a student is not expelled for a firearms related violation. |
| Bodily_Injury | 16.10.1 | Varchar2(5) | Serious Bodily Injury (Y= Yes, N =No). |
Early_Reinstatement_Condition | 16.10.1 | Varchar2(5) | Early Reinstatement Condition (Y= Yes, N =No). |
| Primary_Incident | 16.10.1 | Varchar2(4) | Incident Type - Primary. |
| Secondary_Incident | 16.10.1 | Varchar2(4) | Incident Type - Secondary. |
| ModifiedTerm | 16.10.1 | Varchar2(5) | Modified Term. |
| Removal_Type | 16.10.1 | Varchar2(4) | Removal Type. |
| Return_Indicator | 16.10.1 | Varchar2(5) | Return to School after Expulsion (Y= Yes, N =No). |
| Services_Indicator | 16.10.1 | Varchar2(5) | Services Provided during Expulsion (Y= Yes, N =No). |
| Days_Removed | 16.10.1 | Number(25,10) | School Days Removed This Term. |
| Expulsion_Return_Date | 16.10.1 | Date | Expulsion Period Return Date. (no longer used 17.10.0) |
| Removal_Date | 16.10.1 | Date | Removal Period Start Date. |