Data Model

Data Model

The following image represents the Data Model for OT Connect.

OT Source: Source of Tags and Tag Value from the Edge

The following table provides a list and description of the fields that exist in the OT Source family and are available on the baseline OT Source datasheet. The information in the table reflects the baseline state and behavior of these fields. If your implementation has been customized, these fields may behave differently, and fields in addition to those listed here may be available.

This family is enabled for site filtering, which means that records in this family can be assigned to a specific site and will then only be accessible to users who are assigned to the same site and have the appropriate license and family privileges. For more information, refer to the Site Filtering section of the documentation.

Field Caption/IDData TypeDescriptionBehavior and Usage
MI_OTSRC_ID_CCharacterUnique IdentifierNone
MI_OTSRC_CONN_DEF_TTextConnection ConfigurationReserved for future use
MI_OTSRC_TYPE_CTypeText

This field is a selection from a predefined list.

Options include OPC HDA and

Simulation

MI_OTSRC_NAME_CCharacterNameNone
MI_OTSRC_LAST_UPDT_DDateLast Update TimeNone
MI_OTSRC_LAST_SYNC_DDateLast Sync TimeNone
MI_OTSRC_SYNC_RATE_NNumericMinutes between Tag SynchronizationsNone
MI_OTSRC_CAPABILITY_NNumericCapabilityBit Flags
MI_OTSRC_SYNC_DEF_TTextSynchronization ConfigurationJSON
MI_OTSRC_SUB_RATE_NNumericDefault Subscription RateNone

Source Tag: Tag definition from Source on the Edge

The following table provides a list and description of the fields that exist in the Source Tag family and are available on the baseline Source Tag datasheet. The information in the table reflects the baseline state and behavior of these fields. If your implementation has been customized, these fields may behave differently, and fields in addition to those listed here may be available.

This family is enabled for site filtering, which means that records in this family can be assigned to a specific site and will then only be accessible to users who are assigned to the same site and have the appropriate license and family privileges. For more information, refer to the Site Filtering section of the documentation.

Field Caption/IDData TypeDescriptionBehavior and Usage
MI_SRCTAG_ID_CCharacterUnique IdentifierNone
MI_SRCTAG_NAME_CCharacterNameUnique name in Process Historian
MI_SRCTAG_DESC_CCharacterDescription
MI_SRCTAG_ITEM_CCharacter-Reserved for future use
MI_SRCTAG_COMMENTS_TTextComments
MI_SRCTAG_UOM_CCharacterUoMReserved for future use
MI_SRCTAG_RAW_UOM_CCharacterRaw UoMUoM string reported by Process historian
MI_SRCTAG_EXT_PROPS_TTextExtended Properties
MI_SRCTAG_DELETED_BBooleanThis Tag was deleted from the OT Source
MI_SRCTAG_DATA_TYPE_CCharacterData Type

This field is a selection from a predefined list.

Options include

Boolean,

Integer,

Decimal,

String,

Timespan,

DateTime

MI_SRCTAG_HS_OTSRC_FK_NNumericOT Source Entity KeyForeign Key to OT Source Records family
MI_SRCTAG_MIGR_FMLY_KEY_CCharacterMigrated Tag Family KeyUsed for upgrade from MI_TAG based families (OPC Tag, GE Tag, AMS Tag)
MI_SRCTAG_MIGR_ENTY_KEY_CCharacterMigrated Tag Entity KeyUsed for upgrade from MI_TAG based families (OPC Tag, GE Tag, AMS Tag)

Content Map: The relationships between content and sources

The following table provides a list and description of the fields that exist in the Content Map family and are available on the baseline Content Map datasheet. The information in the table reflects the baseline state and behavior of these fields. If your implementation has been customized, these fields may behave differently, and fields in addition to those listed here may be available.

Field Caption/IDData TypeDescriptionBehavior and Usage
MI_CONTMAP_ID_CCharacterUnique IdentifierNone
MI_CONTMAP_TMPLT_NAME_CCharacter-Reserved for future use
MI_CONTMAP_UOM_CCharacterUoMReserved for future use
MI_CONTMAP_LMT_DEFS_TTextLimit DefinitionsJSON
MI_CONTMAP_TRIGGER_BBoolean-Reserved for future use
MI_CONTMAP_REQ_CAP_NNumericOT Source Capabilities Required by this Content Bit flags
MI_CONTMAP_EQUIP_FK_NNumericEquipment KeyForeign Key to Equipment Record
MI_CONTMAP_FLOC_FK_NNumericFunctional Location KeyForeign Key to Functional Location Record
MI_CONTMAP_SRCTAG_FK_NNumericSource Tag KeyForeign key to Source Tag record