Terms Table

Academic terms may be semester, quarters, or any division that the school determines to break up a grading period of the academic year. A record is required for every term the school operates, and for past academic years in order to properly enter the a transfer student's transcripts.

Academic terms are related to many different records in the system.  Every class a student takes in taken is a specific academic year.  Academic terms are related to the academic years, they can not be created if there is no academic year in the system.

Fields

The user links the term record to an academic year record by selecting the record.

Start year, end year are the same as the academic year the term is related to.

The start date and end date are different for each term record.  The start date of the first term of the year is the same as the start date of the related academic year.

The term record is related to a term label record.  A term label record stores the name of the term, fall, spring etc.  Using the term label record and the year of the term start date, the PEMS concatenates the Term name, "Fall 2020"

The ordinate is user-entered and is the order the terms take place in aggregate. 

Calendar days and school days are calculated based on the vacation day records.

Flag is needed to help PEMS determine if the term is the first term of the year or the last term of the year. This is used in other algorithms in PEMS.