ModLogColumn
- Last UpdatedMar 10, 2025
- 1 minute read
Contains one row for each database column on which an INSERT, UPDATE, or DELETE has been performed.
|
Column |
Data Type |
Description |
|---|---|---|
|
(FK) ModTableKey |
int NOT NULL |
The unique numerical identifier for the modification. ModTableKey is a foreign key from the ModLogTable table. |
|
ColumnName |
nvarchar(30) NOT NULL |
The name of the modified column. |
|
OldValue |
sql_variant NULL |
The value stored in the column before the modification was made, if the modification was to a configuration table. For modifications to history data using SQL INSERT and UPDATE statements, this column contains the timestamp of the earliest data affected by the INSERT or UPDATE operation. If multiple changes are made to the same data, then only the most recent change will be contained in this column. This column is not used for modifications made to history data using a CSV file. |
|
NewValue |
sql_variant NULL |
The new value stored in the column, if the modification was to a configuration table. For modifications to history data, this column contains the total count of consecutive value updates attempted. |