SummaryOperation

(PK) OperationKey

int NOT NULL

The unique numerical identifier for the summary operation. This value is automatically generated by the system when the operation is added.

(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 EventTag table.

(FK) CalcType

CalcTypes
(char(3)) NOT NULL

The type of calculation to be performed: SUM, MAX, MIN, or AVG. CalcType is a foreign key from the CalcType table.

Description

nvarchar(50) NULL

The description of the summary operation.

Duration

real NOT NULL

The period, in seconds, for which the calculation is performed.

Resolution

int NOT NULL

The sampling rate, in milliseconds, for retrieving the data in cyclic mode. The system returns values stored over the requested time period at the interval specified by the resolution. For example, if you specify a 5000 ms resolution, the system queries for all data during the time period and then only returns those values that occur at each 5000 ms interval, starting with the start date and ending with the end date.

TimeStamp

tinyint NOT NULL

The timestamp to use when storing the result of the calculation. The timestamp can be either the time when the calculation period starts or ends. 0 = Beginning of the calculation period; 1 = End of the calculation period.

Frequency

nvarchar(12) NULL

The name for the frequency.

SourceType

varchar(3) NULL

The type of summary, set to 'DYN' (for "dynamic" data). Used for backward compatibility with Industrial Workbook.