Event dataModSummary table

time

GMTtime

This field displays the time of the event in Greenwich Mean Time (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 the action of the user.

• Alarm - results from an alarm

• Event - results from an event that is neither a Control nor an 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.

description

eventDescType

This field displays the description of the ptName.

rtuName

eventNameType

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

groupName

eventNameType

This field displays the name of the group to which rtuName belongs. Some events are not associated with a group. Events generated as part of the computer processing structure, such as those due to a Central Processing Unit (CPU) failure, are identified by the computer name in the host field. Events generated as part of a computer application, such as those generated by the execution of a C routine, are identified by the process or application name in the process field.

message

eventStringType

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

fgInt

tinying

This field displays the foreground color used for the event’s message.

sevInt

tinyint

This field displays the message severity associated with the event. Details about message severity is taken from the associated RealTime database (RTDB) message table.

key1

int

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

key2

int

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

spooler

tinyint

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

hasNote

boolType

This field indicates if there are Controller notes associated with the event.

modifiedData

Time

GMTtime

This field indicates the time when the data was modified (GMT).

modifiedData

Offset

GMToffset

This field indicates the offset to local time zone that was in effect when the data was modified.

modification

RefId

int

This field references the modification record information stored in the ModificationAudit table.

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.