Incident Offender Infraction Template

Contents

Introduction

This template connects an incident and the offender to an infraction. If multiple infractions apply to the incident/offender submit multiple records; use one record per infraction. If the offender is unknown for an incident, do not submit a record in this template.

Grain: One record per Submitting District Code / Incident ID / Offender ID / Infraction Code / 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.

Back to Top

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 before this date)

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 PDE. This field is extracted from Start Page > District Setup > District Information.	[Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Alpha-numeric	20
2	Incident ID	The number that identifies this discipline incident. This field is extracted from Start Page > Student > Incidents	[Incident]Incident_Id	Alpha-numeric	30
3	Offender ID	The PAsecureID assigned to the student.	[Students]State_StudentNumber	Alpha-numeric	20
4	Infraction Code	The infraction committed by the offender. If the offender committed multiple infractions, one record for each infraction associated with the offender and incident is included in the extract. For valid values, see Infraction Codes.	[S_PA_LOG_X]Against_Person [S_PA_LOG_X]Against_Property [S_PA_LOG_X]Against_Society [S_PA_LOG_X]Illegal_Possession_Of_Weapon [S_PA_LOG_X]Illegal_Possession_Code	Alpha-numeric	20
5	School Year Date	This field displays the last day of the school year. It is calculated based on the [Terms]LastDay field. Format: YYYY-MM-DD	Calculated [Terms]LastDay	Alpha-numeric	10
6	Weapon Count	If weapons were involved, specify the total number of weapons for this offender, for this incident, and the infraction code. Required if Field 4 (Infraction Code) is between 39-46	[S_PA_LOG_X]Weapon_Count	Numeric	4
7	Infraction Comment	A comment regarding the nature of the infraction Required if Infraction Code is 16,41,46	[S_PA_LOG_X]Infraction_Comment	Alpha-numeric	500

Back to Top