OSSD Diploma Date Calculations

Introduction

This report calculates the date on which a student meets all diploma requirements and stores that date in the existing [S_ON_STU_X]Diploma_Date field for the student. This report can only be run from a school. An output file is generated that lists only the students whose OSSD date is calculated or changed from the existing date.

OSSD Date Calculation

The diploma date calculation is performed for students for which [S_ON_STU_X]Diploma_Type is '1' (OSSD) or '4' (OSSD/SHSM). Students whose graduation school is set to Outside of Board are excluded. The [S_ON_STU_X]Diploma_Date is set to the latest of the dates below. If any of the dates are undefined, the student is deemed not to have met all diploma requirements, also the student must either meet or opted out of the online learning requirement or the requirement does not apply to the student for the diploma date to be calculated.

The diploma date is not calculated/re-calculated for students if Graduation School is set to Outside of Board.

The report determines the following for each student:

• The date on which the student accumulated 18 or more compulsory credits - The report uses the ON_Student_GradPlan.getclasscreditxrefOSS function, which returns the course number, category, earned credits, and completion date. Compulsory courses (courses with a category other than 99 [optional]) are ordered by the completion date; the completion date associated with the 18th credit is the date the requirement is met.

• The date on which the student accumulated 12 or more optional credits - The report uses the ON_Student_GradPlan.getclasscreditxrefOSS function, which returns the course number, category, earned credits, and completion date. Courses with a category of 99 (optional) are ordered by completion date and the completion date associated with the 12th credit is the date the requirement is met.

• The date on which the student met the literacy requirement - The report uses the pssr_on_common.literacyRequirement_Met_Date function which, using the rules described in Appendix F - Literacy Requirement, determines whether a student has met the literacy requirement and if so, returns the date (based on OSSLT test date). Please note: Students do not need to meet the Literacy requirement if graduating between March 13, 2020, and Sept 04, 2022.

• The date on which the student completed the community hours requirement - The report uses the pssr_on_common.get_completion_date_comm_hours which returns the date associated with the ON_Community_Hours record containing the 40th hour of community service or the date associated with the latest ON_Community_Hours record, for students eligible for 20+ hours (students graduating 20-21 school year and after). Please Note: students graduating are exempt from community service (students graduated between March 13, 2020, and the start of school year 20-21)

• Diploma Type 4 Only - All Requirements Met is included in the calculations and if the student completed one or more SHSM programs, the earliest date on which the student completed the SHSM program is used.

• Determine if the student met the Online Learning Graduation Requirement - The report uses the pssr_on_commom.getStudentOnlineLearningRequirement to determine whether the requirement is not applicable to the student or the student opted out or met the requirement.

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

Field	Description
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.
Select School	Choose the school for which to run the submission report.
OSSD Date Calculation	Choose one of the following options: Calculate blank dates only - Only the empty [S_ON_STU_X]Diploma_Date is updated Calculate blank dates and recalculate existing dates (current year dates only) - Updates the empty [S_ON_STU_X]Diploma_Date, and non-blank [Students]ON_Diploma_Date values are recalculated and updated as appropriate (current year dates only) Calculate/recalculate all dates (current year dates only) - The two above calculations are made, plus non-blank [S_ON_STU_X]Diploma_Date values are removed for students who no longer meet the requirements (current year dates only) Current year is based on the report run date. When the report run date falls between years, the earlier year is used.

Report Output

Each of the fields in the report output is described below. See Understanding the Report Output Table for a definition of each column in the table.