Incident Offender Disciplinary Action Template (EWS)

Contents

Introduction

This template is used to track disciplinary sanctions; it is an optional template for the Dashboard data submission. If LEAs choose to submit the template, all disciplinary actions assigned to an offender as the result of a particular incident should be submitted and all required fields in the template must be populated.

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 state 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.

Note: Incidents involving 'Staff' or 'Others' is not collected in the EWS Person Template, as it is not required.

Back to Top

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: 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.
Report Start Date*	Enter the start date for the reporting period – (Will report offenders on incidents on or after this date)*
Report End Date*	Enter the end date for the reporting period – (Will report offenders on incidents on or before this date)*
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. Run Now – Execute the report immediately. Schedule - Execute the report on the date and time specified. Start Date - Enter a start date to run the report. Start Time – Enter a start time to run the report. Select Run Once or Repeat to schedule how often the report is run.

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	Req'd
1	SUBMITTING DISTRICT CODE	The unique, 9-digit Administrative Unit Number (AUN) assigned by the Pennsylvania Department of Education. Note: All LEA and School codes can be found at http://www.edna.pa.gov/Screens/wfHome.aspx.	[Prefs]District_Number If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Numeric	R
2	INCIDENT ID	An identifier assigned by the LEA to the incident. This identifier must be unique within each LEA per school year.	Derived from the Internal ID that is created when an Incident is entered.	Numeric	R
3	OFFENDER ID	An identifier for the offender involved in an incident. Must be the same value used in the PERSON ID field (Field 2) within the Person template.	[Students]State_StudentNumber	Numeric	R
4	DISCIPLINARY ACTION CODE	The code of the sanction taken against the offender for the incident or the remedial program the offender has been referred to or is participating in.	Incident Management > Action Codes > State Sanction Valid Values^ or State Remedial Program Values^	AlphaNumeric	R
5	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.	Calculated [Terms]LastDay	Date	R
14	DISCIPLINARY ACTION DETERMINATION DATE	The date the disciplinary action was assigned to the student.	Action attribute > Action Plan Begin Date.	Date	R
16	DISCIPLINARY ACTION ID	Local LEA identifier used to identify the disciplinary action. Note: This field is required. If this field is not present, the loading process will reject the record and possibly the entire template.	Action ID (internal number used to uniquely identify the Action for this Incident)	AlphaNumeric	R
18	RESPONSIBLE LOCATION CODE	The PDE-defined, 4-digit code identifying the school responsible for overseeing the disciplinary action.	School where Incident occurred: Schools > PIMS_Location_Code	AlphaNumeric	R

Back to Top