Terms Table
Relevent Topics
{{@90#bkmrk-a-term-is-the-divisi}}
{{@90#bkmrk-the-names-of-the-ter}}
School Terms (Terms)
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.term. Academic terms are related to the academic years, so they can not be created if there is no academic year in the system.
Fields
In manual operation, The user links the term record to an academic year record by selecting the record. PEMS will implement automation so that school term records are auto-created.
School Terms Actual Start/End Dates
The user specifies a start date and end date for every academic year. In the term label record, the user specifies the general day and month that each term is starts and ends. Based on this information term school records are created. After these school term records are created, the user can adjust the specific days of each school term. Future records that have not been updated are considered estimated start days.
Data Relationships
The term record is related to a term label record. A term label record stores the name of the term, fall, spring and the attributes common to all terms.
Fields
Start year,year, end year are the same as the academic year the term is related to.to, auto-entered by PEMS.
The start date and end date mark the actual dates the term starts and end. When new term records are differentautomatically for each term record.created 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,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 inherited from the term label record and 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.
Action items JAN 2024
4-MVP | ADVANCEMENT | Auto-enter the ordinate by increasing by one every time a new record is created, allow user to manually update.
4-MVP | ADVANCEMENT | Auto-update the ordinate based on start date, allow user to manually update
4-MVP | ADVANCEMENT |Auto-enter the start date based on linked academic year and linked term label - term label has a default start month and day, the year has the year, create a start date.
4-MVP | ADVANCEMENT| Auto-create term records every time a new academic year record is created with default start dates and ordinates.