Aud_Calendar_Day (ver7.9.1)
Stores audit information for certain types of changes to the calendar_day table.
| Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 7.9.1 | Number(10) | Unique identifier from the calendar_day table record. |
SchoolID | 7.9.1 | Number(10) | This ID is linked to the School_Number from the School table. |
Date_Value | 7.9.1 | Date | Each day of the school year including holidays and weekends, such as the school day. |
Old_A | 7.9.1 | Number(10) | Value before record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
New_A | 7.9.1 | Number(10) | Value after record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
Old_B | 7.9.1 | Number(10) | Value before record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
New_B | 7.9.1 | Number(10) | Value after record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
Old_C | 7.9.1 | Number(10) | Value before record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
New_C | 7.9.1 | Number(10) | Value after record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
Old_D | 7.9.1 | Number(10) | Value before record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
New_D | 7.9.1 | Number(10) | Value after record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
Old_E | 7.9.1 | Number(10) | Value before record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
New_E | 7.9.1 | Number(10) | Value after record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
Old_F | 7.9.1 | Number(10) | Value before record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
New_F | 7.9.1 | Number(10) | Value after record was modified. Standard track names that can be used if students belong to a track and do not all attend school on the same dates. If 1 then insession for this date for this track. Track on or off. 0=off 1=on. |
Old_InSession | 7.9.1 | Number(10) | Value before record was modified. Whether this day of the year is an actual school day. 1=insession, 0=no (holiday, weekend, etc.) This is only used if all students attend school on the same date. Otherwise Tracks A-F are used to indicate insession days. |
New_InSession | 7.9.1 | Number(10) | Value after record was modified. Whether this day of the year is an actual school day. 1=insession, 0=no (holiday, weekend, etc.) This is only used if all students attend school on the same date. Otherwise Tracks A-F are used to indicate insession days. |
Old_Type | 7.9.1 | Varchar2(80) | Value before record was modified. Indicates the Type of the day, such as Holiday, In Session, or Not in Session. |
New_Type | 7.9.1 | Varchar2(80) | Value after record was modified. Indicates the Type of the day, such as Holiday, In Session, or Not in Session. |
Old_Bell_Schedule_ID | 7.9.1 | Number(10) | Value before record was modified. The internal number for the Bell Schedule with which this record is associated. |
New_Bell_Schedule_ID | 7.9.1 | Number(10) | Value after record was modified. The internal number for the Bell Schedule with which this record is associated. |
DML_Type | 7.9.1 | Varchar2(1) | The transaction type that occurred to the audited table. 'I' for insert, 'U' for update, and 'D' for delete. |
Transaction_Date | 7.9.1 | Date | Date/Time audited table record was modified. |
Audit_Seq | 7.9.1 | Number(19) | The sequence number of this audit transaction. Note: All audit table use the same sequence generator to identify transactions in the order they occurred. |
WhoModifiedID | 7.9.1 | Number(10,0) | The DCID of the associated Users record unless the default is applied. Defaults to 0. For example, if WhoModifiedType = s, then this value is Students. DCID. However, if WhoModifiedType = u or ?, then this value is 0. |
WhoModifiedType | 7.9.1 | Varchar2(1) | Indicates the type of user that modified the record. Valid values: a = admin, t = teacher, p = parent, s = student, u = substitute, m = maintenance, ? = unknown. |
IP_Address | 7.9.1 | Varchar2(39) | The IP address of the machine creating or updating the row. Note: Compatible with Ipv6 format. |