PowerSchool SIS Ohio

(GD) Student Discipline Record

Introduction

The (GD) Student Discipline Record report provides required state information regarding reportable discipline actions.

Selection Criteria

Selection criteria determine which database records are used for the (GD) Student Discipline Record.

School Selection

The report selects which school records to use based on the following criteria:

  • The school must be associated with a student included in the report.

Student Selection

The report selects which student records to use based on the following criteria:

  • The student must be enrolled during the report start and end dates.

  • The student is not excluded from state reporting (State/Province-OH > Home > State_ExcludeEnrollment or for a previous fiscal year S_OH_STU_SNAP_C.State_ExcludeFromReporting).

Log Selection

When Logs is selected as the data source, the report selects which Log Entries to include based on the following criterion:

  • The Action Date must be within the report start and end dates.

Incident Management Selection

The report selects which Incident Management records to include based on the following criterion:

  • The incident date must be within the report start and end dates.

Discipline Reporting Source

Select the source that contains the discipline records to report. The report supports two options:

  • Logs: Uses discipline log entries and the log-entry fields described in the output table below.

  • Incident Management: Uses Incident Management records whose incident date falls within the report dates and the Incident Management fields described in the separate output table.

Report Input

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

The report input is done in Data and Reporting > Reports > Compliance Reports > (GD) Student Discipline Record. 

Field

Description

Schools for which to run?*

Choose one of the following:

  • Select Multiple Schools – Includes all student records associated with the school(s) that meet the selection criteria

  • All Schools (default) – Includes all student records on the PowerSchool server that meet the selection criteria.

Current Selection Students*

Indicate which students to include in the report by selecting one of the following options:

  • The Selected [number] Students Only – Run the report for students in the current selection.

  • All Students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Report Start Date

Enter the start date for reporting period.

Format: [M]M/[D]D/[YY]YY

Report End Date

Enter the end date for the reporting period.

Format: [M]M/[D]D/[YY]YY

Data Source For Discipline

Indicate which source to pull discipline data from within PowerSchool. Select Incident Management to report records based on Incident Management incidents whose incident date is within the report start and end dates, or select Logs to report discipline log entries whose action date is within the report start and end dates.

  • Incident Management

  • Logs

Reporting Period

This is defaulted to S.

Fiscal Year

Enter the fiscal year for the report.

Scheduling

Run Now

Select this option to execute the report in the order it is received in the report queue.

Schedule (available Version 7.1.1.)

Enter the start date and start time for the report.

  • Select Run Once and Submit to run the report at the specified date and time.

  • Select Repeat to set future dates (Daily, Weekly, Monthly, Yearly) and Submit.

Important: Use the same discipline data source for the entire fiscal year. Do not combine Log entries for part of the fiscal year with Incident Management records for the remainder of the fiscal year.

Report Output

Each of the fields displayed in the output of the report are described below. The report output depends on the selected discipline data source, refer to the output table based on the data source chosen. See Understanding the Report Output Table for a definition of each column in the table. The output is aligned to the Ohio Department of Education parameters for the Student Discipline (GD) Record.

Key reporting considerations for the GD

  • One record per administered and served discipline type: Report a separate GD record for each Type of Discipline administered to and served by the student for an incident. If discipline spans school years, report the served portion in each applicable year using the same incident date.

  • Incident ownership and location: The last building in the district where the student was enrolled and the action was administered reports the record. GD120 identifies where the incident occurred and may differ from GD040; use 999999 when the location is a non-EMIS reporting entity.

  • Date and days: GD060 is the date the behavior/incident occurred. GD090 is the FTE days served for the discipline type in the current school year. Do not report a GD record when no discipline time was served.

  • Reasons: GD080 supports up to five distinct reasons, with the primary reason first. GD080 First Reason cannot be Not Applicable; use an applicable reason code when discipline is reportable.

  • Sequence and uniqueness: GD085 must distinguish records for separate incidents occurring on the same date and for multiple discipline types administered for one incident. The unique key is Date of Discipline + Type of Discipline + Sequence Number.

Incident Management Output

When Incident Management is selected as the data source, the report output uses Incident Management records with an incident date within the report start and end dates. The source attributes for the fields below are located in Incident Management. Each field may be calculated from one or more tables; the underlying table relationships are not shown in this table.

Item #

Data Element

Description

Source Attribute

Field Type

Field Length

Begin/End Position

N/A

Filler

Filler

N/A

Numeric

8

1–8

GD010

Sort Type

The sort type equals GD for the Student Discipline extract.

N/A

Alpha-numeric

2

9–10

N/A

Filler

Filler

N/A

Alpha-numeric

1

11

GD020

Fiscal Year

The fiscal year is set by the report input.

N/A

Alpha-numeric

4

12–15

GD030

Data Set

This is the reporting period entered on the report parameter.

N/A

Alpha-numeric

1

16

GD040

Building IRN

