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

AVEVA™ Historian

ReplicationTagExtendedPropertyInfo

  • Last UpdatedMar 10, 2025
  • 2 minute read

Contains one entry for each replicated tag extended property.

Column

Data Type

Description

ReplicationTag
ExtendedProperty
Key

int NOT NULL

A unique identifier for the replication tag extended property.

ReplicationServer
Key

int NOT NULL

The unique identifier for the replication server.

DestinationTag
Name

nvarchar (256) NOT NULL

The name of the destination tag. If the destination tag name is not specified, it is generated based on the naming convention for the replication tag and stored in the database.

ReplicationTagEntityKey

int NOT NULL

The unique identifier for the replication tag entity.

SourceTagName

nvarchar (256) NOT NULL

The unique name for the source tag.

PropertyNameKey

int NULL

A unique identifier for the extended tag property name.

PropertyName

nvarchar (256) NOT NULL

The extended tag property name.

PropertyType

int NOT NULL

Specifies a type for this extended tag property.

PropertyValue

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.

SubstringSearchable

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

ChangeVersion

timestamp NOT NULL

Internal use only.

Status

tinyint NOT NULL

Automatically updated by the system if a change is made to the replication group:
0 = No change; 1 = Insertion;
2 = Modification; 3 = Deletion.

Related Links
TitleResults for “How to create a CRG?”Also Available in