AttendanceQueue, 48 (ver3.6.1)
This table serves as a temporary holding place for attendance when this data is to be sent to external systems via AutoSend.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Att_Comment | 4.0.0 | CLOB | Copied from Attendance table for submission. |
Att_Date | 4.0.0 | Date | Renamed Date. |
Att_Interval | 4.0.0 | Number(10,0) | Copied from Attendance table for submission. |
Att_Mode_Code | 4.0.0 | Varchar(20) | Copied from Attendance table for submission. |
Attendance_CodeID | 4.0.0 | Number(10,0) | Copied from Attendance table for submission. |
CCID | 3.6.1 | Number(10,0) | The internal number for the CC, student section enrollment, with which this attendance transaction is associated. |
Calendar_DayID | 4.0.0 | Number(10,0) | Copied from Attendance table for submission. |
DateRecorded | 3.6.1 | Date | The date the attendance was changed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Lock_Teacher_YN | 4.0.0 | Number(10,0) | Copied from Attendance table for submission. |
OldAttendance_CodeID | 4.0.0 | Number(10,0) | Previous Attendance_CodeID before it's changed. |
Parent_AttendanceID | 4.0.0 | Number(10,0) | Copied from Attendance table for submission. |
PeriodID | 4.0.0 | Number(10,0) | Copied from Attendance table for submission. |
Program_Name | 4.0.0 | Varchar(80) | Copied from Attendance table for submission. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SectionID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Sections record. |
StudentID | 3.6.1 | Number(10,0) | The internal number and ID of the associated Students record. |
TimeRecorded | 3.6.1 | Number(10,0) | The time the record was changed. |
Total_Minutes | 4.0.0 | Float | Copied from Attendance table for submission. |
Transaction_Type | 4.0.0 | Varchar(20) | Copied from Attendance table for submission. |
YearID | 4.0.0 | Number(10,0) | Copied from Attendance table for submission. |