UnexcusedNotifyDates (ver7.1.4)
This table stores the dates for each UnexusedNotify record making it easier to pull the notification dates. This table is a one-to-many relationship with the UnexcusedNotify table.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
NotifyDate | 7.1.4 | Date | One of the dates for a notification. Required. |
RecType | 7.1.4 | Varchar2(10) | Valid values: TA = Total unexcused absents; TT = Total unexcused tardy; TI = Total Illness. Required. |
UnexcusedNotifyDates_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. |