(GC) Student Graduation Core Detail Extract
On this page:
Introduction
The (GC) Student Graduation Core Detail Extract provides the CORE area and credits/earned by students towards graduation in alignment with the CORE graduation requirements.
You can create this extract for the Graduate (G) reporting period or the Current Graduation Credit Progress Collection (S) reporting period. The Current Graduation Credit Progress Collection extract includes all students who have earned credits in a course identified as a CORE course. You must run this report at the district level to get all credits earned.
Selection Criteria
Selection criteria determine which database records are used in the report. For the (GC) Student Graduation Core Detail Extract, student enrollment records are selected.
School Selection
The report selects which school records to use based on the following criteria:
- The school must be associated with a student included in the report.
Student Selection
The report selects which student records to use based on the following criteria:
- For the (G) Reporting Period:
- The student is enrolled at any time between the report start and end dates.
- The student has a diploma date [Students]OH_Diploma_Date that falls within the start and end dates.
- The student has earned credit in a course identified as a CORE course.
- The student has earned credit in a course but does not have a CORE Area code listed.
- The student is not excluded from state reporting (State/Province-OH>Home Tab> State_ExcludeEnrollment).
- For the (R) Reporting Period:
- The student is enrolled at any time between the report start and end dates.
- The student has earned credit in a course identified as a CORE course.
- The student has earned credit in a course but does not have a CORE Area code listed.
- The student is not excluded from state reporting (State/Province-OH>Home Tab> State_ExcludeEnrollment).
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
The report input is done in Incident Management with the codes and subcodes used in IM.
Field | Description | ||
Schools for which to run?* | If you run the report from the district level, choose one of the following:
If you run the report from the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. | ||
Report Start Date | Enter the start date for the reporting period. Format: [M]M/[D]D/[YY]YY | ||
Report End Date | Enter the end date for the reporting period. Format: [M]M/[D]D/[YY]YY | ||
Current Selection Students* | Indicate which students to include in the report by selecting one of the following options:
If running the report for a single student, or group of students, select the students prior to running the report. | ||
Reporting Period | Select the reporting period for which you are creating the extract, G (Graduate) or S (Student) | ||
Fiscal Year | Enter the fiscal year for the report. | ||
Scheduling | |||
Run Now | Select this option to execute the report in the order it is received in the report queue. | ||
Schedule (available Version 7.1.1.) | Enter the start date and start time for the report.
|
Report Output
Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName | Field Type |
1 | Current School IRN | The IRN of the school in which the student is associated. | SchoolID | Numeric |
2 | Student Number | The student's number | [Students]Student_Number | Alpha-numeric |
3 | SSID | The student's state student number (SSID). | [Students]StateStudent_Number | Alpha-numeric |
4 | Last Name | The student's last name. | [Students]Last_Name | Alpha-numeric |
5 | First Name | The student's first name. | [Students]First_Name | Alpha-numeric |
6 | Grade Level | The student's current grade level. | [Students]Grade_Level | Alpha-numeric |
7 | Core Area Code | The three-letter Core Area Code associated with the course. In cases where the field is blank, the extract displays ERR. This field contains the CORE area code assigned to the CORE courses for which this student earned credit during the reporting period. This field value is extracted from the CORE Area Code field on the Edit Course District Information page, District Setup > Courses > Edit Course District Information. In cases where courses are entered directly into Historical grades, the Core Area Code is extracted from GPA_Custom1. In cases where the Core_Credit_Override has a value, is extracted as the Core Area Code. | [S_OH_CRS_COURSES_X]Core_Area_Code or [StoredGrades]GPA_Custom1 or [Storedgrades]Core_Credit_Override | Alpha-numeric |
8 | Course Number | The course number associated with the credit earned. | [Courses]Course_Number [StoredGrades]Course_Number | Alpha-numeric |
9 | Course Name | The course name associated with the credit earned. | [Courses]Course_Name [StoredGrades]Course_Name | Alpha-numeric |
10 | Core Area Count | The amount of credits earned. | [StoredGrades]EarnedCrHrs | 4 with 2 decimal places |
11 | Dual Enrollment Credit | The amount of dual credit earned if any. | Calculated based on storedgrade dual credit value and dual credit override | 4 with 2 decimal places |
12 | Year Credit Earned | The fiscal year in which the credit was earned. | Calculated based on TermID | Numeric CCYY |