Section Date Deriver Logic
In order to validate data in PASI, there may be a need to derive information based on other data on the record.
This will occur when a business rule requires information, but the data needed to evaluate the rule is optional or conditionally optional.
In the case of Sections, the Start Date and End Date on the Section record is optional.
In order to validate other data on the Section or Course Enrolment record, the Section Dates may need to be derived based on the Section Term.
In the technical implementation, this is referred to as the “SectionTermDateMapper”.
The dates below are represented as “Derived Section Start Date” to “Derived Section End Date”:
Quarter 1 = September 1 to November 14
Quarter 2 = November 15 to January 31
Quarter 3 = February 1 to April 14
Quarter 4 = April 15 to June 30
Semester 1 = September 1 to January 31
Semester 2 = February 1 to June 30
Full Year = September 1 to June 30
Summer = July 1 to August 31
Continuous = January 1 of Calendar Year prior to School Year to December 31 of current School Year’s Calendar Year
Unknown = September 1 to June 30
For all date derivations:
The start date has to be in between the respective section term corresponding start date +/- one month.
The end date has to be in between the respective section term corresponding end date +/- one month.
For the end date we also adjust a day to get to the 1st or 15th of the month.
Notes
This Section Term Dates were also used by the PASI historical data routines.
The “Unknown” parameter is not expected to be used. It is included as a technical requirement to ensure that the system is always able to evaluate against a date and that an unexpected error is not experienced (i.e. – new Section Term is available/used but is not “known” by PASI).
Examples for Continuous
Example 1:
Mark has Completion Date of September 30, 2012 and Section Term of Continuous. This would be determined to be 2013 School Year.
Section Start Date = January 1, 2012
Section End Date = December 31, 2013
Example 2:
Mark has Completion Date of July 31, 2012 and Section Term of Continuous. This would be determined to be 2012 School Year.
Section Start Date = January 1, 2011
Section End Date = December 31, 2012
Example 3:
Mark has Completion Date of March 31, 2013 and Section Term of Continuous. This would be determined to be 2013 School Year.
Section Start Date = January 1, 2012
Section End Date = December 31, 2013
Validation Rules
The following are validation rules that use the section date deriving logic: