Live (INSQL​.Runtime​.dbo​.Live)

DateTime

datetime2(7) NOT NULL

The timestamp reflecting when the data last changed.

TagName

nvarchar(256) NOT NULL

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

Value

float NULL

The value of the tag at date/time. This value is always NULL for string tags.

vValue

nvarchar(256) NULL

The value of the analog, discrete, or string tag stored as a sql_variant. Using this column in a query allows you to have values with mixed datatypes as a result.

Quality

tinyint NOT NULL

The basic data quality indicator associated with the data value.

QualityDetail

int NULL

An internal representation of data quality.

OPCQuality

int NULL

The quality value received from the data source.

wwTagKey

int NOT NULL

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

wwRetrievalMode

nvarchar(16) NULL

For queries against this table, the value of this column is ignored.

wwTimeDeadband

int NULL

For queries against this table, the value of this column is ignored.

wwValueDeadband

float NULL

For queries against this table, the value of this column is ignored.

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.

wwParameters

nvarchar(128) NULL

Used for additional parameters that can be specified. By default, the value of this parameter is an empty string.

SourceTag

nvarchar(256) NULL

Returns the name of the source tag for a replicated tag at the time this point was stored. With the SourceServer, this column uniquely identifies the tag from which this replicated point is coming.

SourceServer

nvarchar(256) NULL

Returns the name of the server from which replication occurred for this replicated tag at the time this point was stored.

wwValueSelector

nvarchar(128) NOT NULL

Used to specify which column to return for specified analog summary tags in the four basic retrieval modes, DELTA, FULL, CYCLIC, and INTERPOLATED. The defined set of selectors are AUTO (the default in all modes if not overridden), MINIMUM or MIN, MAXIMUM or MAX, FIRST, LAST, AVERAGE or AVG, and INTEGRAL. The default AUTO setting returns the Last attribute in the Value column (which makes it accessible in the WideHistory table). You can only override the selector for the basic retrieval modes.

wwExpression

nvarchar(4000) NULL

Used to specify an expression for unit of measure conversion, specified in the following format using tag/unit pairs:

UOM(TAG1,UNIT1;TAG2,UNIT2;...)

For example, the expression UOM(DistanceTag,m;TempTag,F;DurationTag,Minute)returns the values for the tag named DistanceTag measured in meters, the values for TempTag measured in degrees Farenheit, and the values for DurationTag measured in minutes.

The following rules apply:

1. If any of the unit conversions specified are invalid and fail (for example, trying to convert a tag measured in meters to a unit of hours) then no unit conversions are performed.

2. If any tags specified in the expression for unit conversion are not part of the query, those tags will be ignored for the purpose of unit conversion.

wwUnit

nvarchar(512) NULL

Returns the currently used unit of measure.