This field contains the six-digit IRN of the building where the student was enrolled last within the reporting district and where the discipline action was administered. This building reports the GD record; it may differ from the building where the incident occurred.

[Students]SchoolID

Alpha-numeric

6

17–22

GD050

EMIS Student ID Number

This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the Student Profile > Demographics page and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.

[Students]State_StudentNumber

Alpha-numeric

9

23–31

GD060

Date of Discipline

This field contains the date the discipline incident occurred—the behavior that resulted in a discipline action. For discipline administered over multiple days, report the first incident date; when the discipline crosses school years, use that same incident date in each year’s record.

Incident Management > Incident Details > Incident Date

Alpha-numeric

8

32–39

GD070

Type of Discipline

This field contains each type of discipline administered to and served by the student for the incident. Report a separate GD record for each administered and served type; do not suppress a type when multiple types apply to one incident. If no discipline time was served, do not report a GD record.

Incident Management > Incident Details > Edit Participants > Actions

Alpha-numeric

1

40

GD080

Discipline Reason (First Reason)

This field contains the primary reason for the discipline incident. Districts may report up to five distinct reasons in GD080, with the primary reason in First Reason. First Reason cannot be Not Applicable; do not repeat a reason within the same incident.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Discipline Reason

Alpha-numeric

2

41–42

GD080

Discipline Reason (Second Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Second) field on the Log Entry page when the Log Type is Discipline.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Discipline Reason (Second)

Alpha-numeric

2

43–44

GD080

Discipline Reason (Third Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Third) field on the Log Entry page when the Log Type is Discipline.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Discipline Reason (Third)

Alpha-numeric

2

45–46

GD080

Discipline Reason (Fourth Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Fourth) field on the Log Entry page when the Log Type is Discipline.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Discipline Reason (Fourth)

Alpha-numeric

2

47–48

GD080

Discipline Reason (Fifth Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Fifth) field on the Log Entry page when the Log Type is Discipline.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Discipline Reason (Fifth)

Alpha-numeric

2

49–50

GD085

Discipline Sequence Number

This field contains the sequence for discipline incidents that share a date and for records requiring distinct sequencing. The combination of Date of Discipline, Type of Discipline, and Sequence Number must be unique for each GD record in the reporting year. If blank, 1 is the default.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Discipline Sequence Number

Numeric

1

51

GD090

Total Discipline Days

This field contains the FTE length of discipline served for the discipline type reported in this record during the current school year. For discipline that crosses school years, report the portion served in each year. If no discipline time was served, do not report a GD record.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Total Discipline Days

Numeric

5 with 2 decimal places

52–56

GD100

Discipline Modified

Report Y or N only when the Type of Discipline is Expulsion and the Discipline Reason includes 06 (firearm) and/or 08 (explosive, incendiary, or poison gas). Y indicates that the chief administering officer modified the one-year expulsion requirement in writing on a case-by-case basis; N indicates it was not modified. Report * in all other circumstances. Expulsion remains reportable when modified.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Discipline Modified

Alpha-numeric

1

57

GD110

Referred for Alternate Educational Services

Report Y or N only when the one-year expulsion requirement was modified (GD100 = Y) for a firearm or explosive-related expulsion (Discipline Reason 06 and/or 08). Y indicates that the student was recommended for alternate educational services; N indicates that the student was not. Report * when GD100 is N or *, when the Type of Discipline is not Expulsion, or when the applicable reasons are not 06 or 08.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Referred for Alternative Program

Alpha-numeric

1

58

GD120

Building IRN where Discipline Incident Took Place

This field contains the six-digit IRN of the building where the discipline incident occurred. It may identify another building in the district, a building outside the district, an ESC, JVSD, or another EMIS reporting entity. Report 999999 when the incident occurred at a non-EMIS reporting entity.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Building IRN Where Discipline Incident Took Place

Alpha-numeric

6

59–64

GD140

Additional PS-3 Discipline Reason Detail

This field provides additional detail for a student in preschool through grade 3 when Expulsion or Out-of-school Suspension was assigned. Report A for an ORC §3313.66(B)(2)–(5) exemption, B for an Immediate Health and Safety Exemption, and N when neither exemption applies. Report * when the student was not in grades PS–3 or when the discipline type was not Expulsion or Out-of-school Suspension.

Incident Management > Incident Details > Edit Participants > Actions > Action Attributes > Additional Grade PS-3 Detail

Alpha-numeric

1

67

Log Entries Output

Item #

Data Element

Description

[Table]FieldName

Field Type

Field Length

Begin/
End Position

N/A

Filler

Filler

N/A

Numeric

8

1–8

GD010

Sort Type

The sort type equals GD for the Student Discipline extract.

N/A

Alpha-numeric

2

9–10

N/A

Filler

Filler

N/A

Alpha-numeric

1

11

GD020

Fiscal Year

The fiscal year is set by the report input.

N/A

Alpha-numeric

4

12–15

GD030

Data Set

This is the reporting period entered on the report parameter.

N/A

