UnexcusedNotify (ver6.0.1.6)
Contains a record per student and defined level if the student acquired the minimum number of absent or tardy records meeting the unexcused/ due to illness criteria defined by the district requiring special notification.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DateCleared | 6.0.1.6 | Date | System date assigned during the historical process re-evaluation of the records. Only assigned if the record no longer applies for the student. |
DateExtracted | 6.0.1.6 | Date | The date this record was extracted for reporting. A student can only be extracted once. Only populated if included in an extraction. |
DateReached | 6.0.1.6 | Date | Att_Date from the Attendance record for which the student met the LevelReached criteria. |
ID | 6.0.1.6 | 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. |
SchoolID | 6.0.1.6 | Number(10) | This ID is linked to the School_Number from the Schools table. Indexed. |
StudentID | 6.0.1.6 | Number(10) | The internal number for the student to which this record is associated. Indexed. |
WhenCreated | 6.0.1.6 | Timestamp(6) | Date and time the record was created. Defaults to system date. |
WhenModified | 6.0.1.6 | Timestamp(6) | Currently not used. |
WhoCreated | 6.0.1.6 | Varchar2(100) | The user login that created the record. Defaults to database user. |
WhoModified | 6.0.1.6 | Varchar2(100) | Currently not used. |
YearID | 6.0.1.6 | 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. |