AU_Reenrollments ver 19.7.1.0
An audit table for reenrollments. In order to generate data, the plugin DCF: USA OH Audit must be enabled.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| AUD_SEQ | 19.7.1.0 | Number(19) | The system assigned number for the record. |
| Transaction_Date | 19.7.1.0 | TimeStamp(6) | The date the change was made. |
| DML_Type | 19.7.1.0 | VarChar2(1) | Indicates the type of change: update, insert or delete. Table values are saved as U, I, or D |
| DCID | 19.7.1.0 | Number(10) | The DCID of the record that is changed. |
| ID | 19.7.1.0 | Number(10) | The ID of the record that is changed. |
| StudentID | 19.7.1.0 | Number(10) | The student's ID. |
| O_EntryDate | 19.7.1.0 | Date | The previous (old) Entry Date prior to the change. |
| N_EntryDate | 19.7.1.0 | Date | The new Entry Date associated with this change. |
| O_EntryCode | 19.7.1.0 | VarChar2(20) | The previous (old) Entry Code prior to the change. |
| N_EntryCode | 19.7.1.0 | VarChar2(20) | The new Entry Code associated with this change. |
| O_ExitDate | 19.7.1.0 | Date | The previous (old) Exit Date prior to the change. |
| N_ExitDate | 19.7.1.0 | Date | The new Exit Date associated with this change. |
| O_ExitCode | 19.7.1.0 | VarChar2(20) | The previous (old) Exit Code prior to the change. |
| N_ExitCode | 19.7.1.0 | VarChar2(20) | The new Exit Code associated with this change. |
| O_SchoolID | 19.7.1.0 | Number(10) | The previous (old) School ID prior to the change. |
| N_SchoolID | 19.7.1.0 | Number(10) | The new School ID associated with this change. |
| O_Grade_Level | 19.7.1.0 | Number(10) | The previous (old) Grade_Level prior to the change. |
| N_Grade_Level | 19.7.1.0 | Number(10) | The new Grade_Level associated with this change. |
| IP_Address | 19.7.1.0 | VarChar2(39) | The IP address associated with the computer from which this change was processed. |
| WhoModifiedID | 19.7.1.0 | Number(10) | The user ID of the person who made the change. |
| WhoModifiedType | 19.7.1.0 | VarChar2(1) | The user type associated with the person who made the change. Table values are saved as A for Admin; T for Teacher; P for Parent; S for Student; U for Substitute; M for Maintenance and '?' for Unknown. |