UnexcusedNotifyDatesHist (ver7.1.4)
This table stores archived records from the UnexcusedNotifyDates table. All of the columns from the UnexcusedNotifyDates table are copied into this table, with the addition of the UEAT_Status and UEAT_Status_Date columns. Records in this table are considered invalid, but are copied to this table instead of deleted in case the archive was made in error. Records can be archived for each attendance tracking level individually using the "Clear all existing records for this level" checkbox at the district level via Start Page > District Setup > Attendance Tracking and Notification > Unexcused Levels.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
NotifyDate | 7.1.4 | Date | Unexcused dates that caused a notification record. Required. |
RecType | 7.1.4 | Varchar2(10) | TA for absents, TT for tardy or TI for Illness. Required. |
UnexcusedNotifyDatesHist_ID | 7.1.4 | Number(10) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. Required. |
Unexcused_Notify_ID | 7.1.4 | Number(10) | Foreign key to the UnexcusedNotify table ID column. Required. |