AnalogTag

(PK) (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) EUKey

int NOT NULL

The unique numerical identifier of an engineering unit. EUKey is a foreign key from the EngineeringUnit table.

MinEU

float NOT NULL

The minimum value of the tag, measured in engineering units.

MaxEU

float NOT NULL

The maximum value of the tag, measured in engineering units.

MinRaw

float NULL

The minimum value of the raw acquired value.

MaxRaw

float NULL

The maximum value of the raw acquired value.

Scaling

int NOT NULL

The type of algorithm used to scale raw values to engineering units. For linear scaling, the result is calculated using linear interpolation between the end points. 0 = None; 1 = Linear; 2 = Square Root. (Square root is reserved for future use).

RawType

int NOT NULL

The numeric type for the raw value. 1 = Euro Float, an outdated data type (4 bytes); 2 = MS Float (4 bytes); 3 = Integer (2 or 4 bytes); 4 = MS Double (reserved for future use) (8 bytes).

ValueDeadband

float NOT NULL

The percentage of the difference between the minimum and maximum engineering units for the tag. Any data values that change less than the specified deadband are not stored. The value deadband applies to delta storage only. A value of 0 indicates that a value deadband will not be applied.

IntegerSize

tinyint NOT NULL

The bit size of the analog tag. 12 = 12-bit; 15 = 15-bit; 16 = 16-bit; 32 = 32-bit; 64 = 64-bit (reserved for future use).

SignedInteger

bit NOT NULL

Used to specify whether an integer is a signed number (positive or negative) or an unsigned number (positive only). 0 = Unsigned; 1 = Signed.

RateDeadband

float NOT NULL

The percentage of deviation in the full-scale value range for an analog tag. The swinging door (rate) deadband applies to delta storage only. Time and/or value deadbands can be used in addition to the swinging door deadband. Any value greater than 0 can be used for the deadband. A value of 0 indicates that a swinging door deadband will not be applied.

InterpolationType

tinyint NOT NULL

The interpolation type for retrieval. 0 = Stair-stepped interpolation; 1 = Linear interpolation (if applicable, based on the tag type); 254 = System default interpolation mode. The system default interpolation type is to use the system default for the analog type, either integer or real. The system default interpolation type for an analog type is determined by the setting of the InterpolationTypeInteger and InterpolationTypeReal system parameters. This setting impacts Interpolated, Average, and Integral retrieval modes.

RolloverValue

float NOT NULL

The first value that causes the counter to "roll over." This rollover value is used by the "counter" retrieval mode. For example, a counter that counts from 0 to 9999, the counter rolls over back to 0 for the 10,000th value it receives. Therefore, set the rollover value to 10,000.