Calendar_Day, 51 (ver3.6.1)
School year calendar is maintained is this table. It's used for Bell Schedules, ADM/ADA reports and overall attendance by showing which days are in-session within different tracks or overall. This used to be named DailySchedules.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
A | 3.6.1 | Number(10,0) | 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 | 3.6.1 | Number(10,0) | 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. |
Bell_Schedule_ID | 3.6.1 | Number(10,0) | The internal number for the Bell Schedule with which this record is associated. Indexed. |
C | 3.6.1 | Number(10,0) | 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. |
Cycle_Day_ID | 3.6.1 | Number(10,0) | The internal number for the Cycle Day with which this record is associated. |
D | 3.6.1 | Number(10,0) | 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 | 3.6.1 | Date | Each day of the school year including holidays and weekends, such as the school day. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
E | 3.6.1 | Number(10,0) | 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 | 3.6.1 | Number(10,0) | 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 | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
InSession | 3.6.1 | Number(10,0) | 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 | 3.6.1 | Float | 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 | 3.6.1 | Varchar(50) | Comments that describe the schedule on this date, such as Half-Day, Holiday, or Spring Break. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
ScheduleID | 3.6.1 | Varchar(20) | Schedule ID this date belongs to. Defaults to A. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
Type | 3.6.1 | Varchar(20) | Indicates the Type of the day, such as Holiday, In Session, or Not in Session. |
Week_Num | 4.0.0 | Number(10,0) | No longer used by the application. This field may still be referenced on reports and/or custom pages. |