DistrictCycleDay (ver7.1.4.1)
These are days of the week that can be set to see which periods meet for a calendar day.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Abbreviation | 7.1.4.1 | Varchar2(3) | Not used. Required. |
ID | 7.1.4.1 | Number(10,0) | Unique sequential number generated by the application. Indexed. Required. |
Letter | 7.1.4.1 | Varchar2(2) | Not used. Required. |
Name | 7.1.4.1 | Varchar2(30) | User-defined name given for this day, such as A Day. Required. |
WhenCreated | 7.1.4.1 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 7.1.4.1 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 7.1.4.1 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 7.1.4.1 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |
Year | 7.1.4.1 | Number(10,0) | Two-digit internal representation for a calendar year. Computed by subtracting 1990 from the current start of school calendar year. Required. |