Event OperActivitySummary 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 - 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.

dbName

eventNameType

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

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

tinyint

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.

operActivityTypeRefId

int

This field references the operation activity type stored in the OperActivityTypeDefine table.

alarmSourceTypeRefID

int

This field references the alarm source type stored in the AlarmSourceTypeDefine table.

consoleName

eventNameType

This field displays the name of the Controller console associated with the event.

userName

eventNameType

This field displays the name of the Administrator/Controller executing the operation associated with the event.

testModeActive

boolType

This field indicates if this operation is executed on a point that is running in test mode.

Note: A point running in test mode would have its alarms suppressed.

alarmInhibitTypeRefId

int

This field references the alarm inhibit type stored in the alarmInhibitTypeDefine 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.

MOCpackageId

eventNameType

This field displays the ID of the Management of Change (MoC) package associated with the event.