Skip to main content
Skip table of contents

Get Student Online Learning Requirement

Function Name: PSSR_ON_Common.GetStudentOnlineLearningRequirement

Function Parameters

f_studentDCIDTbl - table of Students DCIDs,
f_studentDCID - if the list of students is not passed then at least a single studentDCID needs to be passed (default NULL)
f_isExcludeFromGPA - 1 if the flag needs to be checked on Storedgrades and Courses (default- 1)
f_startDate StartDate of the date range to calculate the credits earned during the period (default-NULL)
f_endDate EndDate of the date range to calculate the credits earned during the period (default-NULL)

Function Return Values

1. Cohort Year

The student's cohort year is derived as follows:

    1. Cohort year ([S_ON_STU_X]CohortYear)
    2. If cohort year is not defined, then Date Entered Grade 9 At Other Ontario Board ([S_ON_STU_X]Gr_Nine_Enroll_Date)
    3. If both are not defined, then Date Entered Grade 9 outside Ontario [S_ON_STU_X]gr_nine_enroll_dt_outsideON)

    4. If all 3 fields are not defined then the year of the earliest date from grade 9 enrolment is used

If the month of date used to calculate the cohort year falls between January and June, then the cohort year is for the previous year. For example, if the date is February 29, 2021, then the cohort year is 2020.

2. NAflag

This flag indicates if the online learning graduation requirement is not applicable for the student. Default 0

NAflag is 1 (True) for:

  1. Students who are not assigned to OSSD (1) or OSSD/SHSM(4) diploma.

  2. Students with Cohort earlier than 2020-21

    1. Cohort year ([S_ON_STU_X]CohortYear) earlier than 2020 and student not enrolled in the 2023-2024 school year or after, and are not working towards OSSD or OSSD/SHSM that is not yet achieved.

    2. If cohort year is not defined, then Date Entered Grade 9 At Other Ontario Board ([S_ON_STU_X]Gr_Nine_Enroll_Date) earlier than 2020

    3. If both are not defined, then Date Entered Grade 9 outside Ontario [S_ON_STU_X]gr_nine_enroll_dt_outsideON)

    4. If all three fields are not defined then the year of the earliest date from grade 9 enrolment is used

  3. Cohort year is required to proceed with the online Learning graduation requirement calculation, If the cohort year cannot be determined then the Student Met the Online Learning Graduation Requirement is examined; if it is ON, the student should show as met the requirement (NAflag set to Zero), and if it is OFF then no further processing is required and the process ends

3. OptedOutFlag

This flag indicates that the students opted out of the requirement. Default 0.

Flag is True for:

  • Students that are opted out of the requirement - students that have the Opted Out of Online Learning Graduation Requirement flag selected

  • If the student opted out of the requirement no further processing, the function ends.
  • If Exempt/Opted and Met the requirement flags are both selected for a student ( Done through Import) - the student is considered met the requirement. (Optout flag should be reset/returned as 0)

3.b. If Student Met the Online Learning Graduation Requirement flag is on, no further processing is ruled. EarnedTo Date return 2.0.

4. EarnedToDate

If the Student Met the Online Learning Graduation Requirement flag is on then return 2.0 otherwise this is the number of credits the student earned through online learning (Capped to 2) as of the report run date. Valid values 0 - 2. If the student earned more than 2 credits as of the system date) only 2 is returned. Default = NULL

Students can earn a fraction of the credit. For example, 0.25, 0.5, etc.

  • Check the store grades records where the Course is completed (the final mark is entered) and a credit is earned - earned_credit_hours greater than 0

  • Exclude from GPA is examined (Storegrades/Courses) both should not be selected

  • Exclude from Transcript is examined ( StoreGrades)

  • Only courses e-learning (storegrade/Section/course0) are considered

    • e-learning courses are courses where:

      • Historical Grades.OnSIS Credit Type is11 (E-Learning - not though provincial LMS) or 12 ( E-learning - though provincial LMS) or

      • Other Course info, if Online(4) is selected or

      • if not defined then

      • Sections

        • Delivery type is 18 (not E-learning - though provincial LMS) or 19 ( E-learning - though provincial LMS) or 

        • Other Course Info . Online (4) is selected 

        • Course Offering is 12 (E-Learning Course) if not defined then Courses > Course Offering is 12 (E-Learning Course)

  • And if student cohort is 20-21, one credit for any course earned between April 1, 2021 and June 30, 2021 regardless of type can be counted. For students with Cohort > 20-21 this is not an option, a credit must be e-learning to qualify for the requirement.

Zero is returned if the calculation is processed and the student did not earn any credits to date.

5. DateRequirementCompleted

if the Student Met the Online Learning Graduation set the date to  1/1/1900 , otherwise This is the earliest date the student earned 2 credits that are eligible for the requirement. Default is NULL

6. EarnedInDateRange

This is the online credit earned this reporting period to complete the 2 credits requirement. Default is Null

If DateRequirementCompleted is before the start date of the date range, then EarnedThisReport is Null otherwise Calculated as follows:

If EarnedToDate is less than 0 and date range is provided and DateRequirementCompleted is (NULL or on or after the start date of range)

PreviousOnlineCreditEarned is eligible/online credits earned before the start date

EarnedinRange is eligible/online credits earned with the completion date on or after the start date and on or before the end date

MaxCreditsRequiredThisPeriod is 2 - PreviousOnlineCreditEarned

EarnedInDateRange is MaxCreditsRequiredThisPeriod (if EarnedinRange = MaxCreditsRequiredThisPeriod), otherwise, the smaller value among both values

7. PreviousOnlineCreditEarned

Previously earned credits by Student when dateRange is provided (derived as described above). Default NULL

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.