Incident Template
Contents
Introduction
This template defines the primary details of a discipline incident. One record should be submitted per each reportable School Safety incident. Grain: One record per Submitting District Code / School Year Date / Incident ID
Selection Criteria
Selection criteria determines which database records are used in the report. For the Incident Template, students' discipline incident records are selected.
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:
If sub-districts are enabled:
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: For Current School Only - Only incidents that OCCURRED at the Current School will be included; thus, students from another school may be included. It will NOT include students from the Current School who were involved in an incident at another school. 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, NOT East High School. |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If All Students is selected, then incidents involving Staff or Others are included. If Selected Students is selected, then incidents involving Staff or Others are 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)* |
Report Output – Incident Template Incident Management Data
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 AUN | 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 | 9 |
2 | School Year Date | The last day of the school year. This date is calculated based on the [Terms]LastDay field. Format: YYYY-MM-DD | [Terms]LastDay | Alpha-numeric | 10 |
3 | Incident ID | The number that identifies this discipline incident. | [Incident]Incident_Id | Alpha-numeric | 30 |
4 | Incident Date | The date the incident occurred. Format: YYYY-MM-DD | [Incident]Incident_TS | Alpha-numeric | 10 |
5 | School Number of Incident | The PDE code that identifies the school where the incident took place. This value is extracted from Start Page > District Setup > Schools/School Info > Edit School. If the PIMS Location Code is blank on that page, then the School Number associated with the Incident is reported. Note: If Location Code is other than 1, the Incident Time Frame is reported as blank. | [S_PA_SCH_X]PIMS_Location_Code or [Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID | Alpha-numeric | 4 |
6 | Local Incident ID | The database ID automatically assigned to the incident by PowerSchool. | Derived | Alpha-numeric | 30 |
7 | Incident Place Code | The location where the discipline incident occurred. This field is extracted from Start Page > Student > Incidents See the Appendix for valid values. | [Incident]locationcode attribute | Alpha-numeric | 2 |
8 | Incident Time Frame Code | The location where the discipline incident occurred. This field is extracted from Start Page > Student > Incidents INCIDENT TIME FRAME^ Note: If the Location Code is other than 1, Incident Time Frame is reported as blank. | [Incident]timecode attribute 1-BEFORE SCHOOL HOURS^ 2-DURING SCHOOL HOURS^ 3-AFTER SCHOOL HOURS^ | Alpha-numeric | 5 |
9 | Incident Against Property Indicator | A Y/N indicator that specifies whether the incident was against property | N/A | Alpha-numeric | 5 |
10 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
11 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
12 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
13 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
14 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
15 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
16 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
17 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
18 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
19 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
20 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
21 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
22 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
23 | Not Collected | This field is not currently extracted. | N/A | N/A | N/A |
24 | Unfounded Indicator | A Y/N indicator that identifies a reported incident determined to be unfounded. | [Incident_Attribute]text_attribute | Alpha-Numeric | 1 |
25 | LLE Incident Number | The incident number used by the local law enforcement agency to identify the incident. | [Incident_Action_Attribute]text_attribute | Alpha- Numeric | 5 |