Attendance_Taken, 172 (ver4.0.0)
This table shows the teachers that took attendance for a specific day a record for the appropriate attendance mode code.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Att_Date | 4.0.0 | Date | This is the date the attendance was taken for this record. Although a relationship to Calendar_Day exists, this is done for performance reasons. Indexed. |
Att_Interval | 4.0.0 | Number(10,0) | For Time attendance, the interval in the section that attendance being taken. For example, if 4-hour section attendance could be taken 4 times and this would be the instance 1 or 2. Indexed. |
Att_Taken_DT | 4.0.0 | Date | This is different than the Att_Date. This is date the teacher entered the attendance information, not the day of attendance. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 4.0.0 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
IP_Address | 7.8.0 | Varchar(39) | The IP address of the machine entering attendance for the serves session. Note: Compatible with Ipv6 format. |
PeriodID | 4.0.0 | Number(10,0) | The internal number for the Period with which this record is associated. Indexed. |
SectionID | 4.0.0 | Number(10,0) | The internal number and ID of the associated Sections record. |
WhoModifiedID | 7.8.0 | Number(10,0) | The DCID of the associated Users record unless the default is applied. Defaults to database user. |
WhoModifiedType | 7.8.0 | Varchar () | Indicates the type of user that modified the record. Valid values: a = admin, t = teacher, p = parent, s = student, u = sub, m = maintenance, ? = unknown. |