Attendance, 157 (ver4.0.0)
This is the main attendance table (4.0 and later) and can hold both Positive and Negative attendance. There are different methods of keeping attendance, Time, Day, Period, etc. for a student for a given year. This table also can be used for backfilling purposes.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ADA_Value_Code | 4.0.0 | Float | ADA value for this day, student combination based on daily codes. |
ADA_Value_Ti me | 4.0.0 | Float | ADA value for this day, student combination for time mode. |
ADM_Value | 4.0.0 | Float | ADM value for this day, student combination. |
Att_Comment | 4.0.0 | CLOB | Free form text that staff can enter for this attendance record. |
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_Flags | 5.0.0 | Number(10,0) | Multi-use field, which is currently used to track the "origin" of this record. |
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_Mode_Code | 4.0.0 | Varchar(20) | Classification of attendance records: section, daily, hbyh, and hbyday. Indexed. |
Attendance_CodeID | 4.0.0 | Number(10,0) | The internal number for the Parent Attendance with which this record is associated. This shows if this row is linked to another in this table, such as backfilling purposes. Indexed. |
CCID | 4.0.0 | Number(10,0) | The internal number for the CC with which this record is associated. Indexed. |
Calendar_DayID | 4.0.0 | Number(10,0) | The internal number for the Calendar Day 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. |
IP_Address | 7.8.0 | Varchar(39) | The IP address of the machine creating or updating the attendance row. Note: Compatible with Ipv6 format. |
Lock_Reporting_YN | 4.0.0 | Number(10,0) | Indicates whether attendance can be changed due to reporting. |
Lock_Teacher_ YN | 4.0.0 | Number(10,0) | Indicates whether teacher can change attendance or not. |
Parent_AttendanceID | 4.0.0 | Number(10,0) | The attendance record this record is linked to. Mainly for backfilling purposes to see where the record those hours were debited from are. Indexed. |
PeriodID | 4.0.0 | Number(10,0) | The internal number for the Period with which this record is associated. Indexed. |
ProgramID | 4.0.0 | Varchar(80) | Program under which attendance is taken. Indexed. |
Prog_Crse_Type | 4.0.4 | Varchar(10) | Program Course Type. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
StudentID | 4.0.0 | Number(10,0) | The internal number and ID of the associated Students record. |
Total_Minutes | 4.0.0 | Number(10,0) | Total minutes of attendance for this record, can be negative in the case of a debit transaction for backfilling. |
Transaction_Type | 4.0.0 | Varchar(10) | Indicates credit or debit for this record. This is mainly used for backfilling purposes where attendance hours is debited from one record and credited into another. |
WhoModifiedID | 7.8.0 | Number(10,0) | The DCID of the associated Users record unless the default is applied. Defaults to 0. For example, if WhoModifiedType = s, then this value is Students. DCID. However, if WhoModifiedType = u or ?, then this value is 0. |
WhoModifiedType | 7.8.0 | Varchar(1) | Indicates the type of user that modified the record. Valid values: a = admin, t = teacher, p = parent, s = student, u = substitute, m = maintenance, ? = unknown. |
YearID | 4.0.0 | 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. Maintained in the Terms table. Indexed. |