Behavior Data Collection Extract
Introduction
This extract generates the students' behavior data categorized based on the MT-specific Event and Resolution code set-up in the Incident Management.
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:
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 |
Behavior Resolution | ||
Resolution Type | Indicates the resolution type. | [PSRW_INCIDENTACTION] STATE_DETAIL_REPORT_CODE |
Resolution Assign Date | The resolution assign date. | [PSRW_INCIDENTACTION] ACTION_ACTUAL_RESOLVED_DT |
Resolution Start Date | The resolution start date. | [PSRW_INCIDENTACTION] ACTION_PLAN_BEGIN_DT |
Resolution End Date | The resolution end date. | [PSRW_INCIDENTACTION] ACTION_PLAN_END_DT |
Resolution Start Time | The resolution start time. | Always extracts as 00:00 |
Resolution End Time | The resolution end time. | Always extracts as 00:00 |
Duration In School Days | The resolution duration. | [PSRW_PARTICIPANTBEHACTDUR] DURATION_DETAIL |
Resolution Detail | The resolution details. | [PSRW_INCIDENTACTION] ACTION_RESOLVED_DESC |