Restraint Extract

Select Schools

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included.
• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Select Students*

Indicate which students to include in the report by selecting one of the following options:

• The selected [number] students only – Run the report for students in the current student selection from the currently selected schools.
• All students – Run the report for all students who meet the selection criteria in the currently selected school(s).

Note: If running the report for a single student, or group of students, select the students prior to running the report.

Report State Date*

Enter the report start date.

Report End Date*

Enter the report end date.

Processing Options

Choose a time to run the report from the pop-up menu:

• In Background Now (Recommended) – Execute the report immediately in the background.
• ASAP – Execute the report in the order it is received in the Report Queue.
• At Night – Execute the report during the next evening.
• On Weekend – Execute the report during the next weekend.
• On Specific Time – Execute the report on the date and time specified.

Specific Date/Time

Enter a date using the format mm/dd/yyyyor mm-dd-yyyyin order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry.

Use the pop-up menus to schedule the report to be run at a specific hour and minute.

Example: 7/29/2008 @ 10:05 AM.

SASID

The State Assigned Student ID

[Students]State_StudentNumber

Alpha-numeric

10

The student's first name

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_First_Name

[Students]First_Name 

The student's middle name

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Middle_Name

[S_MA_STU_Demographic_X]LongMiddlename

[Students]Middle_Name

The student's last name

Note: If populated, the student's legal name overrides the student's preferred name.

[StudentCoreFields]PSCore_Legal_Last_Name

[Students]Last_Name

The student's gender.

Note: If populated, the student's legal gender overrides the student's preferred gender.

[StudentCoreFields]PSCore_Legal_Gender

[S_MA_STU_Demographic_X]NonBinary_Gender_TF

[Students]Gender

The state assigned LEA ID assigned to this district.

Note: Leading zeros are retained.

[Prefs]Value where[Prefs]Name = District_Number

or
First four digits of [CST_SubDistricts]SubDistrict_Number

8

[Prefs]Value where [Prefs]Name = DistrictName

or

[CST_Subdistricts]SubDistrict_Name

[S_MA_STU_X]OverrideSchoolCode

or

[Prefs]value where [Prefs]name=districtnumber + [Schools]Alternate_School_Number

or

[Students]SchoolID

8

1

The date the student was restrained.

Format: mm/dd/yyyy

[S_MA_LOG_Restraint_X]RestraintDate

Date

10

The time that the restraint started.

Format: mm/dd/yyyy hh:mm:ss AM

Derived from:

[S_MA_LOG_Restraint_X]RestraintEndTime

[S_MA_LOG_Restraint_X]RestraintStartTime

The name of the first person listed as involved in administering the restraint.

Note: The person involved information is pulled from the information entered into the People Involved section of Student Setup - Log Entries > Massachusetts State Information (Log Type = Restraint).

The title of the first person listed as involved in administering the restraint.

[S_MA_LOG_RestraintPersonRole_C]PersonTitle where [S_MA_LOG_RestraintPersonRole_C]PersonRole = 3 (Person Involved in Administering Restraint)

Alpha-numeric

Person2_Involved_Name

The name of the second person listed as involved in administering the restraint.

Note: The person involved information is pulled from the information entered into the People Involved section of Student Setup - Log Entries > Massachusetts State Information (Log Type = Restraint).

[S_MA_LOG_RestraintPersonRole_C]PersonLastFirst where [S_MA_LOG_RestraintPersonRole_C]PersonRole = 3 (Person Involved in Administering Restraint)

Alpha-numeric

The title of the second person listed as involved in administering the restraint.

[S_MA_LOG_RestraintPersonRole_C]PersonTitle where [S_MA_LOG_RestraintPersonRole_C]PersonRole = 3 (Person Involved in Administering Restraint)

Alpha-numeric

The name of the third person listed as involved in administering the restraint.

Note: The person involved information is pulled from the information entered into the People Involved section of Student Setup - Log Entries > Massachusetts State Information (Log Type = Restraint).

[S_MA_LOG_RestraintPersonRole_C]PersonLastFirst where [S_MA_LOG_RestraintPersonRole_C]PersonRole = 3 (Person Involved in Administering Restraint)

Alpha-numeric

The title of the third person listed as involved in administering the restraint.

