Behavior Data Collection Extract | PowerSchool SIS Compliance

Introduction

This extract generates the students' behavior data categorized based on the MT-specific Event and Resolution code set-up in the Incident Management.

The Behavior Data Collection Extract automatically truncates incident titles to a maximum of 50 characters.

Selection Criteria

The student is enrolled in the date range for which the report is run.
The Incident for the student is extracted only from the school for which the report is run.
When run at the district level, incidents for selected students are pulled from all the schools that are chosen.
Only the Primary behavior associated with the offender is extracted in the report output.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Schools to Include	Select the schools you want to include in this report.
Students to Include	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 selection. All students – Run the report for all students in the current school or district who meet the selection criteria. Note: If running the report for a single student, or group of students, select the students before running the report.
Start Date	Enter the start date for the report.
End Date	Enter the end date for the report.

Report Output

In an incident, If there is more than one offender, then only the offender with behavior marked with the primary flag and linked actions will be extracted.
If there is more than one offender with the same or different behaviors, No primary flag marked then the report output will be blank.
If there is one offender with more than one behavior, then behavior with a primary flag and linked actions will be displayed. If No primary flag is set to any of the linked behaviors, then the report output will be blank.
In an incident, if there is Only One offender, Only One behavior, linked actions, and whether the primary flag is marked or NOT, then the report output will have data on one offender.

Field	Description	Table[FieldName]
District Number	The district number.	[Prefs] Value
School Number	The school ID.	[Schools] School_Number
Calendar Number	The calendar number.	Always extracts as 1
Calendar End Year	The calendar end year.	[TERMS] YEARID
Incident ID	The incident ID.	[INCIDENT] INCIDENT_ID
Status	Indicates the status	Always extracts as Complete
Submitted Date	The submitted date	[INCIDENT] CREATED_TS
Title	The incident title.	[INCIDENT] INCIDENT_TITLE
Date Of Incident	The date of incident.	[INCIDENT] INCIDENT_TS
Time Of Incident	The time of incident.	[INCIDENT] INCIDENT_TS
Damages	Indicates the financial damages.	[INCIDENT] FINANCIAL_IMPACT
Location	Indicates the location where the incident occurred.	[PSRW_INCIDENTLOCATION] STATE_AGGREGATE_RPT_CODE
Incident Details	The incident details.	[INCIDENT] INCIDENT_DETAIL_DESC
Behavior Event
Event Type	The event type.	[PSRW_PARTICIPANTBEHAVIOR] STATE_DETAIL_REPORT_CODE
Referred To Local Law Enforcement	Indicates if the incident was reported to the local law enforcement.	[PSRW_INCIDENTACTIONATTRIBUTE] INCIDENT_CATEGORY
Event Required Behavior Response	Indicates the behavior response.	Always extracts as N
Participant
Student State ID	The student state ID	[STUDENTS] STATE_STUDENTNUMBER
Role	Indicates the participant role.	[PSRW_INCIDENTPARTICIPANT] ROLE_CODE
Relationship To School	Indicates the relationship to school.	Always extracts as 1
Injury	Indicates the type of injury caused during the incident.	Always extracts as 2
Medical Services Provided	Indicates the medical services provided.	Always extracts as N
Participation Details	Indicates the participation details.	Always extracts as Offender