Interaction Administrator Attribute Change Log View
This view contains the specific attribute that was changed, the previous value, and the new value. There may be multiple records in the IAAttributeLog table that are for a single record in the EnhancedIAChangeLog table.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| IAAttributeLogId | int (4) | False | No | Unique ID for the attribute that was changed. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| EnhancedIAChangeLogId | int (4) | False | No | The foreign key to the IAChangeLog table. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| AttributeName | nvarchar (100) | True | No | The name of the attribute that was changed. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| PreviousValue | nvarchar (1850) | True | No | The value before the change was made. This field can contain an empty string. This can happen when the value has never been set before, or if a field was cleared out are a couple of example cases. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| NewValue | nvarchar (1850) | True | No | The new value that was set for the attribute. This field can contain an empty string. This can happen when the value has been cleared out. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| ChangeDateTimeGMT | datetime (8) | False | No | Greenwich Mean Time for when the change was made. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| SiteId | smallint (2) | False | No | Site ID |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| IAATTRIBUTELOGID | number (22) | False | No | Unique ID for the attribute that was changed. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| ENHANCEDIACHANGELOGID | number (22) | False | No | The foreign key to the IAChangeLog table. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| ATTRIBUTENAME | nvarchar2 (200) | True | No | The name of the attribute that was changed. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| PREVIOUSVALUE | nvarchar2 (3700) | True | No | The value before the change was made. This field can contain an empty string. This can happen when the value has never been set before, or if a field was cleared out are a couple of example cases. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| NEWVALUE | nvarchar2 (3700) | True | No | The new value that was set for the attribute. This field can contain an empty string. This can happen when the value has been cleared out. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| CHANGEDATETIMEGMT | timestamp | False | No | Greenwich Mean Time for when the change was made. |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |
| SITEID | number (22) | False | No | Site ID |
17.4.0.0 | Added for data extraction from IAAttributeLog table. |