[S_MA_LOG_RestraintPersonRole_C]PersonTitle where [S_MA_LOG_RestraintPersonRole_C]PersonRole = 3 (Person Involved in Administering Restraint)

Alpha-numeric

The name of the observer.

Note: The observer information is pulled from the information entered into the People Involved section of Student Setup - Log Entries > Massachusetts State Information (Log Type = Restraint).

[S_MA_LOG_RestraintPersonRole_C]PersonLastFirst where [S_MA_LOG_RestraintPersonRole_C]PersonRole = 1 (Observer)

Alpha-numeric

60

Observer_Title

The title of the observer.

[S_MA_LOG_RestraintPersonRole_C]PersonTitle where [S_MA_LOG_RestraintPersonRole_C]PersonRole = 1 (Observer)

Alpha-numeric

60

The school year

Format: YYYY-YYYY

4

The subject or period the student was in when the restraint was applied.

[S_MA_LOG_Restraint_X]SubjectPeriod

Alpha-numeric

The location where the restraint took place.

[S_MA_LOG_Restraint_X]RestraintLocation

Alpha-numeric

100

The type of hold used on the student.

[S_MA_LOG_Restraint_X]HoldUsed

Alpha-numeric

Anyone_Injured

An indication of whether or not anyone was injured during the application of the restraint.

[S_MA_LOG_Restraint_X]InjuryInd

Alpha-numeric

1

Injury_Description

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.

[S_MA_LOG_Restraint_X]InjuryDescription

Alpha-numeric

4000

A description of the student’s behavior and reactions during the restraint, how the restraint ended, and how the student’s well-being was monitored.

[S_MA_LOG_Restraint_X]DemeanorDescription

Alpha-numeric

4000

Principal_Notification_Detail

[S_MA_LOG_Restraint_X]ExtendedTimeApproverName

Alpha-numeric

4000

[S_MA_LOG_Restraint_X]ChosenHoldExplanation

Alpha-numeric

4000

A description of the activity that the restrained student, or others involved, were engaged in prior to use of physical restraint.

[S_MA_LOG_Restraint_X]AntecedentActivity

Alpha-numeric

4000

Parents wishing to discuss the restraint, consequences that may be imposed, or any related matter should contact.

Alt_De-escalation_Detail

A description of any alternative or de-escalation techniques used or attempted to try to prevent the escalation of the situation.

[S_MA_LOG_Restraint_X]DeescalationTechnique

Alpha-numeric

4000

A description of the student’s behavior that justified the use of restraint.

[S_MA_LOG_Restraint_X]JustifyingBehavior

Alpha-numeric

4000

A description of disciplinary actions taken against the student as a result of this incident.

Note: Suspensions or expulsions also require a corresponding SSDR Discipline Log entry.

[S_MA_LOG_Restraint_X]DisciplinaryAction

Alpha-numeric

4000

The date and time of notification of parental notification, as well as the name of the parent/or guardian contacted.

Format: mm/dd/yyyy hh:mm:ss AM

Derived from:

[S_MA_LOG_RestraintNotify_C]NotifyDate, [S_MA_LOG_RestraintNotify_C]NotifyTime,

Date Time

20

Parent_Notify_Method

The method of notification of parental notification, as well as the name of the parent/or guardian contacted.

Note: The parental notification information is pulled from the information entered into the Notifications section of Student Setup - Log Entries > Massachusetts State Information (Log Type = Restraint).

Dept_Notify_Date

The date and time of department notification in the event of an injury, as well as the name of the person notified.

Note: The department notification information is pulled from the information entered into the Notifications section of Student Setup - Log Entries > Massachusetts State Information (Log Type = Restraint).

Derived from:

[S_MA_LOG_RestraintNotify_C]NotifyDate, [S_MA_LOG_RestraintNotify_C]NotifyTime,

Alpha-numeric

N/A

Dept_Notify_Method

The method of department notification in the event of an injury, as well as the name of the person notified.

Note: The department notification information is pulled from the information entered into the Notifications section of Student Setup - Log Entries > Massachusetts State Information (Log Type = Restraint).

Derived from:

[S_MA_LOG_RestraintNotify_C]NotifyMethodType where [S_MA_LOG_RestraintNotify_C]ContactType - (1) Department

Alpha-numeric

50