ATN_NotifyRecToProcess (ver7.1.4)
This table is for internal ATN processing only, not for reporting. It contains all the records from the UnexcusedHistorical table that qualifies for an ATN Level.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
ATN_NotifyRectoProcess_ID | 7.1.4 | Number(10) | Sequential number generated by the application. Indexed. |
CntVal | 7.1.4 | Number(10) | The row count for each StudentID/UnexcusedDate record. |
LevelName | 7.1.4 | Varchar2(30) | The level name defined by the customer. |
Loaded | 7.1.4 | Number(10) | Set to 1 if the record is already in UnexcusedNotify. Indexed. |
Lvl | 7.1.4 | Number(10) | If the record matches the Level's trigger value, then it will be set to the value; otherwise it is be set to zero. Indexed. |
RecType | 7.1.4 | Char(2) | A indicates Absent, TA indicates Total Absent, T indicates Tardy, TT indicates Total Tardy, I indicates Illness, and TI indicates Total Illness. |
SchoolID | 7.1.4 | Number(10) | This ID is linked to the School_Number from the School table. |
StudentID | 7.1.4 | Number(10) | The internal number for the student with which this record is associated. |
TermVal | 7.1.4 | Number(10) | The term value. Valid values: Semester, Trimester, Quarter, Month, Week. |
UnexcusedDate | 7.1.4 | Date | The date of the unexcused absence. |
YearID | 7.1.4 | 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. |