Attendance_Time, 158 (ver4.0.0)
Maintains the times students attended a class, one row for when they entered and another for when they exited. This way the hours attended could be calculated for the classes that track attendance hourly.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
AttTM_Comment | 4.0.0 | CLOB | Free form text that staff can enter for this attendance time record. |
AttendanceID | 4.0.0 | Number(10,0) | The internal number for the Attendance with which this record is associated. Indexed. |
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. |
Omit_Min_YN | 4.0.0 | Number(10,0) | Indicates whether minutes are omitted when calculating Attendance.Total_Minutes. |
Time_In | 4.0.0 | Number(10,0) | Actual time of day the student entered class. |
Time_Out | 4.0.0 | Number(10,0) | Actual time of day the student exited class. |
Total_Minutes | 4.0.0 | Number(10,0) | The total minutes student was in class. Calculated based on TimeIn and TimeOut. |