DistrictCalendarDay (ver7.1.4.1)
School year calendar for the district is maintained is this table. Used to create individual school calendars in Calendar_Day.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
A | 7.1.4.1 | Number(3) | Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
B | 7.1.4.1 | Number(3) | Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
C | 7.1.4.1 | Number(3) | Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
D | 7.1.4.1 | Number(3) | Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
Date_Value | 7.1.4.1 | Date | Each day of the school year including holidays and weekends, such as the school day. Indexed. Required. |
DistrictBellScheduleID | 7.1.4.1 | Number(10) | The internal number for the DistrictBellSchedule with which this record is associated. Indexed. |
DistrictCalendarID | 7.1.4.1 | Number(10) | The internal number for the DistrictCalendar with which this record is associated. Indexed. Required. |
DistrictCycleDayID | 7.1.4.1 | Number(10) | The internal number for the DistrictCycleDay with which this record is associated. Indexed. |
E | 7.1.4.1 | Number(3) | Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
F | 7.1.4.1 | Number(3) | Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
ID | 7.1.4.1 | Number(10) | Unique sequential number generated by the application. Indexed. Required. |
InSession | 7.1.4.1 | Number(3) | Indicates whether this day of the year is an actual school day.1=insession, 0=no (holiday, weekend, etc.) This is only used if all students attend school on the same date. Otherwise Tracks A-F are used to indicate insession days. |
MembershipValue | 7.1.4.1 | Float(126) | The amount of a student's membership this school claims. If a student attends more than one school each one will only be able to claim a certain portion of the membership. The largest number for this will usually be 1 and fractions expressed as decimals. Like .5 or .25. |
Note | 7.1.4.1 | Varchar2(50) | Comments that describe the schedule on this date, such as Half-Day, Holiday, or Spring Break. |
Type | Varchar2(20) | Indicates the Type of the day, such as Holiday, In Session, or Not in Session. | |
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. |