UnexcusedHistorical (ver5.2.1.5)
This table stores both a summary record and a detail record per student for unexcused attendance. One detail record is created for each attendance record that meets the criteria for Attendance Tracking and Notification (potentially more than one record per day) and one summary record is stored for each day that the student has unexcused attendance. Records are created and re-created with each run of Refresh Attendance Tracking Data report. Storing unexcused attendance in this table increases report performance.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ATN_Month | 7.1.4 | Number(10) | The calendar month the unexcused absent or tardy occurred. Valid values: 1 – 12. |
ATN_Week | 7.1.4 | Number(10) | The calendar week the unexcused absent or tardy occurred. Valid values: 1 – 52. |
Consecutive_Group | 7.1.4 | Number(10) | Internal use only. Not for reporting. Used to group consecutive unexcused day together. This would be used within the code to determine a consecutive notification. |
Consecutive_SubGroup | 7.1.4 | Number(10) | Internal use only. Not for reporting. Used to group consecutive unexcused day together. This would be used within the code to determine a consecutive notification. |
CourseID | 6.0.1.6 | Number(10) | The internal ID for the Course to which this record is associated. |
CourseName | 6.0.1.6 | Varchar2(100) | The name from Courses Stored here for convenience. |
CourseNumber | 6.0.1.6 | Varchar2(20) | The course_number from Courses Stored here for convenience. |
ConversionCnt | 6.0.1.6 | Number(3,2) | The conversion associated with the unexcused absence or tardy derived from Attendance_Conversion_items. For Daily Code-To-Day and Daily Time-To-Day the conversion value is based of the attendance code. For Meeting Period-To-Day and Meeting Time-To-Day the conversion value is based on the total number of unexcused absences. |
EnrollmentNumber | 6.0.1.6 | Number(10) | No longer used by application. This field may be referenced on reports and/or custom pages. |
ID | 5.2.1.5 | Number(19) | Unique number generated by the application. Indexed. |
LevelName | 6.0.1.6 | Varchar2( 30) | Indicates the level name reached by the student as defined by the district. |
LevelReached | 6.0.1.6 | Number(10) | Indicates when a student reaches a certain level (occurrence) of unexcused absences or truancy as defined by the district. |
Percent_Match | 7.1.4 | Number(10) | 1 indicates if the percent of the day missed for unexcused reasons is greater than the threshold value of Tracking Method Percent. |
PeriodAbbreviation | 6.0.1.6 | Varchar2(3) | The abbreviation from Period. Stored here for convenience. |
PeriodCnt | 5.2.1.5 | Number(10) | The number of periods with unexcused absences. Derived from the Attendance records on UnexcusedDate. For Daily Code-To-Day this will always be between 0 and 1. |
PeriodName | 6.0.1.6 | Varchar2(80) | The name from Period. Stored here for convenience. |
PeriodNumber | 6.0.1.6 | Number(10) | The period_number from Period. Stored here for convenience. For Daily Code-To-Day and Daily Time-To-Day this will be 1. |
Potential_Minutes_Attended | 6.2.2.2 | Number(10) | The period length based on the bell schedule. This field applies to tracking attendance using the Period tracking method. |
Quarter | 6.0.1.6 | Number(10) | The quarter the unexcused absence or tardy occurred. Zero = Quarter not defined. Determined by portion in Terms. |
RecType | 6.0.1.6 | Varchar2(5) | Indicates the type of record. Valid values: A - Unexcused Absent, T - Unexcused Tardy, I – Illness, TA - Total Unexcused Absent per student/day, TT - Total Unexcused Tardy per student/day, and TI – Total Illness per student/day. |
SchoolID | 5.2.1.5 | Number(10) | This ID is linked to the School_Number from the School table. Indexed. |
SectionID | 6.0.1.6 | Number(10) | The internal ID for the Section to which this record is associated. |
SectionNumber | 6.0.1.6 | Varchar2(10) | The section_number from Sections Stored here for convenience. |
Semester | 6.0.1.6 | Number(10) | The semester the unexcused absent or tardy occurred. Zero = Semester not defined. Determined by portion in Terms. |
StudentID | 5.2.1.5 | Number(10) | The internal number for the Student to which this record is associated. Indexed. |
TeacherFirstName | 6.0.1.6 | Varchar2(100) | The first_name from Teachers. Stored here for convenience. |
TeacherLastName | 6.0.1.6 | Varchar2(100) | The last_name from Teachers. Stored here for convenience. |
TeacherMiddleName | 6.0.1.6 | Varchar2(100) | The middle_name from Teachers. Stored here for convenience. |
TeacherID | 6.0.1.6 | Number(10) | The internal identification number of the teacher in the associated SchoolStaff record. |
Threshold_Period_Cnt | 6.2.2.2 | Number(10) | The number of periods that meet the threshold criteria for the Period tracking method. This field is populated for summary attendance records, but not detail records. |
Trimester | 6.0.1.6 | Number(10) | The trimester the unexcused absent or tardy occurred. Zero = Trimester not defined. Determined by portion in Terms. |
Unexcused Date | 5.2.1.5 | Date | The date of the unexcused absence captured from the Att_Date in the Attendance table. |
WhenCreated | 5.2.1.5 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 5.2.1.5 | Timestamp(6) | Currently not used. |
WhoCreated | 5.2.1.5 | Varchar2(305) | The user login that created the record. Defaults to database user. |
WholeDayInd | 5.2.1.5 | Char(1) | No longer used by application as of ver6.0.1.6. Indicates the school's preference for counting attendance.W:wholeday;H:halfday. Captured from Schools custom field UEAT_Whole_Day_Ind. |
WhoModified | 5.2.1.5 | Varchar2(305) | Currently not used. |
YearID | 5.2.1.5 | Number(10) | 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. Indexed. |