(GC) Student Graduation Core Detail Extract | PowerSchool SIS Compliance

Introduction

The (GC) Student Graduation Core Detail Extract is intended as a tool to assist districts with verifying credit earned toward graduation. The extract produces a CSV file with each earned credit displayed on a single line. Users can manipulate the extract to find students who are short credits for graduation and to find historical grades that do not have the proper Core Area entered. This file is not for reporting to the state. Users will continue to report the (GC) Student Graduation Core record to the state.

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]S_OH_STU_FN_X.Diploma_Date, or [Students]S_OH_STU_FN_SNAP_C.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 is not excluded from state reporting.

For the (S) 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 is not excluded from state reporting.

Required Data Setup

Use the following information to verify the required data setup for Core Area Credits before running the extract.

Core Area Credits

Core Area Credits will be included under the following circumstances:

The student has earned credit in a course with a valid CORE Area code ([Courses.S_OH_CRS_Courses_X]CORE_Area_Code).
The student has earned high school credit that is not associated with a course, but those historical grade records have a valid CORE Area code. CORE Area codes can be entered/imported into historical grades without an associated class by importing the relevant code into the correct field ([StoredGrades]GPA_Custom1).
The student has earned high school credit that is not associated with a course and the CORE Area code is blank. These records will appear in the extract with ERR listed in the Core Area code column. These records should be reviewed, and the proper CORE Area Code entered on the record in historical grades.

Note: These records will be ignored in the (GC) Student Graduation Core record.

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

The report input is done in Data and Reporting > Reports > Compliance Reports - (GC) Student Graduation Core Detail Record - Report Parameters.

Field	Description
Schools for which to run?*	If you run the report from the district level, choose one of the following: Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. All Schools – Run the report for the entire district. 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: The Selected [number] Students Only – Run the report for students in the current selection. All Students – Run the report for all students in the current school or district that meet the selection criteria. 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.

Report Output

Each of the fields displayed in the output of the report is described below. The report is output as a .csv file. 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 District Course Information page. District Management > Courses and Programs > Courses > Edit Course 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. If a course number is entered, the value pulls from the course. If there is no course number, it pulls from the historical grade entry.	[S_OH_CRS_COURSES_X]Dual_Credit or S_OH_SGR_STOREDGRADES_X.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