Incident Offender Template

Introduction

This template connects one or multiple offenders to each specific incident. If there are multiple offenders, include multiple records within this template with the same Incident ID. The template generates records of 15 fields, for each Submitting District Code per Incident ID per Offender ID per School Year Date. Incident Template and Person Template must be submitted prior to this report. Offender Id on this report matches Person Id from the Person Template.

This report pulls incidents with Behavior codes 'A - Academic Code of Conduct' or 'C - Student Code of Conduct'.

Selection Criteria

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

School Selection

At least one incident record must have occurred at the school during the reporting period.

Student Selection

Student must not be excluded from state reporting.

Discipline Incident Selection

The Incident Type must be 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 select, only incidents that occurred at the current school will be included; therefore, students from another school may be included. 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 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)
Scheduling	Select when to run the report

Report Output

Each of the fields displayed in the output of the report is 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. 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 unique number that identifies this discipline incident. Extracted from Start Page > Student > Incidents	[Incident]Incident_Id	Alpha-numeric	30
3	Offender ID	The PAsecureID assigned to the student offender. Extracted from Start Page > Student > State/Province - PA > PAsecureID Data fields.	[Students]State_StudentNumber	Alpha-numeric	20
4	School Year Date	The last day of the school year. Calculated based on the [Terms]LastDay field. Format: YYYY-MM-DD	Calculated [Terms]LastDay	Alpha-numeric	10
5	Offender Type	The type of offender. For valid values, see Participant Role Codes.	[S_PA_LOG_X]Offender_Status_Code	Alpha-numeric	20
6	Age at Time of Incident	The age of the student at the time the incident occurred. Calculated based on the student’s date of birth and the incident date.	[Students]DOB [ReEnrollments]DOB	Numeric	3
7	Grade Level Code at Time of Incident	The grade level of the student at the time the incident occurred. 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). Both the grade level and grade code fields are extracted from Start Page > Student > Transfer Info > Edit Enrollment.	[Students]Grade_Level [S_PA_STU_X]State_Grade_Code [Reenrollments]Grade_Level [S_PA_REN_X]State_Grade_Code	Alpha-numeric	20
8	LLE Notified Indicator	Indicates whether local law enforcement was contacted regarding this incident. Valid values: Y - Yes N - No	[Incident] action attribute YES NO	Alpha-numeric	3
9	Name of LLE Contacted	The name of the local law enforcement office contacted regarding this offender and incident. Required if the local law enforcement was notified (Y in Field 8 - LLE Notifed)	[Incident]action attribute Name of LLE Contacted	Alpha-numeric	100
10	Arrested Code	Indicates whether the offender was arrested. Includes the Arrested Code Comment if one is stored. Extracted from Start Page > Student > Incidents Valid values: N-Not Arrested P-Arrest Pending YN-Arrested but not for weapons violation YW-Arrested for weapons violation	[Incident] action attribute N-NOT ARRESTED^ P-ARREST PENDING^ YN-ARRESTED BUT NOT FOR WEAPONS VIOLATION^ YW-ARRESTED FOR WEAPONS VIOLATION^	Alpha-numeric	20
11	Adjudication Code	The type of adjudication of the offender for the incident. Includes the Adjudication Comment if one has been stored. Extracted from Start Page > Student > Incidents. Valid values: 1-Adjudicated Delinquent 2-Convicted as Adult 6-Unknown 7-Withdrawal/Dismissal of Charges 8-Found Not Guilty 9-Found/Pled Guilty	[Incident]action attribute 1-ADJUDICATED DELINQUENT^ 2-CONVICTED AS ADULT^ 6-UNKNOWN^ 7-WITHDRAWAL/DISMISSAL OF CHARGES^ 8-FOUND NOT GUILTY^ 9-FOUND/PLED GUILTY^	Alpha-numeric	20
12	Not Collected
13	Weapon Detected Method Code	A description of how the weapons involved in the incident for the offender were detected. Required if Field 10 - Arrested Code is populated with YW. Valid Values: 1 – Detected by scanner / security 2 – Detected by school staff 3 – Detected by fellow student 4 – Detected by other adult visitor 5 – Other blank - Null (If no weapon is detected)	[Incident]action attribute 1 – DETECTED BY SCANNER/SECURITY^ 2 – DETECTED BY SCHOOL STAFF^ 3 – DETECTED BY FELLOW STUDENT^ 4 – DETECTED BY OTHER ADULT VISITOR^ 5 – OTHER^	Alpha-numeric	3
14	Weapon Detected Comment	Comment regarding the weapon detection. Required if Field 13 - Weapon Detected Method Code is 5 – Other	[Incident] participant attribute	Alpha-numeric	500
15	Not Collected	Not currently extracted.	N/A	N/A	N/A
16	Primary Disability Code	The student's primary disability code. For valid values, see Disability Codes Note: This field is required if Field 5 - Offender Type is 2 - Student with IEP	[S_PA_STU_X]Challenge_Type_Code	Alpha-numeric	4
17	Injury Severity Code	Specifies whether the offender sustained a physical injury. Valid values: 1 - Offender did not sustain physical injury 3 - Injury but NOT serious bodily injury 4 - Serious bodily injury 5 - Death	[Incident]participant attribute	Alpha-numeric	1
18	No Collected	Not currently extracted.	N/A	N/A	N/A
19	Not Collected	Not currently extracted.	N/A	N/A	N/A
20	Not Collected	Not currently extracted.	N/A	N/A	N/A
21	Offender District Of Residence	The district Administrative Unit Number (AUN) of the Charter school or District of Residence that sent the student to the current LEA. This value is extracted from the student's District of Residence field. If there is no value available in the District of Residence field or if the Reporting District Type is CD, the District AUN is extracted. Note: Required only if Field 5 - Offender Type is 1, 2, or 5; otherwise blank.	S_PA_STU_X.Charter_School_Code, if blank then [Students]DistrictOfResidence [ReEnrollments]DistrictOfResidence [District]Reporting_DistrictType value set to CD Or, if empty: [Prefs]Name=PA_districtAUN	Alpha-numeric	9
22	Primary Placement Indicator	The student's Primary Placement Type. Reported only if the Offender Role = 2-Student with IEP and there is an incident that falls within the special education program beginning and end dates.	[S_PA_SEN_SPED_X]Primary_Placement_Type_YN	Alpha-numeric	1