Bell_Schedule_Items, 134 (ver3.6.1)
These are the actual times a period for a Bell Schedule starts and ends during the day. This replaces much of functionality of ScheduleItems table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ADA_Code | 3.6.1 | Number(10,0) | If this Bell Schedule Item is to be counted for Average Daily Attendance calculations. 1= yes, 0=no. |
Bell_Schedule_ID | 3.6.1 | Number(10,0) | The internal number for the Bell Schedule with which this record is associated. Indexed. |
Daily_Attendance_Code | 3.6.1 | Number(10,0) | Indicates whether this is to be counted for schools Daily Attendance. 1=yes, 0=no. |
Daily_Time_In_Default | 3.6.1 | Number(10,0) | The time of day this period starts for this Bell Schedule if Daily Attendance is to be used. |
Daily_Time_Out_Default | 3.6.1 | Number(10,0) | The time of day this period ends for this Bell Schedule if Daily Attendance is to be used. |
DayPartID | 7.2.2 | Number(10,0) | Day part with which this bell schedule item is associated. Optional, used only if day part processing is enabled (att_daypartenabled is set to true). |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
End_Time | 3.6.1 | Number(10,0) | The time of day this period ends for this Bell Schedule. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Minutes_Attended | 3.6.1 | Number(10,0) | The calculated minutes between the Start_Time and End_Time. |
Period_ID | 3.6.1 | Number(10,0) | The internal number for the Period with which this record is associated. Indexed. |
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. |
Start_Time | 3.6.1 | Number(10,0) | The time of day this period starts for this Bell Schedule. |