ATN_ITVLBellSchedItms (ver7.1.4)
This table is for internal ATN processing only, not for reporting. It is a copy of the Bell Schedule table for Interval schools with the Interval_Number column added. This column will hold the interval number. If there are 3 interval for a period than this table will have a record for each with the Internal_Number being 1, 2 and 3.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ADA_Code | 7.1.4 | Number(10) | If this Bell Schedule Item is to be counted for Average Daily Attendance calculations. 1= yes, 0=no. |
Bell_Schedule_ID | 7.1.4 | Number(10) | The internal number for the Bell Schedule with which this record is associated. Indexed. |
Daily_Attendance_Code | 7.1.4 | Number(10) | Indicates whether this is to be counted for schools Daily Attendance. 1=yes, 0=no. |
Daily_Time_In_Default | 7.1.4 | Number(10) | The time of day this period starts for this Bell Schedule if Daily Attendance is to be used. |
Daily_Time_Out_Default | 7.1.4 | Number(10) | The time of day this period ends for this Bell Schedule if Daily Attendance is to be used. |
End_Time | 7.1.4 | Number(10) | The time of day this period ends for this Bell Schedule. |
ID | 7.1.4 | Number(10) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Indexed. |
Interval_Number | 7.1.4 | Number(10) | The period's interval_number. For example, if the period has 3 intervals than there would be 3 records for this period. For the first record this value would be 1, the next record would be 2, and the last would be 3. Indexed. |
Minutes_Attended | 7.1.4 | Number(10) | The calculated minutes between the Start_Time and End_Time. |
Period_ID | 7.1.4 | Number(10) | The internal number for the Period with which this record is associated. Indexed. |
Start_Time | 7.1.4 | Number(10) | The time of day this period starts for this Bell Schedule. |