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:
Cohort year ([S_ON_STU_X]CohortYear)
If cohort year is not defined, then Date Entered Grade 9 At Other Ontario Board ([S_ON_STU_X]Gr_Nine_Enroll_Date)
If both are not defined, then Date Entered Grade 9 outside Ontario [S_ON_STU_X]gr_nine_enroll_dt_outsideON)
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 (applicable)
NAflag is 1 (True):
Students who are not assigned to OSSD (1) or OSSD/SHSM(4) diploma
NA flag is 0 (False)
if student is newcomer and/or out of province in 2023-2024 or later
First school enrolment is in 2023-2024 school year or after (any enrolment regardless of school or grade)
AND Date Entered Grade 9 at other ON board is blank (NULL) OR date is on or after July1st, 2023
If student cohort was in 2020 or later
When NA flag is 0, processing continues to calculate the online graduation requirement
NAflag is 1 (True):
Students with Cohort earlier than 2020
Cohort year ([S_ON_STU_X]CohortYear):
If cohort year is not defined, then Date Entered Grade 9 At Other Ontario Board ([S_ON_STU_X]Gr_Nine_Enroll_Date)
If both are not defined, then Date Entered Grade 9 outside Ontario [S_ON_STU_X]gr_nine_enroll_dt_outsideON)
If all three fields are not defined then the year of the earliest date from grade 9 enrolment is earlier than 2020
Otherwise, If cohort year cannot be determined
If the student did not enter ON boards for the first time in the 2023-2024 or after, and 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.
Students with Cohort earlier than <2020
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.
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
If both are not defined, then Date Entered Grade 9 outside Ontario [S_ON_STU_X]gr_nine_enroll_dt_outsideON)
If all three fields are not defined then the year of the earliest date from grade 9 enrolment is used
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