Student SPED Graduation Requirement (FE) (Ohio Extracts)

Tool Search: OH Extracts

The Student SPED Graduation Requirement (FE) Extract collects basic assessment and graduation data for special education students.

Screenshot of the Ohio Student SPED Graduation Requirement (FE) Extract EditorOhio Student SPED Graduation Requirement (FE) Extract Editor

Reporting Population and Business Rules

Rule
Requirement
R1
Record Population

IF third party SPED integration is set up then:

    1. Make API call 
    2. Set parameters
      1. When calendar is selected, the fiscal year associated with the calendar and the building number should be passed through API.
      2. When reporting period is selected, the reporting period should be passed through API.
      3. When start and/or end dates are entered, start and end dates should be passed through API.
      4. When ad hoc filter is selected, the EMIS Student ID numbers should be passed in the filter though API.
    3. Extract data
    4. Each record returned would create one record in the report. 
    5. Records are matched with campus data on EMIS Student ID number 

IF third party SPED integration is NOT set up then follow existing/Infinite Campus documentation:

  • Look at all IEPs that fall within the reporting date range on the reporting editor (If IEP = Initial or Annual Review, use Meeting Date. If IEP = Transfer, use Transfer Date. If IEP = Amendment, use Start Date)
    • Find the plan with the earliest date within the school year of the calendar being reported
      • Report a record for any exemptions marked as Y based on the exemption logic specified in R4-R7 if the start date of the plan is within the reporting window dates from the report editor (If IEP = Initial or Annual Review, use Meeting Date. If IEP = Transfer, use Transfer Date. If IEP = Amendment, use Start Date)
      • Check to see if there is a plan any time before it
        • If not, no further records need to be reported for this plan
        • If there is a previous IEP, choose the most recent previous IEP (using the same dates used above) to compare to. If there are any exemptions that were marked in the previous IEP that are no longer marked in the IEP in the reporting range, report a record for each of those as N for the IEP
    • Check to see if there are plans after the earliest IEP in the reporting date range (using the same dates from above)
      • If not, no further records need to be reported
      • If there are subsequent IEPs, compare each to the previous IEP (based on the same dates from above) and report a record for each exemption that changes
R2
Report from most recent enrollment with Service Type = P or N.
R3

2018 and newer IEP formats

R4

2017 IEP formats

R5

2015-2017 IEP formats

R6
File Naming Convention:
StudentSPEDGraduationRequirement_Today'sDate.txt


If the district has configured a vertical reporting connection with SameGoal and Pull data from SPED product integration is marked on the extract editor, all fields 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. 

Enrollment data reports from the most recent enrollment with a Service Type of P or N.

Generating the Extract

  1. Select Student SPED Graduation Requirement (FE) as the Extract Type.
  2. Select the Reporting Period, which when the report is being submitted.
  3. Indicate if the extract should Pull data from SPED product integration if desired. See the SameGoal Integration article for more information.
  4. Enter a Date Range.
  5. 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.
  6. 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.
  7. Select an Ad Hoc Filter to determine what grade levels will appear in the report. Filters are created in the Filter Designer.
  8. Select which Calendar(s) should be included in the extract. Grade Levels with student enrolled in them in the selected calendar(s) are reported.
  9. 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.

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, all fields report from SameGoal rather than from documents created in Campus.

Data Element Label

Business Requirement and Business Rules

Data Source GUI Path

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 will be the end of the school year. The fiscal year is July 1-June 30.


Report End Year


YYYY, 4 characters

System Administration > Calendar > School Year > End Year


Not Dynamically Stored

Reporting Period Code

The reporting period in which the data is being pulled.


Report Reporting Period.


Alphanumeric, 1 character

OH State Reporting > OH Extracts > Reporting Period


Not Dynamically Stored

District IRN

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


Report State District Number. Pad with leading zero(s) if necessary.


  1. From the Primary enrollment active during the IEP and during the extract editor daterange that has the latest Start Date:
    1. When (System Admin > Resources > School > School Detail > District IRN Override) NOT = null, reports the value entered into the District IRN Override field.
  2. When District IRN Override = null, reports entry in (System Admin > Resources > District Information > District Info > State District Number).


Numeric, 6 digits

System Administration > Resources > District Information > State District Number


District.number

EMIS Student ID Number

The locally determined EMIS student ID.

Report Student Number. Pad with leading zero(s) if necessary.


Alphanumeric 9 characters

Census > People > Identity > Student Number


