Tool Search: OH Extracts
The Ohio Student Program (GQ) extract reports all programs/services a student is participating in and/or receiving during the corresponding Reporting Period and Date Range. The extract includes programs for students with an active enrollment record during the selected calendar and a null program End Date and/or a program Start Date within the Date Range entered on the extract editor. Programs with an end date within the Date Range entered on the extract editor will report.
There is no limit to the amount of programs in which a student can participate. If a student withdraws from a program during the school year, the program code for the student will still report.
Reporting Population and Business Rules
The following report logic is true for each Program type. For all program types, data reports from the most recent Enrollment with a Service Type of P or N.
RequirementSpo
# | Requirement |
---|---|
R1 | Reports ONLY one record per UNIQUE reportable program code per student. |
R2 | Student MUST be enrolled on at least one date, in at least one calendar - on/between the Date Range selected on the Extract Editor to report. |
R2.BR1 | To report, enrollment must not be flagged State Exclude or No Show; student's Mapped State Grade Level must not be State Excluded, and the Calendar of enrollment must not be State Excluded i.e. Students flagged as No Show or State Excluded on all active Calendars/Enrollments and/or Grade Levels - do not report. |
R3 | Program (code) of record MUST be active on at least one date on/between the Date Range selected on the Extract Editor to report. |
R3.BR1 | If the student is in the program and then withdraws from the district during the year, the program code for the student still reports. |
R3.BR2 | Duplicate codes MUST not report. |
R3.BR2.A | If the student has multiple enrollments during the school year (assumes Service Type meets program of record requirements), Report field data from most recent. Should multiple be active, report from enrollment with most recent start date,
|
R3.BR2.B | Post Processing to remove duplicates:
|
Requirements by Program Area | |
R4 | Student Information > State Programs > Extended School Year (ESY) |
R4.BR1 | Report all active and inactive programs found within the Date Range entered on the extract editor. i.e. Programs with no End Date or an End Date within the Date Range MUST report. |
R4.BR2 | At least one reportable calendar enrollment for this student must have Service Type = P or N to report. |
R5 | Student Information > General > Programs |
R5.BR1 | Report all active and inactive programs found within the Date Range entered on the extract editor. ![]() i.e. Programs with no End Date or an End Date within the Date Range MUST report. |
R5.BR2 | At least one reportable calendar enrollment for this student must have Service Type = P or N to report. |
R5.BR3 | Student Information > Program Administration > Program Setup To report, a Code MUST be entered AND State Reported MUST be selected. ![]() |
R6 | Student Information > General > Flags |
R6.BR1 | Report all active and inactive flags found within the Date Range entered on the extract editor. ![]() i.e. Flags with no End Date or an End Date within the Date Range MUST report. |
R6.BR2 | At least one reportable calendar enrollment for this student must have Service Type = P or N to report. |
R6.BR3 | Student Information > Program Administration > Program Setup To report, a Code MUST be entered AND State Reported MUST be selected. ![]() |
R7 | Student Information > English Learners > English Learners (EL) Services |
R7.BR1 | Report all active and inactive EL Services not flagged Parent Refused found within the Date Range entered on the extract editor. ![]() i.e. EL Services with no End Date or an End Date within the Date Range MUST report. |
R7.BR2 | At least one reportable calendar enrollment for this student must have Service Type = P or N to report. |
R7.BR3 | To report, the service must NOT be flagged Parent Refused |
R7.BR4 | To report, Service Type MUST = 235014, 235015, 235017, 235019, 235021, 235099, 235023, or 235025 |
R7.BR5 | Student Information > Program Administration > English Learners (EL) Service Type Setup ![]() |
R8 | Student Information > PLP > PLP Documents: Services |
R8.BR1 | Report all active and inactive PLP Services found within the Date Range entered on the extract editor.
![]() |
R8.BR2 | At least one reportable calendar enrollment for this student must have Service Type = P or N to report. |
R8.BR3 | Student Information > PLP Administration > PLP Services Setup ![]() All of the following MUST be true:
|
R9 | Scheduling & Courses > Courses > Course Information: State Defined > Program Code |
R9.BR1 | Report all students rostered in courses within the Date Range of the extract editor that have a Program Code = NOT NULL. |
R9.BR2 | The student's Roster must be active on at least one date in the reporting range to report |
R9.BR3 | If the student is Rostered in multiple courses where Program Code is the same value - only one record may report. |
R9.BR4 | At least one reportable calendar enrollment for this student may have a Service Type = P, N or S. |
R9.BR5 | Exclude from State Reporting on the Course Editor must NOT be checked |
R10 | Student Information > General > Graduation: State Seal Information |
R10.BR1 | At least one reportable calendar enrollment for this student must have Service Type = P or N to report |
R10.BR2 | A record MUST NOT report if Status = NC (Not Completed) or BLANK |
R10.BR3 | A record reports for Status = IP (In Progress) - the Student Plans to Earn Value Code |
R10.BR4 | A record reports for Status = C (Completed) - the Seal Earned Code |
R10.BR5 | A valid State Seal must be selected to report. |
R11 | Student Information > Academic Planning > Programs: State Seal Information |
R11.BR1 | At least one reportable calendar enrollment for this student must have Service Type = P or N to report |
R11.BR2 | Student has an Academic program that is active on at least one date in the reporting range: ![]() |
R11.BR3 | Student Information > Program Administration > Academic Program Setup: State Seal Information ![]()
|
Special Ed Services | |
R12A | Special Ed Services with Pull data from SPED product integration = NOT CHECKED |
R12A.BR1 | Reports one record per reportable Related Service per student AND reports one record per student when "Does the child require special transportation" = Yes |
R12A.BR2 | Student Information > Special Ed > Special Ed Documents: Special Ed Services
|
R12A.BR3 | Student Information > Special Ed Administration > Special Ed Services Setup |
R12.B3.a | Service must be mapped to a State Code
|
R12A.BR4 |
|
R12A.BR5 | FLAGS SPED Service Codes: 211001 (Alternative Placement) & 220100 (Preschool Special Education Itinerant Services) may report via Programs (R5) or FLAGS (R6) with a code of 211001 or 220100 respectively. |
R12B | Special Ed Services with Pull data from SPED product integration = CHECKED |
R12B.BR1 |
If third party SPED integration is NOT set up then follows 12A requirements above |
If the district has configured a vertical reporting connection with SameGoal and Pull data from SPED product integration is marked on the extract editor, data for Special Ed programs report from SameGoal rather than from documents created in Campus.
When generating a report, applicable data is reported from a single source: either Campus-managed special education documents or from SameGoal. Data cannot be reported from both sources in a single report. Best practice is to manage special education documents either all in Campus or all in SameGoal.
See the SameGoal FAQ article for answers to commonly-asked questions about SameGoal connections.
The Employee ID field is required for students reported with the following:
• 305003 Career Assessment program code
• 206xxx series of Gifted program codes
• 220100 Preschool Itinerant Services
In addition, if a district contracts with an EMIS reporting entity, such as an ESC, to provide any services or programs to students, the IRN of the entity providing the service should be reported in then Program Provider IRN element.
Report Editor
The following table describes the options available in the extract editor.
Editor Field | Description |
---|---|
Extract Type | The type of extract being generated. In this case, select Student Program (GQ). |
Reporting Period | Indicates when the report is being submitted. Options are:
|
Pull data from SPED product integration | If SPED third-party integration is set up, mark this option. SPED data is pulled through API, not Infinite Campus. If incorrect data is extracted, districts must work with their third-party system to correct the data. |
Date Range | Use the Date Range fields to determine the student enrollments to include in the report based on the Start and End Dates of enrollments within the selected calendar(s). |
Staff ID | This option allows users to determine the Staff ID number to include in the report: Local Staff Number (Default) or Staff State ID. The extract defaults to reporting the Local Staff Number. |
Format | The Format option allows users to determine the format in which the report generates. Options are State Format (Fixed width), HTML, and CSV. Use HTML and CSV formats for data review and verification. Use State Format for submission to the State. |
Ad hoc Filter | Select a previously created Ad hoc Filter to limit which students appear in the report. Filters are created in the Filter Designer. |
Calendar(s) | Students enrolled in the selected calendar(s) will appear in the report. |
Generating the Extract
- Select the Student Program (GQ) Extract Type.
- Select the Reporting Period.
- Indicate if the extract should Pull data from SPED product integration if desired. See the SameGoal Integration article for more information.
- Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date.
- Use the State ID drop-list to select the Staff Number to report: Local Staff Number (Default) or Staff State ID. The extract defaults to Local Staff Number.
- Select the extract Format. For submission to the state, select the State Format (Fixed width) option. To review data prior to submitting to the state, select any of the other available options.
- Select which calendar(s) to include within the extract.
- Select an Ad hoc Filter, if applicable.
- 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 a Student Program 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
If the district has configured a vertical reporting connection with SameGoal and Pull data from SPED product integration is marked on the extract editor, data for Special Ed programs report from SameGoal rather than from documents created in Campus.
Element Name | Description | Campus Interface |
---|---|---|
Filler1 | Report blank space | |
Filler2 | Report blank space | |
Sort Type | This field will always report a value of GQ for the Student Program (GQ) Extract. | N/A Not Dynamically Stored |
Filler3 | Report blank space | |
Fiscal Year | The Fiscal Year determined by the end year of the current school year (i.e., 2025 for the 2024-2025 school year). | System Administration > Calendar > School Year > End Year |
Reporting Period | The reporting period in which data is being pulled. | OH State Reporting > OH Extracts > Reporting Period Not Dynamically Stored |
Building IRN | The building of instruction’s state assigned six-digit information retrieval number (IRN). | Student Information > General > Enrollments > State Reporting Fields > Building IRN Override OR System Administration > Resources > School > School Detail > State School Number Enrollment.buildingIRNOverride; |
EMIS Student ID Number | Report Student Number. Pad with leading zero(s) when necessary. SAMEGOAL SPED integration passes student number so the temp table must allow 15 digits for studentID | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
Program Code | The student’s assigned Program Code. Programs Tab Flags Tab PLP Services EL Services Course Rosters State Seal Information
Special Ed - Related Services Pad with left leading zero(s) if necessary
| Student Information > General > Flags Student Information > Program Participation > English Learners (EL) > EL Services > State Service Type Course > Program Code Student Information > General > Graduation > State Seal Course.programCode |
Employee ID | The Program Staff member.
---
| Census > People > Identity > Local Staff Number Census > People > Identity > Staff State ID Person.staffNumber |
Filler4 | Report blank spaces |
|
Program Provider IRN | The district IRN of the of the entity in contract with the reporting school district. Programs Tab Report Location. If NULL, report ******. Flags Tab Report Location. If NULL, report ******. Course Tab Report Program Provider IRN. If NULL, report ******. Alphanumeric 6 characters | Student Information > General > Programs > Program Participation Detail > Location OR System Administration > Resources > District Information > State District Number OR Scheduling > Courses > Course > Program Provider IRN ProgramParticipation.location |
Program Enrollment Start Date | Reporting student’s program enrollment start date not required (default) Reports 00000000 (ALL RECORDS) | Student Information > General > Flags > Start Date ProgramParticipation.startDate |
Program Enrollment End Date | Last day a student is enrolled in a program where dates are required. Reports 00000000 (ALL RECORDS) | Student Information > General > Flags > End Date ProgramParticipation.endDate |
Filler5 | 226 characters |