E01 - Student Safety

Introduction

The E01 - Student Safety report extracts student safety incident data. One record is transmitted for each incident or disciplinary action that occurs during the school year, regardless of whether the student is active at the end of the school year. Discipline records are not reported for pre-K students.

Selection Criteria

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

Student Selection

The report selects records from the [Students] table that are associated with a log entry record from the Log Entry Selection below. [Students]ID = [Log]StudentID.
The student must not be excluded from state reporting.
The report selects records from the [Students] table only if the incident date is within the report start and end dates. The report does not consider the enrollment dates.

Log Entry Selection

The report selects records from the [Log] table based on the following criteria:

The log entry Incident Date ([08]Discipline_IncidentDate) must occur on or after the report start date.
The log entry Incident Date must occur on or before the report end date.
The field "During disciplinary action did student receive educational services?" should not be blank.
Either the Action Taken Detail OR Incident Type Category must be state reportable. The following OR condition is considered:
- The log entry Action Taken Detail ([08]Discipline_ActionTakenDetail) must equal 00, 02, 10, 20, 30, 40, 50, 60, 61, 62, 63, 70, 80, 90, or 95, OR
- The log entry Incident Type Category ([08]Discipline_IncidentTypeCategory) must equal 00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 40, 42, or 44.
  - Note: Only the above Incident Type Categories are reported, regardless of whether other categories - such as 99 - are entered in the Incident Type Category field.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Select Schools	If run at the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report All Schools – Run the report for the entire district. 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.
Current Selection Students	Run the report for the current selection of students or all students.
Report Start Date	Enter the start date of the report. Note: Enter the date in a format of MM/DD/YYYY.
Report End Date	Enter the end date of the report. Note: Enter the date in a format of MM/DD/YYYY.
File Path and File Suffix	The File Path and File Suffix must both be valid in order to save the results to a location on the server. The File Name will be the district number, date, and time, in the format dddYYYYMMDDHHmi, followed by the provided file suffix. For example a report run at district 999 on August 1, 2014 at 9:15 AM with a suffix of _AAA.txt will save the results to a file named 999201408010915_AAA.txt in the provided location. If no path is given, or if PowerSchool is unable to write to the given folder, the report will run but will not be saved to the server.
SFTP Connections	Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically. Please refer to Setting Up a SFTP Connection for details on how to create a SFTP connection.

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.

The students with Dexter Mosely set as Yes in the State Information page are not included in the report output.

ID	Data Element	Description	[Table]FieldName	Length
E001	Fiscal Year	The fiscal year of the record. The report extracts the year based on the last day in the current school calendar.	[Terms]LastDay	4
E002	Period	The reporting period. Always 1.	N/A	1
E003	System Code	The school system code. This is the district number in PowerSchool.	[Prefs]Value [Prefs]Name=districtnumber	3
E004	School Code	The school code. Note: If the HomeSchool Override Number is set up, it will be used. If not, the alternate school number is reported if populated. Otherwise, the school number is reported.	[S_GA_STU_X]SchoolNumberOverride [S_GA_REN_X]SchoolNumberOverride [Schools]Alternate_School_Number [Schools]School_Number	4
Filler	Filler	Filler	N/A	9
E006	Incident Number	A sequential number that identifies a specific discipline incident. Each discipline incident for a student should have a unique discipline incident number. Note: The report determines whether the student has multiple discipline incidents and numbers the incidents sequentially. The report also determines if the discipline incident is part of a multiple incident or multiple action entry based on the Data Type Indicator.	The counter uses the following fields: [Log]StudentID [Log]Discipline_IncidentDate [Log]Discipline_ActionTakenDetail [Log]Discilpine_IncidentTypeCategory (SQL:Log.IncidentTypeCategory)	4
E007	Data Type Indicator	A code that identifies whether the record is complete, with the incident and action taken, or whether it is a continuation of a multiple incident or action event.	[S_GA_LOG_X]DataType	1
E008	Incident Date	The date that the incident occurred.	[Log]Discipline_IncidentDate	8
E009	Incident Type	The type of infraction for discipline incident.	[Log]Discipline_IncidentTypeCategory (SQL:Log.IncidentTypeCategory)	2
E010	Incident – Context and Location	The location, time and sponsorship of the activity during which the discipline incident occurred. Note: The report extracts 00 if the Data Type Indicator is 3.	[S_GA_LOG_X]Location [S_GA_LOG_X]DataType	2
E011	Course Teacher Code	The social security number (dashes removed) of the Reporter who is tagged as the Course Teacher in the Incident. Note: This field is extracted if the Discipline Action Code is 90. Otherwise, the report extracts a null value. Note: The report converts the Course Teacher Code to SSN.	[Users]SSN [SchoolStaff]ID = [Log]Discipline_ReporterID	9
E012	Action Code	The code for the discipline action taken.	[Log]Discpline_ActionTakenDetail	2
E013	Action Auxiliary Code	Indicates auxiliary information as noted. Any ACTION that requires the reporting of days, will now be reported in the new data element: ‘NUMBER OF DAYS’.	[S_GA_LOG_X]DisciplineAuxCode	4
E014	Administrator Code	The social security number of the Reporter who is tagged as the Administrator in the incident. This must be the same number used to report the person in CPI. Note: The report converts the Administrator Code to SSN.	[Log]Discipline_AdministratorID	9
E015	Event Identifier	The sequence number that uniquely identifies an event that involved multiple students. This identifier allows multiple students to be associated with a single incident and is required for events involving multiple students.	[S_GA_LOG_X]EventIdentifier	4
E016	Continuation of Services	Indicates whether the student continued to receive educational services during the disciplinary action for students who were suspended or expelled. Note: Report extracts Y if the Discipline Action Code is equal to 30, 40 and the Continuation Code is Y.	[S_GA_LOG_X]Services [Log]Discipline_ActionTakenDetail	1
E017	GTID	The identification number assigned to each student to uniquely identify the student throughout his/her public education years in the Georgia public school system.	[Students]State_StudentNumber	10
E018	Incident Severity Level	Level of severity per the Incident Type.	[Log]Discipline_IncidentContext	1
E019	Discipline Process	Level of severity per the Incident Type. Identifies the process a student goes through when certain actions are reported.	[S_GA_LOG_X]DisciplineProcess	2
E020	Number of Days	In prior years, the Auxiliary Code was used to report both codes and days for certain actions. Half days had to be reported with a code ‘99’ because the Auxiliary Code could not accommodate decimals. Starting this year, any action requiring the reporting of days has been removed from the Auxiliary Code to its own data element the allows one decimal position. The far right digit is the decimal position.	[S_GA_LOG_X]NumberOfDays	4
Filler	Filler	Filler	N/A	43

Back to Top