Person.studentNumber

IEP Date Type

Date type of the IEP, as reported on the special education(GE) record, on which the graduation assessment requirement was determined.


  1. If IEP = Initial IEP, report IIEP.
  2. If IEP = Annual Review, report RIEP.
  3. If IEP = Transfer, report TIEP.
  4. If IEP type = Amendment, report AIEP.

Alphanumeric, 4 characters

Student Information > Special Education > Documents > IEP


SEPlan.type


IEP Date

Date of the IEP, as reported on the special education (GE) record, on which the graduation assessment requirement was determined.


  1. If IEP = Initial or Annual Review, report Meeting Date.
  2. If IEP = Transfer, report Transfer Date.
  3. If IEP = Amendment, report Start Date CCYYMMDD

Date field, 8 digits, YYYYMMDD

Student Information > Special Education > Documents > IEP > Meeting Date, Transfer Date, Start Date


SEPlan.meetingDate

Assessment Type Code

The code used to indicate the type of graduation assessment for which the student has been granted a graduation exemption or is no longer exempt.


  1. If Assessment Area Code = R, W, M, C or S, report GX.
  2. If Assessment Area Code = HIST, PHYS, ELA1, ELA2, ALG1, GEOM, MTH1, MTH2, BIOL, or GOVM, report GE.

Alphanumeric, 2 characters

N/A

Assessment Area Code

A code of up to four characters that identifies the assessment area (subject) for which the student has been granted a graduation exemption or is no longer exempt.


OGT (GX)

  1. If Reading = selected checkbox or category, report 'R '.
  2. If Writing = selected checkbox or category, report 'W '.
  3. If Math = selected checkbox or category, report 'M '.
  4. If Social Studies = selected checkbox or category, report 'C '.
  5. If Science = selected checkbox or category, report 'S '.

Pad with right leading blank space.

EOC (GE)

  1. If HIST American/United States History = selected checkbox or category, report HIST.
  2. If PHYS Physical Science  = selected checkbox or category, report PHYS
  3. If ELA1 English Language Arts 1 = selected checkbox or category, report ELA1
  4. If ELA2 English Language Arts 2 = selected checkbox or category, report ELA2
  5. If ALG1 Algebra 1 = selected checkbox or category, report ALG1
  6. If GEOM Geometry = selected checkbox or category, report GEOM
  7. If MTH1 Mathematics 1 = selected checkbox or category, report MTH1
  8. If MTH2 Mathematics 2  = selected checkbox or category, report MTH2
  9. If BIOL Biology = selected checkbox or category, report BIOL
  10. If GOVM Government  = selected checkbox or category, report GOVM

Alphanumeric, 4 characters

Student Information > Special Education > Documents > IEP > Statewide and District Testing > Reading, Math, Writing, Science, Social Studies


Student Information > SPED > Docs > IEP > Exemptions


Calculated


Exemption Flag

Indicates the status of the graduation exemption for the reported Assessment Type/Area as determined by the student’s IEP team.


OGT (GX)

  1. If Reading = selected checkbox or category, report Y. Else report N.
  2. If Writing = selected checkbox or category, report Y. Else report N.
  3. Math = selected checkbox or category, report Y. Else report N.
  4. If Social Studies = selected checkbox or category, report Y. Else report N.
  5. If Science = selected checkbox or category, report Y. Else report N.

EOC (GE)

  1. If HIST American/United States History = selected checkbox or category, report Y. Else report N.
  2. If PHYS Physical Science  = selected checkbox or category, report Y. Else report N.
  3. If ELA1 English Language Arts 1 = selected checkbox or category, report Y. Else report N.
  4. If ELA2 English Language Arts 2 = selected checkbox or category, report Y. Else report N.
  5. If ALG1 Algebra 1 = selected checkbox or category, report Y. Else report N.
  6. If GEOM Geometry = selected checkbox or category, report Y. Else report N.
  7. If MTH1 Mathematics 1 = selected checkbox or category, report Y. Else report N.
  8. If MTH2 Mathematics 2  = selected checkbox or category, report Y. Else report N.
  9. If BIOL Biology = selected checkbox or category, report Y. Else report N.
  10. If GOVM Government  = selected checkbox or category, report Y. Else report N.


Alphanumeric, 1 character

Student Information > Special Education > Documents > IEP > Statewide and District Testing > Reading, Math, Writing, Science, Social Studies


Student Information > SPED > Documents > IEP > Exemptions