DistrictCalendar (ver7.1.4.1)
This table contains district level calendars. Associated DistrictCalendarDay records can be used to create Calendar_Day records for individual schools.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
CalendarName | 7.1.4.1 | Varchar2(50) | User-defined name of the calendar. Required. |
CalendarYear | 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. |
EndDate | 7.1.4.1 | Date | Last day applicable to this calendar. Required. |
ID | 7.1.4.1 | Number(10,0) | Unique sequential number generated by the application. Indexed. Required. |
StartDate | ver... | Date | First day applicable to this calendar. 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. |