ScheduleTerms, 108 (ver3.6.1)
The future terms for which you will be scheduling.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Abbreviation | 3.6.1 | Varchar(6) | The shorter name for the term. This will be the most familiar. Like S1. |
AutoBuildBin | 3.6.1 | Number(10,0) | Used when copying the master schedule. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
FirstDay | 3.6.1 | Date | The first day of the term. Indexed. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
ImportMap | 3.6.1 | Varchar(20) | If you are importing what code will relate to this term. |
IsYearRec | 3.6.1 | Number(10,0) | A flag indicating if this record is a yearlong term. 1=yes 0=no |
LastDay | 3.6.1 | Date | The last day of the term. |
Name | 3.6.1 | Varchar(30) | The common name for this term, such as Semester 1. Indexed. |
NoOfDays | 3.6.1 | Number(10,0) | Calculated number of days between the dates that have school in session. |
Portion | 3.6.1 | Number(10,0) | The fraction of a year the term takes. A Semester is 1/2 a quarter 1/4. Internally only the denominator, the bottom part of the fraction, is stored. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
TermsInYear | 3.6.1 | Number(10,0) | The number of terms this particular term takes up when looking at the LCM. For example a school with trimesters and quarters and semesters would have an LCM of 12 so one semester would take up 6 terms while a trimesters would take up 4 and the quarter would take up 3 even though the shortest term is a quarter. This field is used in the scheduling engine. |
YearID | 3.6.1 | Number(10,0) | 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. |
YearlyCreditHrs | 3.6.1 | Float | No longer used by the application. This field may still be referenced on reports and/or custom pages. |