SchoolAlertConfig (ver10.0.3)
This table stores Consecutive Absences Notification information per school, which is used nightly to calculate the values in the ConsecutiveDaysAlert table. No calculations are performed nightly for a school until the school settings are entered in the Attendance Preference page accessible via School > Attendance Preferences.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
AlertThreshold | 10.0.3 | Number(3) | The minimum number of consecutive days a student must be absent to trigger an alert message to an administrator. The value must be between MinDaysStored and MaxDaysStored. Required. |
Enabled | 10.0.3 | Number(1) | 1 indicates the absences for the currently enrolled students for this school will be computed in the nightly process that populates the ConsecutiveDaysAlert table. Valid values: 1, 0. Required. |
MaxDaysStored | 10.0.3 | Number(3) | The number of in session calendar days earlier than the current system date that will be searched per student for consecutive absences if the MinDaysStored is met. |
MinDaysStored | 10.0.3 | Number(3) | The minimum number of consecutive days a student must be absent for a record to be generated in the ConsecutiveDaysAlert table. Required. |
School_Number | 10.0.3 | Number(10) | School_Number of the associated Schools record. Indexed. Required. |
WhenCreated | 10.0.3 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 10.0.3 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 10.0.3 | VarChar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 10.0.3 | VarChar2(100) | The user login that modified the record. Defaults to database user. Required. |