PSM_Period (ver1.5)
Periods are used in combination with days to create schedule expressions. For example, a section of Biology that meets for the first period on each day of a two-day schedule has the expression 1(A-B). Data duplicated here from the originating SIS.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Abbreviation | 1.5 | Varchar2(10) | Short version of the Name used for this period, such as p1, 1, etc. |
ID | 1.5 | Number(19,0) | Unique sequential number generated by the application. Required. |
Name | 1.5 | Varchar2(256) | Name of the period, such as Period 1, Study Hall, etc. |
PeriodNumber | 1.5 | Number(10,0) | Period number for this record, such as 1, 2, etc. Indexed. |
SchoolID | 1.5 | Number(19,0) | Internal number for the associated PSM_School record. |
SchoolYear | 1.5 | Number(10,0) | The four-digit year that the term is associated, such as 2009 for the 2008-2009 school year. |
SortOrder | 1.5 | Number(10,0) | The sort order to display the periods when necessary. |