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); or '5’ (OSSD/OYAP-FAST), or '6’ (OSSD/SHSM/OYAP-FAST). 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 - If the [S_ON_STU_X].COMM_HRS_WAIVED_FLAG is not selected or if the flag is selected, and adjusted hours is more than 0, 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 who graduated between March 13, 2020, and the start of school year 20-21) or the date associated with the ON_Community_Hours record, the students reached for adjusted hours.

  • Otherwise, the report considers this requirement as waived/completed (sets the date to 01/01/1900) and continues with the OSSD Diploma date calculation.

• Diploma Type 4 and 6 Only - SHSM 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 Diploma 5 and 6 only: OYAP-FAST earliest All Requirements Met Date (S_ON_SEN_X.OYAPFAST_MET_DATE) is used, and the student must be “Registered as an Apprentice”.

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

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.