Tool Search: OH Extracts
The Student Reported in Error (FX) Extract is reported for a student who has previously been reported in error for the current school year.
Ohio Student Reported in Error (FX) Extract EditorReporting Population and Business Rules
| Rule Number | Business Requirement |
|---|---|
| R1 | Reports an FX record for the student's enrollment when the following are true:
|
| R2 | Student must have a Student State ID
|
| R3 | The report can be run against a district’s active year as well as any prior year. |
| R4 | The report can be run in District Editions. |
| R5 | The report is generated in XML and CSV formats as well as a human-readable format (HTML). XML format is the State Format. |
| R6 | CSV and Fixed Width Filename: StudentReportedinErrorFX |
Extract Editor Fields
Field | Description |
|---|---|
Extract Type | Select Student Reported in Error (FX) from the dropdown. |
Reporting Period | Indicates when the report is being submitted.
|
Date Range | The first and last day on which data is reported. |
Format | The format in which the report will generate. Options are:
|
Ad hoc Filter | When selected, filters report results as defined be a premade Ad hoc filter. |
Calendar Selector | Defaults to the Calendar selected in the Campus Toolbar. At least one calendar is required to report. |
| Generate Extract | Click the Generate Extract button to trigger the creation of the extract. |
| Submit Batch to Queue | Click the Submit to Batch Queue button to send the extract to the Batch Queue. |
Generate the Extract
- Select the Student Reported in Error (FX) Extract Type.
- Select the Reporting Period.
- Enter a Date Range in mmddyyyy format or by clicking the calendar icon and selecting a date.
- Select the Format in which the report should generate.
- Select an Ad hoc Filter to specify student results.
- Select the Calendar(s) that should be included in the report.
- 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, requests can only be submitted to the Batch Queue.
Users have the option of submitting a Student Reported in Error report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows 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 |
|---|---|---|
Filler1 | Reports null. | N/A |
Sort Type | Always reports FX. Alphanumeric, 2 characters | N/A, reports as FX |
Filler2 | Reports null | N/A |
FiscalYear | Reports the End Year of the calendar(s) selected on the extract editor. (e.g., 2020 (CCYY)) Numeric, CCYY | Calendar > Year |
Data Set | Reports the code selected in the Reporting Period field on the extract editor.
| Extract Editor selection |
District IRN | The state-assigned information retrieval number (IRN) of the district.
Numeric | School Information > School Detail > District IRN Override OR District Information > State District Number district.number |
State Student ID | The student's state ID number. Numeric, including left-leading padding zeroes to equal 9 digits | Demographics > Person Identifiers > State ID Identities.stateID |
