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