PowerSchool SIS Ontario
PowerSchool SIS Ontario
Breadcrumbs

Get Student Online Learning Requirement

Function: PSSR_ON_Common.GetStudentOnlineLearningRequirement

This function determines whether a student is subject to the Ontario online learning graduation requirement and calculates the student’s eligible online learning credits.

Parameters

  • f_studentDCIDTbl — table of student DCIDs.

  • f_studentDCID — single student DCID. Required when f_studentDCIDTbl is not provided. Default: NULL.

  • f_isExcludeFromGPA — set to 1 to check the Exclude from GPA flags on Stored Grades and Courses. Default: 1.

  • f_startDate — start date of the reporting date range used to calculate credits earned during the period. Default: NULL.

  • f_endDate — end date of the reporting date range used to calculate credits earned during the period. Default: NULL.

Return values

1. CohortYear

The student’s cohort year is derived from the first available value in the following order:

  1. [S_ON_STU_X]CohortYear.

  2. Date Entered Grade 9 at Other Ontario Board: [S_ON_STU_X]Gr_Nine_Enroll_Date.

  3. Date Entered Grade 9 outside Ontario: [S_ON_STU_X]gr_nine_enroll_dt_outsideON.

  4. If none of the above is defined, the year of the earliest Grade 9 enrolment date.

If the date used to determine the cohort year falls between January and June, the cohort year is the previous calendar year. For example, a date of February 29, 2021 produces a cohort year of 2020.

2. NAflag

Indicates whether the online learning graduation requirement is not applicable to the student. Default: 0 (applicable). Adult learners entering the Ontario secondary school system in the 2023–2024 school year or later are also subject to the requirement unless they opt out.

NAflag = 1 (not applicable) student not working towards

    • OSSD (1)

    • OSSD/SHSM (4)

    • OSSD/OYAP-FAST (5)

    • OSSD/SHSM/OYAP-FAST (6)

  • The student’s cohort year is earlier than 2020.

NAflag = 0 (applicable)

  • The student is a newcomer and/or out-of-province student whose first school enrolment is in the 2023–2024 school year or later, and Date Entered Grade 9 at Other Ontario Board is blank or on/after July 1, 2023.

  • The student’s cohort year is 2020 or later.

  • Students with a cohort year earlier than 2020 who are enrolled in the 2023–2024 school year or later are now required to earn at least two online courses to graduate, unless they opt out.

  • The Student Met the Online Learning Graduation Requirement flag is selected. In this case, the student is treated as having met the requirement.

If the cohort year cannot be determined, the function checks the Student Met the Online Learning Graduation Requirement flag. If the flag is selected, NAflag is returned as 0. If the flag is not selected, no further processing is required and the function ends.

3. OptedOutFlag

Indicates whether the student opted out of the online learning graduation requirement. Default: 0.

  • OptedOutFlag = 1 when the Opted Out of Online Learning Graduation Requirement flag is selected.

  • If the student opted out, no further processing is performed.

  • If both the opted-out/exempt flag and the Student Met the Online Learning Graduation Requirement flag are selected, the student is considered to have met the requirement and OptedOutFlag is returned as 0.

4. EarnedToDate

Returns the number of eligible online learning credits earned by the student as of the report run date, capped at 2.0. Default: NULL.

  • If the Student Met the Online Learning Graduation Requirement flag is selected, return 2.0.

  • If the calculation is processed and the student has not earned eligible credits, return 0.

  • Fractional credits are supported, such as 0.25 or 0.5.

Eligible credits are determined from Stored Grades where:

  • The course is completed and a final mark is entered.

  • earned_credit_hours is greater than 0.

  • Exclude from GPA is not selected on Stored Grades or Courses, when that check is enabled.

  • Exclude from Transcript is not selected on Stored Grades.

  • The course qualifies as online learning.

A course qualifies as online learning when one of the following applies:

  • Historical Grades OnSIS Credit Type is 11 (online learning — not through provincial LMS) or 12 (online learning — through provincial LMS).

  • Other Course Info has Online (4) selected.

    • Delivery Type 18 or 19 as applicable for online learning through the provincial LMS.

    • Other Course Info Online (4) selected.

    • Course Offering 12 (online learning course), or if not defined on the section, Course Offering 12 on the course.

For students in the 2020–2021 cohort, one credit earned between April 1, 2021 and June 30, 2021 can count regardless of course type. For cohorts after 2020–2021, the credit must be from an eligible online learning course.

5. DateRequirementCompleted

Returns the earliest date on which the student earned 2 eligible credits. Default: NULL.

  • If the Student Met the Online Learning Graduation Requirement flag is selected, return January 1, 1900.

  • Otherwise, return the date the student first reaches 2 eligible credits.

6. EarnedInDateRange

Returns the eligible online learning credits earned during the supplied date range that count toward completing the 2-credit requirement. Default: NULL.

  • If DateRequirementCompleted is before f_startDate, return NULL.

  • If the date range is provided and DateRequirementCompleted is NULL or on/after f_startDate, calculate the value using the following fields:

  • PreviousOnlineCreditEarned — eligible online credits earned before f_startDate.

  • EarnedInRange — eligible online credits earned with a completion date on/after f_startDate and on/before f_endDate.

  • MaxCreditsRequiredThisPeriod — 2 - PreviousOnlineCreditEarned.

  • EarnedInDateRange — the smaller of EarnedInRange and MaxCreditsRequiredThisPeriod.

7. PreviousOnlineCreditEarned

Returns eligible online credits earned before the reporting date range start date, when a date range is provided. Default: NULL.