PATH: OH State Reporting > Ohio Extracts > Student SPED Graduation Requirement (FE)
The Student SPED Graduation Requirement (FE) Extract collects basic assessment and graduation data for special education students.
Image 1: Student SPED Graduation Requirement (FE) Extract Editor
Report Logic
Records report based on the dates and Type of the student's IEP.
- First, the logic looks at the IEP with the earliest Start Date within the school year. A record reports for any exemptions marked as Y based on existing exemption logic if the Start Date falls within the extract reporting window.
- Exemptions are when a student is marked as excused from any Assessment Area on the Statewide and District-wide Testing editor including Reading, Math, Writing, Science and Social Studies.
- For this record, if IEP is marked as Initial or Annual Review, reports the Meeting Date. If IEP is marked as Transfer, reports Transfer Date. If IEP is marked as Amendment, reports Start Date.
- Next, the logic looks for any plans prior to the reported plan. If the student has a previous IEP, the logic compares current exemptions with the most recent previous IEP (date considered is based on the type of the IEP, as described above). If there are any exemptions marked in the previous IEP that are not marked in the current one, a record reports as N for each exemption.
- Finally, the logic looks for any plans after the earliest IEP in the school year. If there are subsequent IEPs, exemptions are again compared and records report for any differences.
If the district has configured a vertical reporting connection with SameGoal, all fields report from SameGoal rather than from documents created in Campus.
Enrollment data reports from the most recent enrollment with a Service Type of P or N.
Generating the Extract
- Select Student SPED Graduation Requirement (FE) as the Extract Type.
- Select the Reporting Period, which when the report is being submitted.
- Enter a Date Range.
- Mark the checkbox to Report original docs of type Initial, Annual Review, Transfer. This checkbox causes only IEPs with a type of Initial, Annual Review or Transfer to report.
- Select the Format in which the report should generate. Use State Format (Fixed Width) for submission to the state or HTML, CSV or XML for data review and verification.
- Select an Ad Hoc Filter to determine what grade levels will appear in the report. Filters are created in the Filter Designer.
- Select which Calendar(s) should be included in the extract. Grade Levels with student enrolled in them in the selected calendar(s) are reported.
- 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 SPED Graduation Requirement 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.
Image 2: Student SPED Graduation Requirement (FE) - State Format (Fixed Width)
Image 3: Student SPED Graduation Requirement (FE) - HTML Format
Image 4: Student SPED Graduation Requirement (FE) - CSV Format
Image 5: Student SPED Graduation Requirement (FE) - XML Format
Extract Layout
If the district has configured a vertical reporting connection with SameGoal, all fields report from SameGoal rather than from documents created in Campus.
Element Name | Description & Format | Campus Location |
|---|---|---|
Filler1 | Reports as blank space. 8 characters |
|
Sort Type Code | Always reports as FE for Student SPED Graduation Requirement. Alphanumeric 2 characters | N/A |
Filler2 | Reports as blank space. 1 character |
|
Fiscal Year | The Fiscal Year determined by the end year of the reported school year (i.e., 2009 for the 2008-2009 school year). YYYY, 4 characters | System Administration > Calendar > School Year > End Year Not Dynamically Stored |
Reporting Period Code | The reporting period in which data is being pulled from. Alphanumeric, 1 character | OH State Reporting > OH Extracts > Reporting Period Not Dynamically Stored |
District IRN | The state-assigned information retrieval number (IRN) of the district. Numeric, 6 digits | System Administration > Resources > District Information > State District Number District.number |
EMIS Student ID Number | The locally determined EMIS student ID. Alphanumeric 9 characters | Census > People > Demographics > Person Identifiers > Student Number Person.studentNumber |
IEP Date Type | The Type of IEP being reported. If an IEP is amended, this field will report with the type of the original IEP. Options are:
Alphanumeric, 4 characters | Student Information > Special Ed > Documents > IEP > Education Plan > Transfer, Initial IEP, Annual Review SEPlan.type |
IEP Date | The Meeting Date of the IEP. If the IEP is a transfer IEP, reports the Transfer Date. If it is Amended, reports Start Date. Date field, 8 digits, YYYYMMDD | Student Information > Special Ed > Documents > IEP > Education Plan > Meeting Date SEPlan.meetingDate |
Assessment Type Code | Indicates the type of graduation assessment for which the student has been granted an exemption or is no longer exempt. Reports as GX. Alphanumeric, 2 characters | N/A |
Assessment Area Code | Indicates the assessment area for which the student has been granted an exemption or is no longer exempt. Options are:
Alphanumeric, 4 characters | Student Information > Special Ed > Documents > IEP > Statewide and District-wide Testing Calculated |
Exemption Flag | Indicates the status of the graduation exemption for the reported Assessment Type/Area. If any Assessment Area is marked, reports as Y. Otherwise, reports N. Alphanumeric, 1 character | Student Information > Special Ed > Documents > IEP > Statewide and District-wide Testing Calculated |
