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

AVEVA™ Historian

ManualStringHistory

  • Last UpdatedMar 18, 2021
  • 1 minute read

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

Column

Data type

Description

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

nvarchar(512) NULL

The value of the string tag at the timestamp.

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