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

AVEVA™ Historian

SummaryTagList

  • Last UpdatedMar 10, 2025
  • 1 minute read

Contains one row for each combination of a summarized tag and a specific summary operation. This table is used by the Event subsystem; it is not used by the Replication subsystem. This table is a linking table that allows tags to be associated with a type of operation.

Column

Data Type

Description

(PK) SumVarKey

int NOT NULL

The unique numerical identifier for a summarized tag. This value is automatically generated by the system when the summarized tag 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 Tag table.

(FK) OperationKey

int NOT NULL

The unique numerical identifier for the summary operation. OperationKey is a foreign key from the SummaryOperation table.

LowerLimit

float NULL

The lower limit of validity for the tag's value. Values lower than this limit are not used in the calculation. By default, this value is set to ‑1000000000.

UpperLimit

float NULL

The upper limit of validity for the tag's value. Values higher than this limit are not used in the calculation. By default, this value is set to 1000000000.

Description

nvarchar(50) NULL

The description of the summarized tag. This normally describes the result of the operation, although this description can be the same as that of the tag on which the operation is performed.

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