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. |