ATN_TermOrder (ver7.1.4)
This table is for internal ATN processing only, not for reporting. It is a copy of the Term table with an extra column called TermOrder to indicate the order of each term (see TermOrder column below for more detail).
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
FirstDay | 7.1.4 | Date | First day of the term. |
LastDay | 7.1.4 | Date | Last day of the term. |
SchoolID | 7.1.4 | Number(10) | This ID is linked to the School_Number from the School table. Indexed. |
TermOrder | 7.1.4 | Number(10) | Indicates the order of a term. For example, if the term is semester than a 1 indicates semester 1 and 2 semester 2. |
TermType | 7.1.4 | Number(10) | 2 indicates Semester, 3 indicates Trimester, and 4 indicates Quarter. |
YearID | 7.1.4 | Number(10) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Indexed. |