TagExtendedPropertyInfo

TagName

nvarchar (256) NOT NULL

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

Property
NameKey

int NULL

A unique identifier for the extended tag property name.

Property
Name

nvarchar (256) NOT NULL

The extended tag property name.

PropertyType

int NOT NULL

Specifies a type for this extended tag property.

Property
Value

sql_variant NOT NULL

The value of this replication tag extended property.

Facetable

bit NOT NULL

Specifies whether the extended property can be included in grouped search results. For example, if a user searches for all items containing the string "temp", the search engine could display a list of multiple results.

Searchable

bit NOT NULL

Specifies whether the extended property is searchable.

Substring
Searchable

bit NOT NULL

Specifies whether the name can be located with a substring search.

AttributeTypeName

nvarchar (255) NOT NULL

The name of the attribute type.

AttributeTypeValue

tinyint NOT NULL

The bit mask for the attribute type

Change
Version

timestamp NOT NULL

Internal use only.