Skip to main content
Skip table of contents

Incident Offender Infraction Template

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.

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)

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

Not collected

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.