Event ModificationAudit table

modificationId

int

This field displays the modification record ID.

valueTypeRefId

int

This field indicates what type of value is involved in the audit (e.g. integer, float, string, enumerated integer, enumerated string).

oldIntValue

int

This field displays the original integer value before the data was edited.

newIntValue

int

This field displays the new integer value the data was changed to.

oldFloatValue

float

This field displays the original float value before the data was edited.

newFloatValue

float

This field displays the new float value the data was changed to.

oldStringValue

eventStringType

This field displays the original string value before the data was edited.

newStringValue

eventStringType

This field displays the new string value the data was changed to.

oldEnumIntValue

int

This field displays the original enumerated integer value before the data was edited.

newEnumIntValue

int

This field displays the new enumerated integer value the data was changed to.

oldEnumStringValue

eventNameType

This field displays the original enumerated string value before the data was edited.

newEnumStringValue

eventNameType

This field displays the new enumerated string value the data was changed to.

modifiedUser

eventNameType

This field displays the name of the Administrator/Controller who performed the modification.

time

GMTtime

This field displays the time of the event in Greenwich Mean Time (GMT).

key2

int

This field is related to datapump support (for internal use only).

datasetId

tagIDType

This field displays the ID of the associated dataset.

ownSysId

tagIDType

This field displays the system ID of the system that owns the event.