Incident Template (EWS)
Contents
Introduction
This template defines the primary details of a discipline incident. An incident is defined as a specific act or offense involving one or more victims or offenders. All incidents with known offenders should be included in the Dashboard Data Submission, including school code of conduct violations and state reportable offenses.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
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 EWS reporting.
Discipline Incident Selection
The report selects the records from the Incident Management Tables where the Incident Type is State Reportable.
Running report 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.
Incidents involving 'Staff' or 'Others' will not be included in the EWS Incident Template as it is not a requirement.
Report Input
For help with report navigation and generation, see How to Find and Generate a Report.
Field | Description |
Schools to Include* | 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. |
Report Start Date* | Enter the start date using the format mm/dd/yyyy for the first day of the reporting period. |
Report End Date* | Enter the end date using the format mm/dd/yyyy for the last day of the reporting period. |
Field Delimiter | Choose the field delimiter for the extract file from the pop-up menu. |
Include Header Labels in output file? | Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report. |
Scheduling | Select when to run the report.
|
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 | Req'd |
|---|---|---|---|---|---|
1 | SUBMITTING DISTRICT CODE | The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite. | [Prefs]Value where [Prefs]Name=PA_districtAUN If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number | Numeric | R |
2 | SCHOOL YEAR DATE | A single date indicating the whole school year. 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. | Derived based on - [Terms]LastDay | Numeric | R |
3 | INCIDENT ID | An identifier assigned by the LEA to the incident. This identifier must be unique within each LEA per school year. | Derived - Assigned internally when an incident is created. | Numeric | R |
4 | INCIDENT DATE | The date the incident took place. | Derived | Date | R |
5 | LOCATION CODE OF INCIDENT | The PDE-defined, 4-digit code identifying the school where the incident took place. For the list of all LEA and School codes, visit the Pennsylvania Department of Education's wesite. | [S_PA_SCH_X]PIMS_Location_Code or [Schools]School_Number If sub-districts are enabled: [CST_SchoolSubDistricts]SchoolID | Numeric | R |
9 | INCIDENT AGAINST PROPERTY INDICATOR | A Y/N indicator that specifies whether the incident was against property. | Incident Management > Attribute Codes > AGAINST PROPERTY INDICATOR | Y/N | R |