Audit_Log, 170 (ver4.0.0)
All the previous data before they have been changed is maintained in a table. This is done by table basis and is therefore linked to DB_Objects. Every row shows the data in a Column at the time something in that record was changed, or if it was deleted.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
DB_ObjectID | 4.0.0 | Number(10,0) | The internal number for the DB_Object with which this record is associated. Indexed. |
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 4.0.0 | Number(10,0) | A unique sequential number generated by the application. Indexed. |
IPAddress | 4.0.0 | Varchar(20) | IP Address of the incoming system where the change was originated. |
Log_DT | 4.0.0 | Date | Date when this row was created. Indexed. |
Log_Tm | 4.0.0 | Number(10,0) | Time when this row was created. |
Modify_By | 4.0.0 | Varchar(40) | Username of the person who is manually modifying this log record. |
Modify_DT | 4.0.0 | Date | Date when this log record is modified. |
Old_Data | 4.0.0 | Varchar(80) | Data in this object prior to been modified. |
PKID | 4.0.0 | Number(10,0) | ID of the row that this object is associated with, such as StudentID, CCID, etc. Indexed. |
Transaction_Type | 4.0.0 | Varchar(10) | Type of transaction that took place: Delete or Update (no need for inserts). |
UserID | 4.0.0 | Number(10,0) | UserID of the user who is logged in to the application. |