TimeDetectorDetail

(PK) TimeDetectorDetailKey

int NOT NULL

The unique numerical identifier for each time-based event tag. This value is automatically generated by the system when a time-based event tag is created.

(FK) FrequencyID

int NOT NULL

The unique numerical identifier for the frequency. Used to link a frequency with a time-based detector. 1= Hourly; 2 = Daily; 3 = Weekly; 4 = Monthly; 5 = Periodic; 6 = Other (Reserved for future use). FrequencyID is a foreign key from the Frequency table.

(FK) TagName

TagNameType
(nvarchar(256)) NOT NULL

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

Periodicity

int NULL

The interval period in minutes between detector events. Only used for a periodic detection.

StartDateTime

datetime2(7) NULL

The timestamp from which the time detector starts. Only used for a periodic detection.

RunTimeDay

tinyint NULL

In the context of a weekly detector, RunTimeDay maps the week day number (0 = Sunday – 6 = Saturday). In the context of a monthly detector, RunTimeDay maps to the day of the month. Not used for periodic detections.

RunTimeHour

tinyint NULL

The hour of the day at which the time detector triggers. Not used for periodic detections.

RunTimeMin

tinyint NULL

The minute of the hour at which the time detector triggers. Not used for periodic detections.