HistoryBlock (INSQL​.Runtime​.dbo​.HistoryBlock)

FromDate

datetime2(7) NOT NULL

The starting timestamp for the history block.

ToDate

datetime2(7) NOT NULL

The ending timestamp for the history block.

StorageNodeKey

int NOT NULL

The unique numerical identifier for the storage node.

Description

nvarchar(50) NULL

The description of the history block.

OnLine

tinyint NOT NULL

Deprecated.

HistoryArchived

int NOT NULL

Used to indicate whether or not the history block has been archived (backed up). 1 = No status; 2 = Archived; 3 = Restored; 4 = Deleted. Reserved for future use.

SummaryArchived

int NOT NULL

Used to indicate whether or not the tag summary has been archived (backed up). 1 = No status; 2 = Archived; 3 = Restored; 4 = Deleted. Reserved for future use.

EventArchived

int NOT NULL

Used to indicate whether or not the event has been archived (backed up). 1 = No status; 2 = Archived; 3 = Restored; 4 = Deleted. Reserved for future use.

StorageAreaType

int NOT NULL

The paradigm used for storage. 1 = Circular; 2 = Alternate; 3 = Buffer; 4 = Permanent. Reserved for future use.

ArchiveDate

datetime2(7) NULL

The date at which the history block was archived. Reserved for future use.

ArchiveLocation

nvarchar(50) NULL

The location to which the history block was archived. Reserved for future use.

Version

int NULL

The version number for the history block. 1 = Block format used until release 3.0; 2 = Block format used for releases 3.0 and later. Reserved for future use.

Compression

int NULL

The version number for cyclic compression. 1 = No compression; 2 = Huffman encoding. Reserved for future use.

Sequence

int NOT NULL

The sequence number for the data stream. (1...n) Reserved for future use.

TimeZoneOffset

int NULL

The UTC offset, in minutes, from the local timestamp for when the history block was created. For example, a value of 480 would indicate an 8-hour offset from UTC, which would be Pacific Standard Time.

wwTimeZone

nvarchar(50) NULL

Used to specify the time zone for retrieval. By default, the retrieval subsystem converts the UTC (Universal Time Coordinated) timestamps for the stored data to the local time of the AVEVA Historian computer, including adjustments for daylight savings time. To keep the timestamps in UTC, set the value of wwTimeZone to UTC. To convert the timestamps to a client computer's time zone, set this parameter to the appropriate time zone text key from the TimeZone table.