SchedulePeriods, 80 (ver3.6.1)
Periods and related information used for scheduling purposes.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbr | 3.6.1 | Varchar(3) | Short version of the Name used for this period, such as p1, 1, etc. |
BlockStart | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
BuildID | 5.0.0 | Number(10,0) | Identifier for the current build. |
CorePeriod | 5.0.0 | Number(10,0) | Flag stating whether or not this is the Core Period. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | Varchar(15) | Name of the period, such as Period 1, Study Hall, etc. |
EndTime1 | 3.6.1 | Varchar(7) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
EndTime2 | 3.6.1 | Varchar(5) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
PeriodID | 3.6.1 | Varchar(2) | Period ID used for sorting purposes. Could be just the string format of the Number. |
PeriodNumber | 3.6.1 | Number(10,0) | Period number for this record, such as 1, 2, 3, etc. |
ScheduleID | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
ScheduleStudies | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Sort | 3.6.1 | Number(10,0) | The sort order to display the periods when necessary. |
StartTime1 | 3.6.1 | Varchar(7) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
StartTime2 | 3.6.1 | Varchar(5) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |
UseForBuild | 3.6.1 | Number(10,0) | Indicates whether to use this period for scheduling. Its set based on Periods Per Day in Schedule Builds. 1=True. |
UseForLunches | 3.6.1 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |