Student Discipline (GD) (Ohio Extracts)

Last Modified on 09/21/2026 9:01 am CDT

Path: Reporting > OH State Reporting > OH Extracts

The Student Discipline (GD) extract reports all incidents in which a student receives a discipline action (i.e., expulsion, suspension, etc).

Screenshot of the Ohio Student Discipline (GD) Extract EditorOhio Student Discipline (GD) Extract Editor

Report Population and Business Rules

Reports one record per Behavior Resolution mapped to a state resolution code that occurs on or between at least one day between 07/01 and 06/30 of the reporting school year.

A prior-year resolution may only be reported when it carries over into the reporting school year. To report:

  • The student must be actively enrolled on at least one day in the reporting year (Enrollment > Start/End Date).
  • The resolution must be mapped to a state resolution code.
  • The resolution End Date must occur on or after 07/01 in the reporting calendar year, if the resolution is set up to auto-calculate the Duration in School Days, OR the resolution Remaining Days is not blank/null.

Report Editor

The following table describes the options available in the extract editor.

Extract Field Description

Extract Type

The type of extract being generated. In this case, select Student Discipline (GD).

Reporting Period

Indicates when the report is being submitted. Options are:

  • A: Assessment

  • C: Calendar

  • G: Graduate

  • H: Financial

  • L: Staff/Course

  • S: Student

Date Range

The dates which determine which student enrollments will appear on the report, based on the Start and End Dates of enrollments within the selected calendar(s). The first date defaults to 07/10 of the calendar start year.

Format

The format in which the report will generate. Options are State Format (Fixed width), HTML, CSV and XML. Use HTML, CSV or XML formats for data review and verification and State Format for submission to the State.

Ad hoc Filter

Allows a previously created Ad hoc Filter to be selected that will limit what students appear in the report. Filters are created in the Filter Designer.

Include Protected Identity Info When this checkbox is marked, the extract includes the legal name entered on the Census > People > Identities tab. If only one part of the Protected Identity Information is entered, that part reports and the other name fields report blank. For example, if the Legal First Name is entered but the middle and last name fields are empty, then only the first name reports and the middle and last names report blank.

Calendar(s)

Students enrolled in the selected calendar(s) will appear in the report.

Generate the Extract

  1. Select the Student Discipline (GD) Extract Type.
  2. Select the proper Reporting Period.
  3. Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date. These fields will auto-populate with the recommended date range based on the ReportingPeriod selected.
  4. Select the Format. For submission to the state, select the State Format (Fixed width). To review data prior to state submission, select any of the other available formats.
  5. Select which calendar(s) to include within the extract.
  6. Select an Ad hoc Filter to only report students included in the filter.
  7. To include Protected Identity Information from the Identities tool, mark this checkbox. To exclude this information from the extract, leave the option unchecked. 
  8. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate. If generating multiple extracts at a time (after Campus.1921), requests can only be submitted to the Batch Queue.

Users have the option of submitting an Ohio Student Discipline report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Extract Layout

Element Name

Description & Format

Campus Location and Database Location

Filler

7 characters


Filler

1 character


Sort Type

Identifies the Sort Type. This field will always report a value of GD for the Student Discipline (GD).

N/A

Filler

1 character


Fiscal Year

The Fiscal Year will be the end of the school year. The fiscal year is July 1 - June 30.


Report end year of reporting school year. Example, if reporting 25-26, report 2026

System Administration > Calendar > School Years > End Year


Not Dynamically Stored

Reporting Period

The reporting period in which data is being pulled from.

OH State Reporting > OH Extracts > Reporting Period

Building IRN

The state assinged six-digit information retrieval number of the building.


Report Building IRN Override, if null report State School Number

Student Information > General > Enrollments > State Reporting Fields > Building IRN Override OR System Administration > Resources > School > School Detail > State School Number


Enrollment.buildingIRNOverride; enrollmentOH.smtIRNoverride

EMIS Student ID Number

The locally determined EMIS student ID.


Report Student Number. If null, zero fill.

Census > People > Person Identifiers > Student Number


Person.studentNumber

Date of Discipline

The date on which the incident resulting in a disciplinary action occurred. Reports the date on which the student engaged in the behavior that resulted in a discipline action. When the discipline administered crosses school years, Student Discipline Records should be reported in each year to reflect the discipline served in that year. In such cases, the Date of Discipline for both years’ records should be the same date, the date of the discipline incident.


