Att_Nightly_Log (ver7.2.2)
This table logs activities of the Att_DayPart_Nightly stored procedure and its associated procedures. It is equivalent to the ViewsControl table, except that it is primarily for the results of day part-related processing. Some of the entries in the table are used to control the behavior of Att_DayPart_Nightly.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CutOffDay | 7.2.2 | Date | The latest day (normally the current day) the run takes data into account from. |
EndTime | 7.2.2 | Timestamp | The actual ending time of this phase of processing. |
| Message | 22.10.0.0 | Varchar(4000) | Captures any SQL errors if an error occurs while processing a School. |
Process | 7.2.2 | Varchar(4) | A four-letter abbreviation of the process this log record represents, such as DPNY (the day part new year process) and ADPN (Att_DayPart_Nightly overall control). |
RowsProcessed | 7.2.2 | Number(10,0) | Number of rows that were processed in this run. |
SchoolID | 7.2.2 | Number(10,0) | School number processed in this run (0 for system-wide updates). |
StartTime | 7.2.2 | Timestamp | The actual starting time of this phase of processing. |
YearID | 7.2.2 | Number(10,0) | The school year ID for this phase of processing, such as 1991-2=1, etc. |