Event dataModEventKeys table

time

GMTtime

This field displays the time of the event in GMT.

msec

int

This field displays the millisecond section of the time.This field equals zero unless the Remote Terminal Unit (RTU) provides millisecond timestamp resolution. The msec field is used to determine sequence-of-events.

offset

GMToffset

The difference (in minutes) between local time and Coordinated Universal Time (UTC) when the time field was populated.

type

eventNameType

This field displays the type of the event. An event is one of the following types:

• Control - results from an action of the user Alarm.

• Alarm - results from an alarm.

• Event - results from an event that is neither a Control nor Alarm.

host

eventNameType

This field displays the name of the host associated with the event.

process

eventNameType

This field displays the name of the application or process associated with the event.

serviceName

eventNameType

This field displays the name of the originating service (for example, RealTime, Historical).

dbName

eventNameType

This field displays the name of the database associated with the event.

tableName

eventNameType

This field displays the name of the table associated with the event.

columnName

eventNameType

This field displays the name of the table column associated with the event.

ptName

eventNameType

This field displays the name of the point associated with the event.

message

eventStringType

This field displays the text used for the event’s message.

spooler

tinyint

This field displays the spooler number that is associated with groupName.

auditReason

eventStringType

This field displays the reason the data modification was performed.

modifiedDataTime

GMTtime

This field displays the time in seconds that the data modification was performed.

modifiedDataOffset

GMToffset

This field displays the difference (in minutes) between local time and UTC when the modifiedDataTime field was populated.

modifiedUser

eventNameType

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

valueTypeId

int

This field references the value type from the valueTypeDefine table.

oldIntValue

int

This field displays the integer value before modification.

newIntValue

int

This field displays the integer value after modification.

oldFloatValue

float

This field displays the float value before modification.

newFloatValue

float

This field displays the float value after modification.

oldStringValue

eventStringType

This field displays the string value before modification.

newStringValue

eventStringType

This field displays the string value after modification.

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.