SHSM All Requirements Met Date Calculations

Introduction

This new report calculates whether a Specialist High Skills Major (SHSM) program student has fulfilled all SHSM requirements. Once the student has met the requirements, the SHSM All Requirements Met Date can be populated automatically for the student.

This report is a school-level report and cannot be run from the District office. Schools must run the ‘OSSD Diploma Date Calculations’ after this report to complete the awarding of the OSSD/SHSM diploma for students.

Student Selection Criteria

• The Student is included in the subset of currently selected students (if applicable).

• The Exclude From Provincial Report flag ([Students]State_ExcludeFromReporting) for the student must be off.

• The student is enrolled in at least one SHSM program during the selected school year.

  • SHSM program start date is before the last day of the school year and the SHSM program end date is null, or

  • End date is after the program start date and on or before August 31st of the selected school year

SHSM Program Selection Criteria

For all selected students:

All Requirements Met date is calculated for the student’s SHSM Program that ran for at least a day within the selected school year. The All Requirements Met date is calculated only for students who have completed the program prior to the system date but still within the selected school year.

Student’s SHSM programs are processed if [S_ON_GEN_SPECPROG_X]SHSM_Flag is on and the start date of the program is before the Last Day of the selected school year and the exit date of the program is null or after the start date of the program and falls between the start date and August 31st of the selected school year.

All Requirements Met Date Calculation

When Calculate blank days only

• All student’s SHSM programs where All Requirements Met Date is not defined

When Calculate blank dates and recalculate existing dates (current year dates only)

• All student’s SHSM programs where All Met Date is not defined, or if defined is between the selected year’s start date and August 31st of the selected year. The date is calculated and replace only if the student still meets the requirement but on a different date.

When Calculate/Recalculate all dates (current year only)

• All student’s SHSM programs where All Requirements Met Date is not defined or if defined is between the start date and August 31st of the selected year. Calculate and replace the existing date. This process will clear the existing dates, if the student shows as not currently meeting the requirement.

Logic to calculate All Requirement Met Date

All dates must be on or before the effective date selected on the run pge to be considered in the calculations.

• Calculate the date on which the student completed the Experiential Learning Activity, Reach Ahead and the SHSM Component.

  • If the student did not complete any of the requirements on or before the effective date, the All Requirement Met date is set to blank for the student

  • Otherwise, get the latest date among the dates calculated

• Calculate the date on which the student completed Certification Requirements:

  • Only certifications completed on or before the effective date is considered. Duplicates and expired Certificates on or before the effective dte are not considered.

  • Process the Certification Types applicable to the SHSM program where the certification is required. If any of them do not have a Date completed then the Student is not meeting the SHSM requirements, no more processing is required, All requirements date is set to blank for the student.

  • Process all completed optional certificates if the student didn’t complete the number of optional certificates, no more processing is required, All requirements date is set to blank for the student.

    • If the students completed more optional certificates than required, the certificates are sorted by date completed Asc. and only the first x number of certificates are considered where x is the number of optional certificates required for the program.

  • Otherwise get the date of the latest certificate completed.

• Calculate the date on which the student completed Credit Requirements

  • Only Credits completed on or before the effective date are considered

  • Examine Exclude From GPA is considered when checking the credit requirements. If checked, only courses for which [Courses]ExcludeFromGPA is turned off are included.

  • The report determines if the student earned/completed the total number of credits required for the program. The SHSM Best Fit Logic outlined in Appendix H is used. If the student did not complete all the required credits, no more processing is required, All requirements date is set to blank for the student.

  • Otherwise, get the date of the latest credit completed.

•  All Requirement Met Date is set to the Latest date among all calculated dates.

Report Input

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

Report Output

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