Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

AVEVA™ Historian

EventHistory

  • Last UpdatedMar 10, 2025
  • 1 minute read

Contains one row for each stored event, as labeled by the tagname. Event data must be configured to be logged into this table.

Column

Data Type

Description

(PK) EventLogKey

int NOT NULL

The unique numerical identifier of an event occurrence. This value is automatically generated by the system when the event record is added.

(FK) TagName

TagNameType
(nvarchar(256)) NULL

The unique name of the tag within the AVEVA Historian system. TagName is a foreign key from the EventTag table.

DateTime

datetime2(7) NOT NULL

The timestamp reflecting when event history data was acquired. This is the time when an event actually occurred. This time reflects the time zone of the AVEVA Historian.

DetectDateTime

datetime2(7) NOT NULL

The timestamp reflecting when the event was detected by the event system.

Edge

tinyint NULL

The "edge" for the event detection. 0 = Trailing; 1 = Leading; 2 = Both; 3 = None; 4 = Time Detector; 5 = External Detector.

Related Links
TitleResults for “How to create a CRG?”Also Available in