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

AVEVA™ Historian

ManualDiscreteHistory

  • Last UpdatedMar 18, 2021
  • 1 minute read

This table can be used by custom client applications to store values for discrete tags. By default, this table is empty. If written to by a client application, this table will contain one row for each defined discrete tag per sample period. ManualDiscreteHistory is a normal SQL Server table and does not support any of the AVEVA Historian extensions for handling data.

Column

Data type

Description

(PK) DateTime

datetime2(7) NOT NULL

The timestamp reflecting when the data was acquired or stored.

(PK) TagName

TagNameType(nvarchar(256)) NOT NULL

The unique name of the tag within the AVEVA Historian system.

Value

tinyint NULL

The value of the discrete tag at timestamp. 0 = FALSE; 1 = TRUE; NULL = No data.

Quality

tinyint NOT NULL

The basic data quality indicator associated with the data value.

QualityDetail

int NULL

An internal representation of data quality.

wwTagKey

int NOT NULL

The unique numerical identifier of a tag within a single AVEVA Historian.

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