TeacherDailyLoad, 199 (ver5.1.1.3)
This table maintains per day enrollment count of students per teacher.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DailyLoadDate | 5.1.1.3 | Date | Day for which the load quantity is used. Indexed. |
DCID | 4.0.0 | Varchar(20) | Unique identifier for this table. Indexed. Required. |
ID | 4.2.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. |
LoadQuantity | 5.1.1.3 | Float | Enrollment count for a teacher on the day specified by DailyLoadDate. Indexed. |
SchoolID | 5.1.1.3 | Number(10,0) | The School_Number of the associated Schools record. |
TeacherID | 5.1.1.3 | Number(10,0) | The internal identification number of the teacher in the associated SchoolStaff record. Indexed. |
YearID | 5.1.1.3 | Number(10,0) | 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. |