Agg_Attendance, 167 (ver4.0.0)
This table maintains aggregated attendance data for reporting purposes. The data is aggregated for ADA/ADM based on different criteria using the Attendance table. This is used for achieving greater performance in reports.
| 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_Period | 4.0.0 | Float | ADA value for this day, student combination for the period - section meeting. |
ADA_Value_Time | 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. |
Agg_Calc_Type | ver... | Varchar(15) | Aggregate calculation type. |
Att_Date | 4.0.0 | Date | This is the attendance date for this aggregation record. Although a relationship to Calendar_Day exists, this is done for performance reasons. |
Att_Minutes | 4.0.0 | Number(10,0) | Actual minutes student attended classes for this day. |
Att_Mode_Code | 4.0.0 | Varchar(20) | Classification of attendance records: section, daily, hbyh, and hbyday. Indexed. |
Backfill_Status_Code | ver... | Varchar(10) | Back fill status code value. |
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. |
District_Num | 4.0.0 | Varchar(40) | District Number for this aggregation record. |
End_DT | 4.2.0 | Date | Attendance end date. |
ID | 4.0.0 | Number(10,0) | A unique sequential number generated by the application. Indexed. |
ProgramID | 4.0.0 | Number(10,0) | Foreign key to the Program table. Indexed. |
Rprt_Days_Num | 4.0.0 | Number(10,0) | Number of days for report generation. |
SchoolID | 4.0.0 | Number(10,0) | The School_Number of the associated Schools record. |
Start_Dt | 4.2.0 | Date | Attendance start date. Indexed. |
StudentID | 4.0.0 | Number(10,0) | The internal number and ID of the associated Students record. |
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. |