AutoCalendarSetting (ver8.3.0)
This table stores the customer's previous settings used when creating a district/school calendar using district/ school level Automated Calendar Setup as a reference for future changes. Since multiple district calendars are allowed per year, rows are unique per DistrictCalendarID, SchoolID, YearID, and SettingName. To navigate to this page in the application: District > District Calendars > Select District Calendar > Automated Calendar Setup.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AutoCalendarSettingI D | 8.3.0 | Number(10) | Unique sequential number generated by the application. Indexed. Required. |
DistrictCalendarID | 8.3.0 | Number(10) | Internal number for the associated DistrictCalendar record. No value when settings are for a school calendar. Indexed. |
SettingName | 8.3.0 | Varchar2(50) | Internal name assigned to the auto calendar setting. Required. |
SettingValue | 8.3.0 | Varchar2(256) | Internal representation of the value chosen by the user for this auto calendar setting. |
SchoolID | 8.3.0 | Number(10) | This ID is linked to the School_Number from the School table. No value when settings are for a district calendar. Required. Indexed. |
WhenCreated | 8.3.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 8.3.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 8.3.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 8.3.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |
YearID | 8.3.0 | Number(10) | An internal representation of the school year, such as 13 for 2003-2004. Maintained in the Terms table. Required. |