Tool Search: OH Extracts
The Student Discipline (GD) extract reports all incidents in which a student receives a discipline action (i.e., expulsion, suspension, etc).
Image 1: Ohio Student Discipline (GD) Extract Editor
Report Logic
The last building in a district where a student was enrolled and where discipline action was administered is required to report a record for the student on the Student Discipline extract. This means that even if a student is enrolled in a different district at the end of the year, the building and district in which the event occurred and discipline action was taken is still responsible for reporting a record.
A record is reported for each individual incident in which the State Resolution Code is 1-4, 6 or 7. If students have multiple Identity records, only one record reports per student based on their most recent identity.
Generating the Extract
- Select the Student Discipline (GD) Extract Type.
- Select the proper Reporting Period.
- 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 Reporting Period selected.
- 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.
- Select which calendar(s) to include within the extract.
- Select an Ad hoc Filter to only report students included in the filter.
- 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 |
|---|---|---|
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). Alphanumeric, 2 characters | N/A |
Filler | 1 character | |
Fiscal Year | The Fiscal Year is determined by the end year of the reporting school year (i.e., 2009 for the 2008-2009 school year). CCYY, 4 characters | System Administration > Calendar > School Years > End Year Not Dynamically Stored |
Reporting Period | The reporting period in which data is being pulled from. Alphanumeric, 1 character | OH State Reporting > OH Extracts > Reporting Period |
Building IRN | The building’s state assigned six-digit information retrieval number (IRN). Alphanumeric, 6 characters | 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. Alphanumeric, 9 characters | Census > People > Person Identifiers > Student Number Person.studentNumber |
Date of Discipline | The date the behavior resolution began. CCYYMMDD, 8 characters | Behavior > Behavior Management > Incident > Resolution Details > Resolution Start Date BehaviorResolution.discAssignDate |
Type of Discipline | The type of behavior resolution. Alphanumeric, 1 character | Behavior > Behavior Management > Incident > Resolution Details > Resolution Type BehaviorResType.name; BehaviorResType.category |
Discipline Reason (First Reason) | The first behavior event tied to a State Event Code. Alphanumeric, 2 characters | Behavior > Behavior Management > Incident > Event Type BehaviorEvent.name |
Discipline Reason (Second Reason) | The second behavior event tied to a State Event Code. Alphanumeric, 2 characters | Behavior > Behavior Management > Incident > Event Type (2nd) BehaviorEvent.name2 |
Discipline Reason (Third Reason) | The third behavior event tied to a State Event Code. Alphanumeric, 2 characters | Behavior > Behavior Management > Incident > Event Type (3rd) BehaviorEvent.name3 |
Discipline Reason (Fourth Reason) | The fourth behavior event tied to a State Event Code. Alphanumeric, 2 characters | Behavior > Behavior Management > Incident > Event Type (4th) BehaviorEvent.name4 |
Discipline Reason (Fifth Reason) | The fifth behavior event tied to a State Event Code. Alphanumeric, 2 characters | Behavior > Behavior Management > Incident > Event Type (5th) BehaviorEvent.name5 |
Discipline Sequence Number | The order in which the behavior events occurred. Alphanumeric, 1 character | Behavior > Behavior Management > Incident > Event Details BehaviorResolution.timestamp |
Total Discipline Days | Indicates the Full Time Equivalency for each behavior resolution. Only resolutions with a State Resolution Code will be included. Numeric, 5 characters | Behavior > Behavior Management > Incident > Resolution Details > Duration in School Days Behavior.schoolDaysDuration |
Discipline Modified | Indicates if the Chief Administrating Office modified, on a case-by-case basis, the one-year expulsion requirement for possession of a firearm within a school. Alphanumeric, 1 character | Behavior > Behavior Management > Incident > Resolution Details > Discipline Modified Behavior.explusionCode |
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. Alphanumeric, 1 character | Behavior > Behavior Management > Incident > Resolution Details > Referred for Alternate Education Behavior.expulsionSeriviceProvided |
Building IRN where Discipline Incident Took Place | The building’s state assigned six-digit information retrieval number (IRN). Alphanumeric, 6 characters | Behavior > Behavior Management > Incident > Building IRN BehaviorEvent.location |
| Victim of Student Violence | Indicates who the violence was directed at in the behavior event. Reports a code based on the options selected. See the following Victim of Violence table for codes. Alphanumeric, 2 characters | 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 | Reports the PS-3 Discipline Reason Detail code if selected. If more than one resolution is entered, reports the value selected for the most severe. Alphanumeric, 2 characters. | Behavior > Behavior Management > Incident > Resolution > PS-3 Discipline Reason Detail BehaviorResolution.disciplineReason |
Filler |
Behavior Resolution Options
Code | Description |
|---|---|
1 | Expulsion |
2 | Out-of-School Suspension |
3 | In-School Suspension |
4 | In-School Alternate Discipline Class/Prog/Building |
6 | Emergency Removal by District Personnel |
7 | Removal by a Hearing Officer |
Behavior Event Options
Code | Description |
|---|---|
** | Not Applicable |
01 | Truancy |
03 | Fighting/Violence |
04 | Vandalism (Damage to School or Personal Property) |
05 | Theft (Stealing Personal or School Property) |
06 | Firearm |
07 | Weapon other than Firearm, Explos, Incend or Pois |
08 | Explosive, Incendiary or Poisonous Gas |
09 | Tobacco Products |
10 | Intoxicating Alcoholic Beverages |
11 | Drugs Other Than Tobacco or Alcohol |
14 | False Alarms/Bomb Threat |
18 | Disobedient/Disruptive Behavior |
19 | Harassment/Intimidation |
20 | Firearm Look-a-Likes |
21 | Unwelcome Sexual Conduct |
22 | Serious Bodily Injury |
Victim of Violence
| Code | Victims |
|---|---|
| ST | Student(s) only |
| TC | Teacher(s) only |
| NT | Non-Teacher Staff only |
| OT | Other Person(s) only |
| AA | Student(s) & Teacher(s) |
| BB | Student(s) & Non-Teacher Staff |
| CC | Student(s) & Other Person(s) |
| DD | Teacher(s) & Non-Teacher Staff |
| EE | Teacher(s) & Other Person(s) |
| FF | Non-Teacher Staff & Other Person(s) |
| GG | Teacher(s) & Non-Teacher Staff & Other Person(s) |
| HH | Student(s) & Other Person(s) |
| KK | Student(s) & Teacher(s) & Non-Teacher Staff |
| JJ | Student(s) & Teacher(s) & Other Person(s) |
| LL | Student(s) & Teacher(s) & Non-Teacher Staff & Other Person(s) |