Prior school year's incident dates may report when the discipline action (resolution) spans multiple years:

  • The resolution End Date occurs on or after 07/01 in the reporting calendar year, if the resolution is set up to auto-calculate the Duration in School Days, OR the resolution Remaining Days is not blank/null.
  • The resolution must be mapped to a state resolution code.

Date field, YYYYMMDD

Behavior Management > Incident > Incident Detail Information > Date of Incident


BehaviorResolution.discAssignDate

Type of Discipline

The type of resolution administered to the student.


A record per resolution reports when:

  • The incident has a Resolution ID mapped to a state resolution code.
  • Incidents not mapped to a resolution type code are excluded.
When an incident has multiple resolution types, one record reports per resolution type.

Behavior > Behavior Management > Incident > Resolution Details > Resolution Type


BehaviorResType.name; BehaviorResType.category
(Behavior.school DaysDuration)

Discipline Reason (First Reason)

The first reason for which a student was disciplined.


Report the first found Event with a tied State Event Code. When null, reports as **.

Behavior > Behavior Management > Incident > Event Type


BehaviorEvent.name

Discipline Reason (Second Reason)

The second reason for which a student was disciplined.


Report the second found Event with a tied State Event Code.


If NULL, report **.

Behavior > Behavior Management > Incident > Event Type (2nd)


BehaviorEvent.name2

Discipline Reason (Third Reason)

The third reason for which a student was disciplined.


Report the third found Event with a tied State Event Code (sys admin > behavior > event types > State Event Code).


If NULL, report **.

Behavior > Behavior Management > Incident > Event Type (3rd)


BehaviorEvent.name3

Discipline Reason (Fourth Reason)

The fourth reason for which a student was disciplined.


Report the fourth found Event with a tied State Event Code (sys admin > behavior > event types > State Event Code).


If NULL, report **.

Behavior > Behavior Management > Incident > Event Type (4th)


BehaviorEvent.name4

Discipline Reason (Fifth Reason)

The fifth reason for which a student was disciplined.


Report the fifth found Event with a tied State Event Code (sys admin > behavior > event types > State Event Code).


If NULL, report **.

Behavior > Behavior Management > Incident > Event Type (5th)


BehaviorEvent.name5

Discipline Sequence Number

The order in which the discipline incident occurred, if the incidents occurred on the same day and the same Type of Discipline was administered for both.


WHEN assigning a Discipline Sequence Number:

  1. IF two or more separate discipline incidents occur on the same Date of Discipline, 

    1. THEN assign each incident's record a unique Discipline Sequence Number, numbered in the order the incidents occurred (first incident = 1, second incident = 2, and so on).

  2. IF more than one resolution type results from a single incident, 

    • THEN assign each resulting record its own unique Discipline Sequence Number.

  3. IF suspension and expulsion result from the SAME incident, 

    • THEN report both suspension and expulsion as 2 separate records with its own unique Discipline Sequence Number.

  4. IF suspension and expulsion result from TWO SEPARATE incidents on the same date, 

    • THEN assign the Discipline Sequence Number based on the chronological order the incidents occurred. The incident that occurred first gets 1, the incident that occurred second gets 2

  5. Multi-year discipline events do not continue the sequence numbering but instead restart at 1 in the new year


No two records can share the same Discipline Sequence Number when they share the same Date of Discipline within the same reporting year.

Behavior > Behavior Management > Incident > Event Details


BehaviorResolution.timestamp

Total Discipline Days

Refers to the length of discipline, in Full Time Equivalency (FTE), for each discipline occurrence


Report the Total Discipline Days of ALL resolutions tied to the incident.


The resolution MUST have a State Resolution Code = NOT NULL.


Logic:

WHEN recording discipline days:

  1. THEN report the total number of days the student served using FTE (Full Time Equivalency) format

  2. THEN ensure total days served is greater than zero before creating a record

WHEN the student serves a full day:

  1. THEN record as 1.00

  2. WHEN the student serves part of a day

  3. THEN record as a decimal (example: half day = 0.50)

WHEN the student has more than one state mapped resolution type for the same incident

  1. THEN create a separate record for each resolution type

  2. THEN report only the days served for that discipline type in each record (example: 5 days of suspension and 5 days of expulsion = one record with 5.00 days for suspension and one record with 5.00 days for expulsion)

 

