E01 - Student Safety

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.

ID

Data Element

Description

 [Table]FieldName

Length

E001

Fiscal Year

School year from the terms table.

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

District number (subdistrict if applicable).

[Prefs]Value

[Prefs]Name=districtnumber

3

E004

School Code

School number reporting the incident.

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.

IncidNum (E + sequential number): Unique incident identifier per student per date

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.

Indicates row type (1 = student behavior, 3 = participant action) Behavior classification codes derived from: [PSRW_PARTICIPANTBEHAVIOR]STATE_AGGREGATE_RPT_CODE (incident type) [PSRW_PARTICIPANTBEHAVIORACTION]STATE_AGGREGATE_RPT_CODE (action codes)

1

E008

Incident Date

The date that the incident occurred.

IncidDate: Incident timestamp (formatted YYYYMMDD)

8

E009

Incident Type

The type of infraction for discipline incident.

IncidType: Incident type code (from INCIDENT_DETAIL with incident category "GA Discipline Reporting") Source: INCIDENT_LU_CODE.CODE_TYPE = 'incidenttypecode' Valid codes: 00-36, 40, 42, 44, 45

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.

IncidLoc: Location code (from [PSRW_INCIDENTLOCATION]STATE_AGGREGATE_RPT_CODE) Special handling: If DataType = '3', location forced to '00' Otherwise: Left outer join to allow null/blank locations

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.

Populated ONLY if ActionCode = ‘90' (teacher report) Otherwise: '000000000' Source: Teachers table joined via PSRW_INCIDENTPARTICIPANT.role_code = 'Reporter' and role_subcode = 'Course Teacher^’

9

E012

Action Code

The code for the discipline action taken.

Discipline action taken (00, 02, 10, 20, 30, 40, 50, 60, 61, 62, 63, 70, 80, 90, 95) Source: STATE_AGGREGATE_RPT_CODE from behavior action records Valid actions: 00=No action, 02/20/30=Suspension, 40=Expulsion, 61-63=Other, etc.

2

E013

Action Auxiliary Code

Auxiliary/sub-category code for the action (when applicable)

Populated only when sub-category exists on the action Null for major action codes (00, 02, 10, 20, 30, 70, 80, 95)

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.

Source: Teachers table (administrators are recorded as teachers) Filtered by PSRW_INCIDENTPARTICIPANT.role_code = 'Reporter' and role_subcode = 'Administrator^'

9

E015

Event Identifier

Incident ID from the incident management system

[Incident]Incident_Id

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.

ContinOfServic: "Y" if special education services continued during discipline Only "Y" for actions 30 or 40 (suspension/expulsion) when GAA services = 'Y' Otherwise "N" Source: INCIDENT_ACTION_ATTRIBUTE with lu_code_id = 100162 and code_type = 'actionattribute' Personnel Involved

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. The State student number is also used for matching to other reports.

State student number for matching to other reports Student ID (internal): Links to the STUDENTS table Student enrollment status at time of incident: Must be actively enrolled on incident date (verified via PS_ENROLLMENT_ALL)

10

E018

Incident Severity Level

Level of severity per the Incident Type.

IncidSeverity: Severity level (from PSRW_INCIDENTACTIONATTRIBUTE with category "Incident Severity") Disciplinary Action Taken

1

E019

Discipline Process

Discipline process code.

From PSRW_INCIDENTACTIONATTRIBUTE category "Discipline Process (required for Actions 30, 40, 61)" Required for suspensions (30), expulsions (40), and certain other actions (61)

2

E020

Number of Days

Length of discipline (days) for applicable actions

Length of discipline (days) for applicable actions Only populated for suspension/expulsion codes (02, 20, 30) Calculated from PSRW_INCIDENTACTION.DURATION_ACTUAL × 10 Actions 00, 10, 40, 50, 61-63, 70, 80, 90, 95 = 0 days (no duration)

4

Filler

Filler

Filler

N/A

43