Alpha-numeric

1

16

GD040

Building IRN

This field contains the six-digit IRN of the building where the student was enrolled last within the reporting district and where the discipline action was administered. This building reports the GD record; it may differ from the building where the incident occurred.

[Students]SchoolID

Alpha-numeric

6

17–22

GD050

EMIS Student ID Number

This field contains the EMIS student ID number assigned by the district to this student. This field value is extracted from the Student Number field on the Student Profile > Demographics page and prepended with the EMIS Prefix ID, if entered, else zeroes are added to create a 9-digit number.

[Students]State_StudentNumber

Alpha-numeric

9

23–31

GD060

Date of Discipline

This field contains the date the discipline incident occurred—the behavior that resulted in a discipline action. For discipline administered over multiple days, report the first incident date; when the discipline crosses school years, use that same incident date in each year’s record.

[Log]Discipline_ActionDate

Alpha-numeric

8

32–39

GD070

Type of Discipline

This field contains each type of discipline administered to and served by the student for the incident. Report a separate GD record for each administered and served type; do not suppress a type when multiple types apply to one incident. If no discipline time was served, do not report a GD record.

[S_OH_LOG_X]Discipline_Type

Alpha-numeric

1

40

GD080

Discipline Reason (First Reason)

This field contains the primary reason for the discipline incident. Districts may report up to five distinct reasons in GD080, with the primary reason in First Reason. First Reason cannot be Not Applicable; do not repeat a reason within the same incident.

[S_OH_LOG_X]Discipline_Reason

Alpha-numeric

2

41–42

GD080

Discipline Reason (Second Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Second) field on the Log Entry page when the Log Type is Discipline.

[S_OH_LOG_X]Discipline_Reason_2

Alpha-numeric

2

43–44

GD080

Discipline Reason (Third Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Third) field on the Log Entry page when the Log Type is Discipline.

[S_OH_LOG_X]Discipline_Reason_3

Alpha-numeric

2

45–46

GD080

Discipline Reason (Fourth Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Fourth) field on the Log Entry page when the Log Type is Discipline.

[S_OH_LOG_X]Discipline_Reason_4

Alpha-numeric

2

47–48

GD080

Discipline Reason (Fifth Reason)

This field may contain another reason that the student was disciplined. This field value is extracted from the Discipline Reason (Fifth) field on the Log Entry page when the Log Type is Discipline.

[S_OH_LOG_X]Discipline_Reason_5

Alpha-numeric

2

49–50

GD085

Discipline Sequence Number

This field contains the sequence for discipline incidents that share a date and for records requiring distinct sequencing. The combination of Date of Discipline, Type of Discipline, and Sequence Number must be unique for each GD record in the reporting year. If blank, 1 is the default.

[S_OH_LOG_X]Discipline_Sequence

Numeric

1

51

GD090

Total Discipline Days

This field contains the FTE length of discipline served for the discipline type reported in this record during the current school year. For discipline that crosses school years, report the portion served in each year. If no discipline time was served, do not report a GD record.

[S_OH_LOG_X]Discipline_Days

Numeric

5 with 2 decimal places

52–56

GD100

Discipline Modified

Report Y or N only when the Type of Discipline is Expulsion and the Discipline Reason includes 06 (firearm) and/or 08 (explosive, incendiary, or poison gas). Y indicates that the chief administering officer modified the one-year expulsion requirement in writing on a case-by-case basis; N indicates it was not modified. Report * in all other circumstances. Expulsion remains reportable when modified.

[S_OH_LOG_X]Discipline_Modified

Alpha-numeric

1

57

GD110

Referred for Alternate Educational Services

Report Y or N only when the one-year expulsion requirement was modified (GD100 = Y) for a firearm or explosive-related expulsion (Discipline Reason 06 and/or 08). Y indicates that the student was recommended for alternate educational services; N indicates that the student was not. Report * when GD100 is N or *, when the Type of Discipline is not Expulsion, or when the applicable reasons are not 06 or 08.

[S_OH_LOG_X]Discipline_Referred

Alpha-numeric

1

58

GD120

Building IRN where Discipline Incident Took Place

This field contains the six-digit IRN of the building where the discipline incident occurred. It may identify another building in the district, a building outside the district, an ESC, JVSD, or another EMIS reporting entity. Report 999999 when the incident occurred at a non-EMIS reporting entity.

[S_OH_LOG_X]Discipline_IRN

Alpha-numeric

6

59–64

GD140

Additional PS-3 Discipline Reason Detail

This field provides additional detail for a student in preschool through grade 3 when Expulsion or Out-of-school Suspension was assigned. Report A for an ORC §3313.66(B)(2)–(5) exemption, B for an Immediate Health and Safety Exemption, and N when neither exemption applies. Report * when the student was not in grades PS–3 or when the discipline type was not Expulsion or Out-of-school Suspension.

[S_OH_LOG_X]PS3_Discipline_Code

Alpha-numeric

1

67