Tool Search: OH Extracts
The Student Graduation - CORE Summary (GC) extract reports the subject area and credits/units earned by students towards graduation in alignment with CORE graduation requirements. A separate record is reported for each student for each CORE Area in which the student has received any amount of credit/units toward graduation. This record should only be reported by the district granting the graduation diploma. Students reported on the Graduation-Only Test Record (GP) extract during the Graduate reporting period should not produce a record on the Student Graduation - CORE Summary (GC) extract for this period.
Ohio Student Graduation Record (GC)
Report Logic
The following describes logic used to generate a record
G - Graduate Reporting Period
- A record reports per CORE Area for Credit per student if the student has a Diploma Date that is not null and transcript Credit Earned is greater than 0 in a course’s CORE Area for Credit.
A record will not report for any CORE Area for Credit set to ***: Not Applicable.
Students scheduled into multiple courses with the same CORE Area will report one record aggregating the credits in the CORE Area.
Diploma Date is not required for any other reporting periods.
Data Range Logic:
If the Date Range on the extract editor is left null:
- A record will report if the student has an active enrollment record with a Start Date from July 1st through June 30th of the selected calendar year.
- A record will report if the student has an inactive enrollment record with a Start and End Date from July 1st through June 30th of the selected calendar year.
- A record will report if the student has an inactive enrollment record with an End Date from July 1st through June 30th of the selected calendar year.
If the Date Range is entered by the user:
- A record will report if the student has an active or inactive enrollment record during the Date Range entered.
Preliminary Requirements:
- When the reporting period is NOT G-Graduate:
- Report a record per CORE Area For Credit per student if the student has a transcript Credit Earned greater than 0 in a course's CORE Area For Credit.
- A diploma date is NOT required.
- A student can be waived from new CORE Area requirements with proper parental permission. The student is then evaluated based upon previously defined requirements.
Generating the Extract
- Select the Student Graduation - CORE Summary (GC) Extract Type.
- Select the appropriate Reporting Period.
- Enter the Date Range in mmddyy format or by clicking the calendar icon and selecting a date.
- Select the extract 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.
- Do not select an Ad hoc Filter. Although this field appears available, Ad hoc functionality has not yet been implemented for the Student Graduation - CORE Summary (GC) extract.
- 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 Graduation - CORE Summary 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 | N/A |
Filler | 1 character | N/A |
Sort Type | Always reports a value of GC for the Student Graduation - CORE Summary (GC). Alphanumeric 2 characters | Not Dynamically Stored |
Filler | 1 character | N/A |
Fiscal Year | The Fiscal Year determined by the end year of the current school year (i.e., 2009 for the 2008-2009 school year). Alphanumeric, 4 characters | System Administration > Calendar > School Year > End Year Not Dynamically Stored |
Reporting Period | The reporting period from which the data is being pulled. Alphanumeric, 1 character | Determined by the school year chosen Not Dynamically Stored |
District IRN | The district’s state assigned six-digit information retrieval number (IRN).
Alphanumeric, 1 character | 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 |
CORE Area Code | The subject area and/or CORE requirement area in which the student has earned credit towards graduation. Alphanumeric, 3 characters | Scheduling > Courses > Course > CORE Area For Credit Course.transcriptField1 |
CORE Area Count | The total number of credits earned in an area designated by the CORE Area Code reported above. Alphanumeric, 4 characters | Student Information > General > Transcript > Transcript Credit > Earned TranscriptCredit.creditsEarned |
| Credits for Courses in Progress | Numeric, 4 digits | N/A |
| Credit Amount for Projected Courses | Numeric, 4 digits | N/A |
| Total Number of Credits Deficient for Graduation | Numeric, 4 digits | N/A |
| Dual Enrollment Credit Earned | The total number of dual enrollment credits earned in the area designated by the CORE Area Code. Reports the sum of all Dual Credit Earned fields across all transcript records for the CORE Area of Credit being reported. Value reported with an assumed decimal (25.45 reports as 2545). Numeric, 4 digits | Student Information > General > Transcript > Dual Credit Earned TranscriptCourse.transcriptField2 |
Filler | 300 characters | N/A |
