Incident Victim Template

Contents

Introduction

This template connects one or multiple victims to each specific incident. In cases of incidents when there are crimes against property, such as vandalism in Field 5 of this template, Valid Value 8 (school/school facility) should be used. Note that not all incidents will have a victim. For example, a fighting incident will not have a victim (all parties are considered offenders in this case). See Appendix Z in Volume 2 of the PIMS User Manual for more information (the "Infraction has Victims?" column). If there are no victims associated with the incident, do not submit any records in this template.

Grain: One record per Submitting District Code / Incident ID / Victim ID / School Year Date

Selection Criteria

Selection criteria determines which database records are used in the report.

School Selection

The report selects records from the Schools table where at least one incident record occurred at the school during the reporting period.

Student Selection

The report selects the records from the Students table where student is not excluded from state reporting.

Discipline Incident Selection

The report selects the records from the Incident Management Tables where the Incident Type is State Reportable.

Report Input

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

Field	Description
Select Schools	Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria If sub-districts are enabled: Select Sub-district - Select the sub-district for which you want to run the report. Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. 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. Note: If Current School Only is selected, only incidents that occurred at the current school will be included; therefore, students from another school may be included. It students from the Current School who were involved in an incident at another school will not be included. For example, if John Smith from East High School was involved in an incident at West High School, he will be reported when running the report for West High School, but not when running the report for East High School.
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 that meet the selection criteria. Note: If All Students is selected, then incidents involving Staff or Others will be included. If Selected Students is selected, then Incidents involving Staff or Others will be excluded.
Select School Year	Select the applicable school year for which the data is needed.
Report Start Date	Enter the start date for the reporting period. (Incidents must occur on or after this date)
Report End Date	Enter the end date for the reporting period. (Incidents must occur on or after this date)
Scheduling	Choose when to run the report.

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	Submitting District Code	The unique 9-digit Administrative Unit Number assigned by the Pennsylvania Department of Education (PDE).	[Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	20
2	Incident ID	An identifier assigned by the LEA to the incident; this identifier must be unique within each LEA per school year.	[Incident]Incident_Id	Alpha-numeric	30
3	Victim ID	An identifier for the victim involved in an incident. This can be, but does not have to be, the PAsecureID if the victim is a current student. If the victim is not a current student, or if the LEA does not want to submit the PAsecureID, use an identifier assigned by the LEA. Must be the same value used in Field 2 (PERSON ID) within the Person template	[Students]State_StudentNumber	Alpha-numeric	20
4	School Year Date	A single date indicating the whole school year; the June 30 at the end of the standard school year is used to designate a school year. Thus, the 2014-2015 school year would be indicated by 2015-06-30	Calculated [Terms]LastDay	Alpha-numeric	10
5	Victim Type	The type of victim Valid Values: 1 – Student 2 – Student with IEP 3 – Student from another school 4 – Parent 5 – Adult visitor / intruder 6 – District employee 7 – Other or unknown 8 – School / school facility	[S_PA_LOG_X]Victim_Type	Alpha-numeric	1
6	Age at Time of Incident	The age of the victim at the time of the incident. This field is calculated based on the student’s date of birth and the incident date. Required if age is known. If unknown, leave null or blank.	Calculated [Students]DOB [ReEnrollments]DOB	Numeric	3
7	Grade Level Code at Time of Incident	The grade level of the victim at the time the incident occurred. This field is calculated based on the incident date and the student’s school enrollment during the reporting period (current or previous enrollment, whichever was active during the reporting period and on the incident date).	[Students]Grade_Level [S_PA_STU_X]State_Grade_Code [Reenrollments]Grade_Level [S_PA_REN_X]State_Grade_Code	Alpha-numeric	4
8	Student Assistance Program Referral Indicator	A Y/N indicator that specifies whether the victim was referred to the Student Assistance Program.	[S_PA_LOG_X]Referred_To_SAP_Program_TF	Alpha-numeric	3
9	Injury Severity Code	Specifies whether the victim sustained a physical injury. Valid Values: 1 - Victim did not sustain physical injury Discontinued 18-19: 2 Victim sustained physical injury 3 - Injury but not serious bodily injury 4 - Serious bodily injury 5 - Death	[S_PA_LOG_X]Injury_Severity_Code [Incident]participant attribute 1 – VICTIM DID NOT SUSTAIN PHYSICAL INJURY^ Discontinued 18-19 2-VICTIM DID SUSTAIN PHYSICAL INJURY^ 3-INJURY BUT NOT SERIOUS BODILY INJURY^ 4-SERIOUS BODILY INJURY^ 5-DEATH^	Alpha-numeric	20
10	Medical Treatment Required Indicator	A Y/N indicator that specifies whether the victim received medical treatment. Required if known Valid Value: Y or N	[S_PA_LOG_X]Medical_Treatment_TF	Alpha-numeric	3
11	Not Collected	This field is not currently extracted.	N/A	N/A	N/A
12	Incident Victim Comment	Comment regarding the medical treatment of the victim. Required if Field 10 (MEDICAL TREATMENT REQUIRED INDICATOR) is Y Example: Victim treated in ER and released	[S_PA_LOG_X]Medical_Treatment_Reason	Alpha-numeric	500

Back to Top