S_MA_LOG_Restraint_X (ver 16.5.1)
This table is an extension of the Log table, which maintains offense, discipline, and restraint data for students.
Column Name | Version | Data Type | Description |
|---|---|---|---|
LogDCID | 16.5.1 | Number(10,0) | Primary key that relates the extended table to the [Log] table. |
| State_ExcludeFromReporting | 16.5.1 | Number(1,0) | Indicates whether or not this log entry should be excluded from state reporting. |
OODInd | 16.5.1 | Number(1,0) | Indicates if the restraint took place in a setting outside of the district. |
| OODAgencyName | 16.5.1 | Varchar2(100) | The agency or collaborative name where the out of district restraint took place, if applicable. |
OODProgramName | 16.5.1 | Varchar2(100) | The name of the out of district program the student was participating in when the restraint occurred. |
| RestraintDate | 16.5.1 | Date | The data the student was restrained. |
| RestraintStartTime | 16.5.1 | Varchar2(8) | The time the restraint started. |
| RestraintEndTime | 16.5.1 | Varchar2(8) | The time the restraint ended. |
| RestraintDurationExplanation | 16.5.1 | Varchar2(500) | An explanation of why a restraint was applied for more than 20 minutes if the difference between the restraint start time and restraint end time is more than 20 minutes. |
| ExtendedTimeApproverName | 16.5.1 | Varchar2(100) | The name of the authorized person who approved the use of restraint against a student for longer than 20 minutes. |
| ExtendedTimeApproverTitle | 16.5.1 | Varchar2(50) | The title of the person who approved the use of restraint against a student for longer than 20 minutes. |
| VerbalReporterName | 16.5.1 | Varchar2(100) | The name of the person who verbally reported the use of restraint to a school administrator. |
| VerbalReporterTitle | 16.5.1 | Varchar2(50) | The title of the person who verbally reported the use of restraint to a school administrator. |
| IEPInd | 16.5.1 | Number(1,0) | Indicates whether or not the student was on an Individualized Education Plan at the time the restraint was applied. |
| PersonCompletingFormName | 16.5.1 | Varchar2(100) | The name of the person who either filled out the original restraint report form, or the person who completed the log entry in PowerSchool. |
| PersonCompletingFormTitle | 16.5.1 | Varchar2(50) | The title of the person who either filled out the original restraint report form, or the person who completed the log entry in PowerSchool. |
| SubjectPeriod | 16.5.1 | Varchar2(4) | Code representing the subject or period the student was in when the restraint was applied. Codes correspond to the following values: Academic, Homeroom, Study Hall, Enrichment, Lunch, Recess, Other. |
| RestraintLocation | 16.5.1 | Varchar2(4) | Code representing the location where the student restraint took place. Codes correspond to the following values: Classroom, Cafeteria, Bathroom, Hallway, Gymnasium, Outside, Other. |
| HoldUsed | 16.5.1 | Varchar2(4) | Code representing the type of hold used on the student. Codes correspond to the following values: Standing, Floor Supine, Floor Prone, Seated, Other |
DemeanorDescription | 16.5.1 | Varchar2(500) | A description of the student's demeanor and well being and how the student was monitored after the restraint. |
ChosenHoldExplanation | 16.5.1 | Varchar2(500) | An explanation of why a particular hold was used to restrain the student. |
AntecedentActivity | 16.5.1 | Varchar2(500) | An explanation of the activity the restrained student or others involved were engaged in prior to the use of physical restraint. |
DisciplinaryAction | 16.5.1 | Varchar2(200) | An explanation of any disciplinary action taken against the student as a result of this incident. Note: Suspensions or expulsions also require a corresponding SSDR Discipline Log entry. |
DeescalationTechnique | 16.5.1 | Varchar2(500) | Description of any alternative or de-escalation techniques used or attempted to try to try to prevent escalation of the situation. |
| JustifyingBehavior | 16.5.1 | Varchar2(500) | An explanation of the student behavior that justified the use of restraint. |
| ContactPerson | 16.5.1 | Varchar2(100) | The name of the person the parents of the student should contact if they want to discuss any aspect of the restraint. |
| InjuryInd | 16.5.1 | Number(1,0) | Indicates whether or not anyone was injured during the application of the restraint. |
| PersonsInjuredType | 16.5.1 | Varchar2(25) | Indicates whether the person(s) injured was a student or a staff member or both if multiple people were injured. |
| InjuryDescription | 16.5.1 | Varchar2(500) | A description of the nature and extent of any injuries sustained, the medical care provided and any follow-up medical attention which may be needed. |
| RestraintSite | 16.5.1 | Varchar2(100) | A description of the location where the restraint took place. |
| InjOtherInfoOrRestraint | 16.8.0 | Varchar2(500) | A description of Additional restraints/Other Information. |
| AdminInformedName | 16.8.0 | Varchar2(100) | Name of Administrator who was informed following the restraint. |
| AdminInformedTitle | 16.8.0 | Varchar2(50) | Title of Administrator who was informed following the restraint. |
| AdminInformedVerbalNotifyDate | 16.8.0 | Date | Date of verbal notification to Administrator who was informed following the restraint. |
| AdminInformedWrittenNotifyDate | 16.8.0 | Date | Date of written notification to Administrator who was informed following the restraint. |