PATH A: Resolution Start Date and Resolution End Date are both provided:

  1. First Check to see if Resolution Start Date and Resolution End Date are provided 

    1. if they are provided use those Resolution Start/End Date 

    2. If Duration In School AND Resolution Start/End Date is not null

      1. Then ignore Duration In School 

  2. Condition: Resolution Start Date falls in the prior school year, and Resolution End Date falls in the current school year.

    1. Count the days served from Resolution Start Date through the last instructional day of the prior school year.

      1. Days Served (Prior Year) = Last Instructional Day of Prior School Year − Resolution Start Date + 1

    2. Report Record 1 in the prior school year using Days Served count.

    3. Count the remaining days from the first instructional day of the current school year through Resolution End Date.

      1. Remaining Days (Current Year) = Resolution End Date − First Instructional Day of Current School Year + 1

    4. Create Record 2 in the current (new) school year.

      1. Record 2 will report Remaining Days (Current Year)

    5. Record 2 uses the same Type of Discipline as Record 1.

    6. Record 2 uses the same Date of Discipline as Record 1.

    7. Record 2's Discipline Sequence Number continues on from Record 1's sequence number.

PATH B: DaysRemaining > Instructional Days

  1. First Check to see if Resolution Start Date AND DaysRemaining are not null. 

    1. else, null 

  2. Count how many instructional days are left between Resolution Start Date and Last day of Instruction 

  3. If the more DaysRemaining then Instructional days then:

    1. The "Resolution End Date" for this year's segment becomes the Last Day of Instruction.

    2. Subtract the days already used from the total Duration to get the leftover days.

    3. Starting from the First Day of Instruction next year, count forward that many leftover days to find the true final end date.

  4. If DaysRemaining does fit before the year ends, just calculate the end date normally, no rollover needed

To make "Days Remaining" appear in discipline then "Calculate End Date/Duration"  must be checked.


Valid Range:

00000 - 99999


NOTE: There is an assumed decimal in this value, allowing hundredths to be represented.


Examples

45.12 as 04512

45.1 as 04510

45 as 04500

450 as 45000

Behavior > Behavior Management > Incident > Resolution Details > Duration in School Days


Behavior.schoolDaysDuration

Discipline Modified

Indicates if the Chief Administrating Officer modified, on a case-by-case basis, the one-year expulsion requirement for possession of a firearm within a school.


Report Discipline Modified code. If null, report *.


Valid Options:

*: Not applicable
N: No
Y: Yes

Behavior > Behavior Management > Incident > Resolution Details > Discipline Modified


Behavior.explusionCode
(BehaviorResolution.modificationReason)

Referred for Alternate Educational Services

Indicates if a student serving a one-year expulsion for possession of a firearm within a school has a recommendation to receive alternate educational services.


Report Referred for Alternative Education code. If null, report *.


Valid Options:

*: Not applicable
N: No
Y: Yes

Behavior > Behavior Management > Incident > Resolution Details > Referred for Alternate Education


Behavior.expulsionSeriviceProvided
(BehaviorResolution.serviceProvided)

Building IRN where Discipline Incident Took Place

The state assigned six-digit information retrieval number (IRN) of the building.


Report the Location (Building IRN). If null, report State School Number.

Behavior > Behavior Management > Incident > Building IRN


BehaviorEvent.location
(BehaviorIncident.locationDescription)

Filler field for HTML and CSV formats

Victim of Student Violence		 Indicates the classification of the person or persons at whom a student’s violent behavior was directed.

See the Victim of Student Violence table below to determine the grouping code. 		Behavior > Behavior Management > Incident > Participant > Violence Directed At > Students, Teachers, Non-Teaching Staff, Other Persons

BehaviorEvent.staff
BehaviorEvent.other
BehaviorEvent.student
BehaviorEvent.teacher
Additional PS-3 Discipline Reason Detail Indicates, for students from preschool to grade 3, additional details on why a Type of Discipline of Expulsion or Out-of-school Suspension was assigned for a discipline incident.

If Additional PS-3 Discipline Reason Detail = NOT NULL, report code. Else report *.
  1. Reports from the most severe resolution if more than one is found.

 Behavior > Behavior Management > Incident > Resolution > PS-3 Discipline Reason Detail

BehaviorResolution.disciplineReason

Filler



Victim of Student Violence

Student Teacher Non-Teaching Staff Other Person Code


X
NT
X
X
BB

 X X
DD
X X FF

 X X X GG
X
X X HH
X X X
KK
X X X X LL
X


ST

 X

TC

X OT
X X

AA
X

X CC

 X
X EE
X X
X JJ

Related Articles

Was this helpful?
Thank you for your feedback!
User Icon

Thank you!

Terms of Use | Privacy Policy | infinitecampus.com