UnSchedTermDayPeriodSlot, 142 (ver3.6.1)
The combination of term+day+period+slot where the student is free to be scheduled. This is a temporary table for 4D only.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
BuildID | 3.6.1 | Number(10,0) | Currently not used. The internal number for the ScheduleBuild with which this record is associated. |
Day | 3.6.1 | Number(10,0) | Number of day(s) that are not scheduled. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. |
LastModDate | 3.6.1 | Date | The date this record was created or last modified. |
LastModTime | 3.6.1 | Date | The time this record was created or last modified. |
Period | 3.6.1 | Number(10,0) | Number of period(s) that are not scheduled. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Sortorder | 3.6.1 | Number(10,0) | The sort order of how to go through these records but it is copied from ScheduleTerms table, Portion as term portion. |
Termcode | 3.6.1 | Varchar(30) | The shorter name for the term. This will be the most familiar. Like S1. Copied from ScheduleTerms table, Abbreviation. |
Termportion | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
YearID | 3.6.1 | Number(10,0) | The BuildYear from ScheduleBuilds. 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. |