S_TN_AUD_EXTRACT_049_S ver 17.9.0
This table is a stand alone audit table to record data changes related to the 049 extract.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ID | 17.9.0 | Number(11,0) | Unique Record ID. |
| ChangedCoreColumnNames | 17.9.0 | Varchar2(4000) | List of column names changed |
| DataVersion | 17.9.0 | Varchar2(50) | Generated identifier of the data change event |
| DMLDate | 17.9.0 | Date | Data Transaction Date |
| DML_Type | 17.9.0 | Varchar2(5) | Data Transaction Type |
| E_ATT_Mode_Code | 17.9.0 | Varchar2(20) | Attendance Mode Code (logical key) |
| E_Calendar_DayID | 17.9.0 | Number(11,0) | Calendar Attendance Day ID (logical key) |
| E_Date | 17.9.0 | Date | Attendance Date (logical key) |
| E_DCID | 17.9.0 | Number(11,0) | DCID of record that changed (logical key) |
| E_ID | 17.9.0 | Number(11,0) | ID of record that changed (logical key) |
| E_Periodid | 17.9.0 | Number(11,0) | Period ID (logical key) |
| E_Programid | 17.9.0 | Number(11,0) | Program ID (logical key) |
| E_SchoolID | 17.9.0 | Number(11,0) | School ID (logical key) |
| E_StudentID | 17.9.0 | Number(11,0) | Student ID (logical key) |
| E_YearID | 17.9.0 | Number(11,0) | Year ID (logical key) |
| N_Attendance_CodeID | 17.9.0 | Number(11,0) | New Attendance Code ID |
| O_Attendance_CodeID | 17.9.0 | Number(11,0) | Old Attendance Code ID |
| TableName | 17.9.0 | Varchar2(30) | Name of the table that had a change |
| UserID | 17.9.0 | Varchar2(11) | User ID who made the change |