Create School Terms

Purpose

For every academic year, there needs to be a user-specified number of term records, so when a new academic year record is added, the program should automatically create the associated term records for that year.  The program knows how many term records to make, and how they should be configured from the records in the term label table.  

Business Rules

Actions

1. Make a new set of term records when a new academic year is created.
2. Make one term record for each term label record.
3. Associate new records to Academic Year and Term Label record

Calculations

1. Calculate the term start date from the  term label record “start day” and term label record “start month” and the academic year record
2. Calculate the term end date from the  term label record “end day” and term label record “end month” and the academic year record
3. Term Name = concatenate Term Label name and Start Year

Algorithms - How to identify the correct calendar year:

Because the academic year record may or may  not span two calendar year, finding the start year and end year of each term is more complicated. Use the following logic.

• If the Term Label “Start Month” is less than the Term Label “End Month” then the term starts and ends in the same calendar year.
• If the Term Label “End Month”  is less than the Term Label “Start Month” then the term crosses over the new year.
• Term Label records are sequenced  by the Term Label “Sequence” field. If the previous term label record (the earlier term) has an start month greater than the start month of the next term label, then both terms begin in the same calendar year.