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

AVEVA™ Historian

aaTimeDetectorDetailInsert

  • Last UpdatedMar 18, 2021
  • 1 minute read

Inserts time detector details that are associated with a specified event tag.

Syntax

aaTimeDetectorDetailInsert FrequencyID, TagName, Periodicity, StartDateTime, RunTimeDay, RunTimeHour, RunTimeMin

where:

Argument

Description

FrequencyID

The unique numerical identifier for the frequency. Used to link a frequency with a time-based detector.

1= Hourl

2 = Daily

3 = Weekly

4 = Monthly

5 = Periodi

6 = Other (Reserved for future use)

This value is of data type int, with no default.

TagName

The unique name of the tag within the AVEVA Historian system. This value is of data type nvarchar(256), with no default.

Periodicity

The interval period in minutes between detector events. Only used for a periodic detection. This value is of data type int, with no default.

StartDateTime

The timestamp from which the time detector starts. Only used for a periodic detection. This value is of data type datetime2(7), with no default.

RunTimeDay

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. This value is of data type tinyint, with no default.

RunTimeHour

The hour of the day at which the time detector triggers. Not used for periodic detections. This value is of data type tinyint, with no default.

RunTimeMin

The minute of the hour at which the time detector triggers. Not used for periodic detections. This value is of data type tinyint, with no default.

Permission

Execute permission defaults to the aaPowerUsers and aaAdministrators groups.

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