S_IA_LOG_X (ver 15.7.3)
This table is an extension of the Log table.
Column Name | Version | Data Type | Description |
---|---|---|---|
LogDCID | 15.7.3 | Integer | Primary key |
Action_Taken | 15.7.3 | Integer | The action taken due to the behavior incident. |
Behavior_Incident_Number | 17.2.0 | Varchar2 (10) | The behavior incident number. Migrated from [Log]IA_Beh_Inc_Num. |
Date_Of_Removal | 15.8.0 | Date | The date the student was removed. |
Duration_Assigned | 15.7.3 | Double | The duration assigned for removal. |
IA_DiscInc_Reporter | 23.10.2 | Integer | Indicates the StudentDCID or UserDCID of the Discipline Reporter. |
IA_DiscInc_Reporter_Type | 23.10.2 | Varchar2(1) | Indicates if teh Discipline Reporter is a Staff member, Student or Other. |
Incident_Assault | 21.8.1 | Number(1,0) | Indicates whether the incident involved assault. |
Incident_Body_Injury | 21.8.1 | Number(1,0) | Indicates whether the incident involved bodily injury. |
Incident_Prop_Damage | 21.8.1 | Number(1,0) | Indicates whether the incident involved property damage. |
Incident_Location | 15.7.3 | Integer | Location of where the incident took place. |
Incident_Time | 22.11.3 | Varchar2(50) | Time when incident took place. |
Instructional_Format | 16.8.2 | Varchar2(2) | Indicates the instructional format at the time of the behavior. |
Major_Or_Minor | 15.7.3 | Integer | Indicates whether the referral was for a major or minor incident. |
Motivation | 15.7.3 | Integer | The perception of why the student displayed problem behavior |
Problem_Behavior | 15.7.3 | Integer | The problem behavior that caused the action. |
Received_Ed_Serv_During_Exp | 17.2.0 | Varchar2(1) | An indication of whether Educational Services were received during an expulsion. Migrated from [Log]IA_ReceivedEdServDuringExp. |
Removal_Reason | 17.2.0 | Varchar2(1) | The reason for the student's removal. Migrated from [Log]IA_ReasonForRemoval. |
Removal_Type | 17.2.0 | Varchar2(1) | The type of removal. Migrated from [Log]IA_RemovalType. |
Restrained_Or_Seclusion | 15.7.3 | Integer | Indicates whether the student was restrained/secluded after the behavior? |
Serious_Bodily_Injury | 17.2.0 | Varchar2(1) | An indication of whether the incident involved serious bodily injury. Migrated from [Log]IA_SeriousBodilyInjury. |
Unsafe_School_Choice_Offense | 17.2.0 | Number(1,0) | Indicates whether the offense leading to the removal is an Unsafe School Choice Option offense. Migrated from [Log]IA_UnsafesclchOffense. |
Zero_Tol_Expulsion | 15.7.3 | Integer | Indicates whether the expulsion is due to a zero tolerance policy. |