Database Tables and Columns

Overview
Database Tables
MDM_ATTRS Columns
MDM_ATTR_ACCESS Columns
MDM_ATTR_DATATYPES Columns
MDM_ATTR_DISPLAY Columns
MDM_ATTR_PROFILES Columns
MDM_CLUSTER_CONDITIONS Columns
MDM_CLUSTER_CRITERIA Columns
MDM_CLUSTER_MAPPING Columns
MDM_CLUSTER_MEMBER_HISTORY Columns
MDM_ENTITY_CLUSTERS Columns
MDM_ENTITY_REL Columns
MDM_ENTITY_REL_CONDITIONS Columns
MDM_ENTITY_REL_TYPES Columns
MDM_ENTITY_TYPES Columns
MDM_ENTITY_TYPE_ACCESS Columns
MDM_ENTITY_TYPE_INDICES Columns
MDM_ENTITY_TYPE_SRC Columns
MDM_ENTITY_TYPE_TOOLS Columns
MDM_ERROR_LOG Columns
MDM_EXTRACT_TOKEN Columns
MDM_FORCED_CLUSTERS Columns
MDM_HIERARCHY_LEVELS Columns
MDM_HIERARCHY_TYPES Columns
MDM_NAMED_HIERARCHIES Columns
MDM_LANGUAGES Columns
MDM_PROCESS_CONTROL Columns
MDM_REL_ATTRS Columns
MDM_REL_ATTR_PROFILES Columns
MDM_REMEDIATION_ATTRS Columns
MDM_SRC_SYS Columns
MDM_SRC_SYS_TOOLS Columns
MDM_SRC_SYS_TOOL_ACCESS Columns
MDM_STAGING Columns
MDM_TOOL_ACCESS Columns

Overview

This section includes a listing of database tables and a description of the columns for each table.
Note: The following data types are for an Oracle hub. Equivalent data types are used for a SQL Server hub.

Database Tables

Database Tables
Table
Description
Contains a complete list of all attribute metadata for each entity type.
Specifies the available attribute data types.
Specifies the access control for attributes.
Contains display parameters for combinations of entity type and attribute type.
Contains a list of localized attribute profile names.
Maintains a list of cluster conditions for each entity type.
Maintains a list of attributes for each cluster condition.
Maintains cluster collapse information.
Maintains a history of cluster members for move and collapse scenarios.
Identifies clusters uniquely and the names by which they are known.
Maintains authored relationships between clusters.
Contains a list of conditions for entity type relationships.
Contains a list of relationships between entity types.
Specifies the entity types that are covered in the hub, such as COMPANY or PART.
Specifies the access control for entity types.
Contains list of indices to be maintained on entity type specific tables such as MDM_<entity_type>_TT, MDM_<entity_type>_ST, MDM_<entity_type>_CC.
Contains list of entity type and source system associations.
Contains list of tools by entity type.
Contains data about errors that occur within the stored procedures used by Master Data Management.
Maintains list of last token values extracted for each entity type – source system association.
Maintains a list of records that are moved from one cluster to another.
Contains hierarchy level details for hierarchy types.
Contains hierarchy type associations with entity types.
Contains list of named hierarchies added by user.
Specifies the list of configured languages.
Maintains process control tracks for load-update processes in the hub.
Contains attribute list for relationship types.
Contains list of localized relationship attribute profiles
Contains a list of remediation attributes for each entity type.
Specifies list of all source systems that feed the hub.
Contains a list of tools available for each entity type-source system association.
Specifies access control for source system tools.
Stages non-user attribute data before making it live in the hub.
Specifies access control for entity type tools.

MDM_ATTRS Columns

The MDM_ATTRS table contains a complete list of all attribute metadata for each entity type.
The information in the attribute definition is used to construct a column of the same name, with the data type, length (if any), and constraints as indicated by the metadata. In order for the entity type to be published successfully, the attribute name must be compatible with any restrictions imposed by the underlying database.
If you loaded localized metadata, the MDM_ATTRS table includes additional columns for the labels that appear in SAS MDM (MDM_DEF_ATTR_LABEL and MDM_ATTR_DESC). These column names are postfixed with the locale name. For example, if you loaded the French metadata, the table includes MDM_DEF_ATTR_LABEL_FRFRA and MDM_ATTR_DESC_FRFRA columns.
MDM_ATTRS Columns
Name
Data Type
Null Option
Description
MDM_ATTR_ID
INTEGER
NOT NULL
Unique attribute identifier. Automatically generated by SAS MDM.
MDM_OPSEQ
INTEGER
NULL
Sequence for optimistic locking.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Attribute entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_ATTR_NAME
VARCHAR2(30)
NOT NULL
Descriptive attribute name.
MDM_ATTR_PROFILE_ID
INTEGER
NULL
Unique profile identifier. Constrained by MDM_ATTR_PROFILES table.
MDM_ATTR_DATATYPE_ID
INTEGER
NOT NULL
Attribute data type identifier. Constrained by MDM_ATTR_PROFILES table.
MDM_ATTR_LENGTH
INTEGER
NULL
Maximum size of the attribute. A nonzero value is required for string and list data types.
MDM_ATTR_CONSTRAINT
VARCHAR2(200)
NULL
Lists or regex strings used for validation of Master Data Management input fields used to populate the attribute. Can be blank.
MDM_REQUIRED
CHAR(1)
NOT NULL
Indicates whether the attribute is required for the entity type with which it is associated. Enter Y to specify that the attribute is required.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIME ZONE
NOT NULL
Date and time at which the attribute is published for the first time. Automatically generated by SAS MDM.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIME ZONE
NOT NULL
Date and time at which the attribute is retired. Automatically generated by Master Data Management.
MDM_READONLY_FLAG
CHAR(1)
NOT NULL
Indicates whether the attribute can be modified from Master Data Management. Enter Y to specify that the attribute cannot be modified.
MDM_PARENT_ATTR_ID
INTEGER
NULL
Indicates parent ID for attribute relationships.
MDM_ENCRYPT_FLAG
CHAR(1)
NOT NULL
Indicates whether the attribute should be encrypted in the transpose table.

MDM_ATTR_ACCESS Columns

The MDM_ATTR_ACCESS table is an access control table for attributes.
MDM_ATTR_ACCESS Columns
Name
Data Type
Null Option
Description
MDM_ATTR_GROUP_ID
INTEGER
NOT NULL
Unique identifier for attribute group.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Unique entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_ATTR_ID
INTEGER
NOT NULL
Unique attribute identifier. Constrained by MDM_ATTRS table.
MDM_GROUP
NVARCHAR
NULL
Name of the access group.
MDM_ACTIVE
CHAR(1)
NOT NULL

MDM_ATTR_DATATYPES Columns

The MDM_ATTR_DATATYPES table is a constraining table for the available attribute data types.
MDM_ATTR_DATATYPES Columns
Name
Data Type
Null Option
Description
MDM_ATTR_DATATYPE_ID
INTEGER
NOT NULL
Unique attribute data type identifier.
MDM_ATTR_DATATYPE
VARCHAR2(50)
NOT NULL
Name of the data type.
MDM_ATTR_DATATYPE_LABEL
NVARCHAR2(50)
NULL
Human-readable name of the data type.
MDM_DB_DATATYPE
VARCHAR2(50)
NOT NULL
DBMS-specific data type for the data type. For example, string attributes are created as VARCHAR columns in SQL Server, but are created as VARCHAR2 columns in Oracle.

MDM_ATTR_DISPLAY Columns

The MDM_ATTR_DISPLAY table contains display parameters for combinations of entity type and attribute type.
MDM_ATTR_DISPLAY Columns
Name
Data Type
Null Option
Description
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Attribute entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_ATTR_ID
INTEGER
NOT NULL
Attribute identifier. Constrained by MDM_ATTRS table.
MDM_SEARCH_DISPLAY_ORDER
INTEGER
NULL
Display order of the attribute in the search form on the Master Data Management tab. Enter 0 (zero) to hide the attribute in the Master Data Management tab.
MDM_TABLE_DISPLAY_ORDER
INTEGER
NULL
Attribute order for displaying search results.
MDM_CLUSTER_DISPLAY_ORDER
INTEGER
NULL
Display order of the attribute on the Cluster Members tab of the Master Data Management entity editor.
MDM_FORM_DISPLAY_ORDER
INTEGER
NULL
Display order of the attribute in the Master Data Management entity editor.
MDM_PREVIEW_DISPLAY_ORDER
INTEGER
NULL
Display order of the attribute in the Master Data Management Details panels.

MDM_ATTR_PROFILES Columns

The MDM_ATTR_PROFILES table contains a list of localized attribute profile names.
If you have loaded localized metadata, the MDM_ATTR_PROFILES table includes additional columns for the labels that appear in SAS MDM (MDM_ATTR_PROFILE_NAME). These column names are postfixed with the locale name. For example, if you have loaded the French metadata, the table includes an MDM_ATTR_PROFILE_NAME_FRFRA column.
MDM_ATTR_PROFILES Columns
Name
Data Type
Null Option
Description
MDM_ATTR_PROFILE_ID
INTEGER
NOT NULL
Unique profile identifier. Automatically generated by SAS MDM.

MDM_CLUSTER_CONDITIONS Columns

The MDM_CLUSTER_CONDITIONS table maintains a list of cluster conditions for each entity type.
MDM_CLUSTER_CONDITIONS Columns
Name
Data Type
Null Option
Description
MDM_CLUSTER_CONDITION_ID
INTEGER
NOT NULL
Unique cluster condition identifier.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Cluster condition entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_SORT_ORDER
INTEGER
NOT NULL
Sort order of cluster condition for an entity type.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIME ZONE
NULL
Start of validity for cluster condition.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIME ZONE
NULL
End of validity for cluster condition.

MDM_CLUSTER_CRITERIA Columns

The MDM_CLUSTER_CRITERIA table maintains a list of attributes for each cluster condition.
MDM_CLUSTER_CRITERIA Columns
Name
Data Type
Null Option
Description
MDM_CLUSTER_CONDITION_ID
INTEGER
NOT NULL
Unique cluster condition identifier.
Constrained by MDM_CLUSTER_CONDITIONS table.
MDM_ATTR_ID
INTEGER
NOT NULL
Cluster condition attribute identifier. Constrained by MDM_ATTRS table.

MDM_CLUSTER_MAPPING Columns

The MDM_CLUSTER_MAPPING table maintains cluster collapse information.
MDM_CLUSTER_MAPPING Columns
Name
Data Type
Null Option
Description
ORIGINAL_CLUSTER_ID
INTEGER
NOT NULL
Unique cluster identifier that is retired in the process of collapse.
CURRENT_CLUSTER_ID
INTEGER
NOT NULL
Unique cluster identifier into which the records are collapsed.

MDM_CLUSTER_MEMBER_HISTORY Columns

The MDM_CLUSTER_MEMBER_HISTORY table maintains a history of cluster members for move and collapse scenarios.
MDM_CLUSTER_MEMBER_HISTORY Columns
Name
Data Type
Null Option
Description
MDM_ENTITY_CLUSTER_ID
INTEGER
NOT NULL
Unique cluster identifier to which the entity ID belonged.
MDM_ENTITY_ID
INTEGER
NOT NULL
Unique entity identifier.
MDM_COMMENT
NVARCHAR2(200)
NULL
Comment on the history of the record.
MDM_REASON
CHAR(1)
NOT NULL
Reason code: C for cluster collapse, or M for moved records.
MDM_MODIFIED_DTTM
TIMESTAMP WITH LOCAL TIME ZONE
NOT NULL
Date and time of modification for the record.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIME ZONE
NULL
End of validity.

MDM_ENTITY_CLUSTERS Columns

The MDM_ENTITY_CLUSTERS table uniquely identifies clusters and the names by which they are known.
MDM_ENTITY_CLUSTERS Columns
Name
Data Type
Null Option
Description
MDM_ENTITY_CLUSTER_ID
INTEGER
NOT NULL
Unique entity cluster identifier.
MDM_ENTITY_CLUSTER_NAME
NVARCHAR2(100)
NOT NULL
Entity cluster name.
MDM_CLUSTER_TYPE
CHAR(1)
NOT NULL
Cluster type: natural or forced. Natural clusters are constructed solely by the clustering rules expressed in the jobs. Forced clusters are generated by users moving records into the cluster.

MDM_ENTITY_REL Columns

The MDM_ENTITY_REL table maintains authored relationships between clusters.
MDM_ENTITY_REL Columns
Name
Data Type
Null Option
Description
MDM_ENTITY_REL_TYPE_ID
INTEGER
NOT NULL
Entity type relationship identifier. Constrained by MDM_ENTITY_REL_TYPES table.
MDM_FROM_CLUSTER_ID
INTEGER
NOT NULL
Unique cluster identifier. Constrained by MDM_ENTITY_CLUSTERS table.
MDM_TO_CLUSTER_ID
INTEGER
NOT NULL
Unique cluster identifier. Constrained by MDM_ENTITY_CLUSTERS table.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NOT NULL
Start of validity for relationship.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NOT NULL
End of validity for relationship.

MDM_ENTITY_REL_CONDITIONS Columns

The MDM_ENTITY_REL_CONDITIONS table contains a list of conditions for entity type relationships.
MDM_ENTITY_REL_CONDITIONS Columns
Name
Data Type
Null Option
Description
MDM_ENTITY_REL_TYPE_ID
INTEGER
NOT NULL
Entity type relationship identifier. Constrained by MDM_ENTITY_REL_TYPES table.
MDM_ENTITY_REL_CONDITION_ID
INTEGER
NOT NULL
Unique entity relationship condition identifier.
MDM_FROM_ATTR_ID
INTEGER
NOT NULL
Unique attribute identifier. Constrained by MDM_ATTRS table.
MDM_TO_ATTR_ID
INTEGER
NOT NULL
Unique attribute identifier. Constrained by MDM_ATTRS table.

MDM_ENTITY_REL_TYPES Columns

The MDM_ENTITY_REL_TYPES table contains a list of relationships between entity types.
If you have loaded localized metadata (see Localization Configuration), the MDM_ENTITY_REL_TYPES table includes additional columns for the labels that appear in SAS MDM (MDM_REL_TYPE_DESC, MDM_REL_TYPE_LABEL, and MDM_INV_REL_TYPE_LABEL). These column names are postfixed with the locale name of the localized metadata. For example, if you have loaded the French metadata, the table includes MDM_REL_TYPE_DESC_FRFRA, MDM_REL_TYPE_LABEL_FRFRA, and MDM_INV_RELTYPE_LABEL_FRFRA columns.
MDM_ENTITY_REL_TYPES Columns
Name
Data Type
Null Option
Description
MDM_ REL_TYPE_ID
INTEGER
NOT NULL
Entity type relationship identifier.
MDM_REL_TYPE
VARCHAR2(50)
NOT NULL
Entity type relationship name.
MDM_SORT_ORDER
INTEGER
NULL
Sort order of relationship type.
MDM_INVERSE_SORT_ORDER
INTEGER
NULL
Inverse sort order of relationship type.
MDM_FROM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Unique entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_TO_ENTITY_TYPE_ID
INTEGER
NOT NULL
Unique entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Start of validity for relationship type.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
End of validity for relationship type.

MDM_ENTITY_TYPES Columns

The MDM_ENTITY_TYPES table is a constraining table for the entity types that are covered in the hub, such as COMPANY or PART.
If you have loaded localized metadata (see Localization Configuration), the MDM_ENTITY_TYPES table includes additional columns for the labels that appear in SAS MDM (MDM_ENTITY_TYPE_LABEL and MDM_ENTITY_TYPE_DESC). These column names are postfixed with the locale name. For example, if you have loaded the French metadata, the table includes MDM_ENTITY_TYPE_LABEL_FRFRA and MDM_ENTITY_TYPE_DESC_FRFRA columns.
MDM_ENTITY_TYPES Columns
Name
Data Type
Null Option
Description
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Unique entity type identifier. Automatically generated by Master Data Management.
MDM_QPSEQ
INTEGER
NULL
Sequence for optimistic locking.
MDM_ENTITY_TYPE
VARCHAR2(23)
NOT NULL
Entity type name (for example, COMPANY or PART).
MDM_ENTITY_TYPE_SORT_ORDER
INTEGER
NOT NULL
Controls the entity type's sort order in Master Data Management selection lists. Enter zero (0) to hide the entity type in the Master Data Management.
MDM_LAST_MOD_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Date and time at which the entity type was last modified. Automatically generated by Master Data Management. Use this attribute in combination with MDM_GOLIVE_DTTM to determine whether the metadata has changes that have not been applied to the hub.
MDM_GOLIVE_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Date and time at which entity type is made live. Automatically generated by Master Data Management.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Date and time at which entity type is first published. Automatically generated by Master Data Management.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Date and time at which entity type is retired. Automatically generated by Master Data Management.
MDM_PARENT_ID
INTEGER
NULL
Unique tree identifier of the parent. Constrained by MDM_ENTITY_TYPES table.
MDM_ABSTRACT
CHAR(1)
NOT NULL
Flag indicating if the entity type is abstract or not.
MDM_LABEL_ATTR_ID
NUMBER
No value
Identifier of the label attribute for this entity type.

MDM_ENTITY_TYPE_ACCESS Columns

The MDM_ENTITY_TYPE_ACCESS table contains access control list for entity types.
MDM_ENTITY_TYPE_ACCESS
Name
Data Type
Null Option
Description
MDM_ENTITY_GROUP_ID
INTEGER
NOT NULL
Entity type group identifier.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_GROUP
NVARCHAR
NULL
Group name.
MDM_ACTIVE
CHAR(1)
NOT NULL
Entity type access active indicator.

MDM_ENTITY_TYPE_INDICES Columns

The MDM_ENTITY_TYPE_INDICES table contains the list of custom indices created on ST, TT, and CC tables.
MDM_ENTITY_TYPE_INDICES
Name
Data Type
Null Option
Description
MDM_ENTITY_TYPE
VARCHAR2(23)
NOT NULL
Entity type name.
MDM_ATTR_NAME
VARCHAR2(30)
NOT NULL
Attribute name.
MDM_INDEX_ID
INTEGER
NOT NULL
Index identifier for entity type.
MDM_INDEX_COLUMN_ORDER
INTEGER
NOT NULL
Order of column in the index.

MDM_ENTITY_TYPE_SRC Columns

The MDM_ENTITY_TYPE_SRC table contains list of entity types contributed by source systems.
MDM_ENTITY_TYPE_SRC Columns
Name
Data Type
Null Option
Description
ENTITY_TYPE_SRC_ID
INTEGER
NOT NULL
Entity type source identifier.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Entity type identifier, constrained by MDM_ENTITY_TYPES table.
MDM_SRC_SYS_ID
INTEGER
NOT NULL
Source system identifier, constrained by MDM_SRC_SYS table.
MDM_ACTIVE
CHAR(1)
NOT NULL
Entity type source active indicator.
PULL_OPTION
CHAR(1)
NOT NULL
Pull option indicator.
PUSH_OPTION
CHAR(1)
NOT NULL
Push option indicator.

MDM_ENTITY_TYPE_TOOLS Columns

The MDM_ENTITY_TYPE_TOOLS table contains the list of tools for each entity type.
MDM_ENTITY_TYPE_TOOLS
Name
Data Type
Null Option
Description
TOOL_ID
INTEGER
NOT NULL
Tool identifier.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Entity type identifier.
TOOL
VARCHAR2(260)
NOT NULL
Tool name.
TOOL_SORT_ORDER
INTEGER
NOT NULL
Sort order for tool.
TOOLTYPE
CHAR(1)
NOT NULL
Type identifier for the tool. D for data job, P for process job, and B for batch job.
CARDINALITY
CHAR(1)
NOT NULL
Expected input cardinality (S-M-L).
RESULTTYPE
CHAR(1)
NOT NULL
Type of result being returned. Valid result types are Status (S), Batch status (B), URL (U), Table (T), and Attribute value (A).
CONTACT
NVARCHAR2(513)
NULL
Contact for the tool.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Start of validity for the tool.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
End of validity for the tool.

MDM_ERROR_LOG Columns

The MDM_ERROR_LOG table contains data about errors that occur within the stored procedures used by Master Data Management.
MDM_ERROR_LOG Columns
Name
Data Type
Null Option
Description
MDM_ERROR_LOG_ID
INTEGER
NOT NULL
Unique error log record identifier.
TABLE_NAME
VARCHAR2(50)
NULL
Name of table in which error occurred.
SERVICE_NAME
VARCHAR2(50)
NULL
Name of service in which error occurred.
RECORD_ID
INTEGER
NOT NULL
Identifier of record in which error occurred.
RECORD_ID_FROM
VARCHAR2(30)
NULL
Identifier of record from which error was generated.
ERROR_SOURCE
VARCHAR2(100)
NOT NULL
Name of source (service, stored procedure, window) where error originated.
ERROR_CODE
VARCHAR(10)
NOT NULL
Database-generated error code.
ERROR_MESSAGE
VARCHAR2(1000)
NULL
Database-generated error message.
ERROR_DATE
TIMESTAMP WITH LOCAL TIMEZONE
NOT NULL
Date when error log record was added.

MDM_EXTRACT_TOKEN Columns

The MDM_EXTRACT_TOKEN table maintains token value for extracting entity type data from a source system used to support incremental data load.
MDM_EXTRACT_TOKEN Columns
Name
Data Type
Null Option
Description
MDM_EXTRACT_TOKEN_ID
INTEGER
NOT NULL
Unique extract token identifier.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Entity type identifier.
MDM_SRC_SYS_ID
INTEGER
NOT NULL
Source system identifier.
EXTRACT_TOKEN_FIELD
NVARCHAR2(50)
NULL
Field to use as the extract token.
EXTRACT_TOKEN_TYPE
NVARCHAR2(30)
NULL
Type of extract token.
LAST_TOKEN_VALUE
NVARCHAR2(100)
NULL
Value of last token.

MDM_FORCED_CLUSTERS Columns

The MDM_FORCED_CLUSTERS table maintains list of records that are moved from one cluster to another.
MDM_FORCED_CLUSTERS Columns
Name
Data Type
Null Option
Description
ORIGINAL_CLUSTER_ID
INTEGER
NOT NULL
Unique cluster identifier. Constrained by MDM_ENTITY_CLUSTERS table.
SRC_SYS_ID
INTEGER
NOT NULL
Unique source system identifier.
SRC_SYS_REC_ID
VARCHAR2(200)
NOT NULL
Source system record identifier.
ENTITY_TYPE_ID
INTEGER
NOT NULL
Unique entity type identifier. Constrained by MDM_ENTITY_TYPES table.
CURRENT_CLUSTER_ID
INTEGER
NOT NULL
Unique cluster identifier. Constrained by MDM_ENTITY_CLUSTERS table.

MDM_HIERARCHY_LEVELS Columns

The MDM_HIERARCHY_LEVELS table contains the list of levels for each hierarchy type.
MDM_HIERARCHY_LEVELS Columns
Name
Data type
Null Option
Description
MDM_HIERARCHY_LEVEL_ID
INTEGER
NOT NULL
Hierarchy level identifier.
MDM_HIERARCHY_TYPE_ID
INTEGER
NOT NULL
Hierarchy type identifier. Constrained by MDM_HIERARCHY_TYPES table.
MDM_REL_TYPE_ID
INTEGER
NOT NULL
Relationship type identifier. Constrained by MDM_ENTITY_REL_TYPES table.
MDM_REVERSE_REL_DIRECTION
CHAR(1)
NULL
Flag to reverse relationship direction.
MDM_PARENT_LEVEL_ID
INTEGER
NULL
Parent hierarchy level identifier.

MDM_HIERARCHY_TYPES Columns

The MDM_HIERARCHY_TYPES table is a constraining table denoting specific hierarchy types.
If you have loaded localized metadata (see Localization Configuration), the MDM_HIERARCHY_TYPES table includes additional columns for the labels that appear in SAS MDM (MDM_HIER_TYPE_LABEL and MDM_HIER_TYPE_DESC). These column names are postfixed with the locale name of the localized metadata. For example, if you have loaded the French metadata, the table includes MDM_HIER_TYPE_LABEL_FRFRA, and MDM_HIER_TYPE_DESC_FRFRA columns.
MDM_HIERARCHY_TYPES Columns
Name
Data Type
Null Option
Description
MDM_HIERARCHY_TYPE_ID
INTEGER
NOT NULL
Unique hierarchy type identifier.
MDM_OPSEQ
INTEGER
NULL
Sequence for optimistic locking.
MDM_HIERARCHY_TYPE
VARCHAR2(50)
NOT NULL
Hierarchy type designation.
MDM_VALID_FROM_DTTM
DATE
NULL
Start of validity for hierarchy type.
MDM_VALID_TO_DTTM
DATE
NULL
End of validity for hierarchy type.

MDM_NAMED_HIERARCHIES Columns

The MDM_NAMED_HIERARCHIES table contains the list of named hierarchies added by users.
MDM_NAMED_HIERARCHIES Columns
Name
Data Type
Null Option
Description
MDM_HIERARCHY_TYPE_ID
INTEGER
NOT NULL
Hierarchy type identifier. Constrained by MDM_HIERARCHY_TYPES table.
MDM_ENTITY_CLUSTER_ID
INTEGER
NULL
Cluster identifier. Constrained by MDM_ENTITY_CLUSTERS table.
MDM_HIERARCHY_NAME
NVARCHAR2(50)
NOT NULL
Hierarchy name.
MDM_HIERARCHY_DESC
NVARCHAR2(50)
NULL
Hierarchy name description.

MDM_LANGUAGES Columns

The MDM_LANGUAGES table is a constraining table for the list of configured languages.
MDM_LANGUAGES Columns
Name
Data Type
Null Option
Description
MDM_LANGUAGE_ID
INTEGER
NOT NULL
Unique country code identifier.
MDM_OPSEQ
INTEGER
NULL
Sequence for optimistic locking.
MDM_LANGUAGE_NAME
NVARCHAR2(50)
NULL
Language name.
MDM_QKB_LOCALE
VARCHAR2(5)
NOT NULL
QKB locale associated with language.
MDM_ISO_LOCALE
VARCHAR2(5)
NOT NULL
ISO locale associated with language.
MDM_IS_DEFAULT
CHAR(1)
NOT NULL
Flag to indicate default language.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Start of validity for country code.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
End of validity for country code.

MDM_PROCESS_CONTROL Columns

The MDM_PROCESS_CONTROL table is a control table to track load-update processes in the hub.
MDM_PROCESS_CONTROL Columns
Name
Data Type
Null Option
Description
PROCESS_ID
INTEGER
NOT NULL
Unique process identifier.
MDM_STAGING_ID
INTEGER
NULL
Unique staging identifier.
PROCESS_NAME
VARCHAR2(50)
NOT NULL
Process name.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Unique entity type identifier. Constrained by MDM_ENTITY_TYPES table.
PROCESS_RUNNING
CHAR(1)
NOT NULL
Flag to indicate whether process is currently running.
PROCESS_SUCCESS
CHAR(1)
NULL
Flag to indicate success or failure of process.
PROCESS_USER
NVARCHAR2(50)
NULL
User who initiated process.
PROCESS_START_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NOT NULL
Start date and time of process.
PROCESS_END_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
End date and time of process.

MDM_REL_ATTRS Columns

The MDM_REL_ATTRS table contains an attribute list for relationship types.
MDM_REL_ATTRS Columns
Name
Data Type
Null Option
Description
MDM_ATTR_ID
INTEGER
NOT NULL
Attribute identifier.
MDM_OPSEQ
INTEGER
NOT NULL
Sequence for optimistic locking.
MDM_REL_TYPE_ID
INTEGER
NOT NULL
Relationship type identifier.
MDM_ATTR_NAME
VARCHAR2(30)
NOT NULL
Attribute name.
MDM_ATTR_PROFILE_ID
INTEGER
NOT NULL
Unique relationship profile identifier, constrained by MDM_REL_ATTR_PROFILES table.
MDM_ATTR_DATATYPE_ID
INTEGER
NULL
Attribute data type identifier, constrained by MDM_ATTR_DATATYPES table.
MDM_ATTR_LENGTH
INTEGER
NULL
Maximum size of the attribute.
MDM_ATTR_CONSTRAINT
VARCHAR2(200)
NOT NULL
Lists of regex strings used for validation of Master Data Management input fields used to populate the attribute. Can be blank.
MDM_FORM_DISPLAY_ORDER
INTEGER
NULL
Display order of the attribute in the Master Data Management entity editor.
MDM_PREVIEW_DISPLAY_ORDER
INTEGER
NULL
Display order of the attribute in the Master Data Management Details panels.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Start of validity for relationship attribute.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
End of validity for relationship attribute.
MDM_READONLY_FLAG
CHAR(1)
NULL
Indicates whether the attribute can be modified from Master Data Management. Set to default N. Enter Y to specify that the attribute cannot be modified.
MDM_ENCRYPT_FLAG
CHAR(1)
NULL
Indicates that the attribute should be encrypted in the RT tables. Set to default N.

MDM_REL_ATTR_PROFILES Columns

The MDM_REL_ATTR_PROFILES table contains a list of localized relationship attribute profile names.
If you have loaded localized metadata, the MDM_REL_ATTR_PROFILES table includes additional columns for the labels that appear in SAS MDM (MDM_ATTR_PROFILE_NAME). These column names are postfixed with the locale name. For example, if you have loaded French metadata, the table includes an MDM_ATTR_PROFILE_NAME_FRFRA column.
MDM_REL_ATTR_PROFILES Columns
Name
Data Type
Null Option
Description
PROCESS_ID
INTEGER
NOT NULL
Unique profile identifier automatically generated bySAS MDM.

MDM_REMEDIATION_ATTRS Columns

The MDM_REMEDIATION_ATTRS table contains a list of remediation attributes for each entity type
MDM_REMEDIATION_ATTRS Columns
Name
Data Type
Null Option
Description
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Entity type identifier,constrained by MDM_ENTITY_TYPES table.
MDM_ATTR1
INTEGER
NULL
Attribute identifier, constrained by MDM_ATTRS table.
MDM_ATTR2
INTEGER
NULL
Attribute identifier, constrained by MDM_ATTRS table.
MDM_ATTR3
INTEGER
NULL
Attribute identifier, constrained by MDM_ATTRS table.

MDM_SRC_SYS Columns

The MDM_SRC_SYS table is a registry table for all source systems that feed the hub.
MDM_SRC_SYS Columns
Name
Data Type
Null Option
Description
MDM_SRC_SYS_ID
INTEGER
NOT NULL
Unique identifier of source system.
MDM_OPSEQ
INTEGER
NULL
Sequence for optimistic locking.
MDM_SRC_SYS_NAME
NVARCHAR2(50)
NOT NULL
Name of source system.
MDM_SRC_SYS_DESC
NVARCHAR2(100)
NULL
Description of source system.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Start of validity for source system.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
End of validity for source system.
MDM_SRC_SYS_PATH
VARCHAR(500)
NULL
Identifies the original source system in a hub. For source systems that were not imported from a hub, this value is not populated.

MDM_SRC_SYS_TOOLS Columns

The MDM_SRC_SYS_TOOLS table contains list of tools available for each entity type-source system association.
MDM_SRC_SYS_TOOLS Columns
Name
Data Type
Null Option
Description
SRC_SYS_TOOL_ID
INTEGER
NOT NULL
Source system tool identifier.
ENTITY_TYPE_SRC_ID
INTEGER
NOT NULL
Entity type of source system identifier.
TOOL
VARCHAR2(260)
NOT NULL
Tool name.
SORT_ORDER
INTEGER
NOT NULL
Sort order for tool.
TOOLTYPE
CHAR(1)
NOT NULL
Job type identifier for the tool. D for data job, P for process job, and B for batch job.
TOOLCODE
CHAR(1)
NOT NULL
Code identifier for the tool. A for Add/Update tool, S for Standardize tool, E for Extract too, U for Unknown, and O for Others.
RESULTTYPE
CHAR(1)
NOT NULL
Type of result being returned. Valid result types are Status (S), Batch status (B), URL (U), Table (T), and Embedded (E).
CONTACT
VARCHAR2(513)
NULL
Contact for the tool.
MDM_VALID_FROM_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
Start of validity for the tool.
MDM_VALID_TO_DTTM
TIMESTAMP WITH LOCAL TIMEZONE
NULL
End of validity for the tool.

MDM_SRC_SYS_TOOL_ACCESS Columns

The MDM_SRC_SYS_TOOL_ACCESS table contains access control list for source system tools.
MDM_SRC_SYS_TOOL_ACCESS Columns
Name
Data Type
Null Option
Description
SRC_SYS_TOOL_GROUP_ID
INTEGER
NOT NULL
Source system tool group identifier.
SRC_SYS_TOOL_ID
INTEGER
NOT NULL
Source system tool identifier. Constrained by MDM_SRC_SYS_TOOLS table.
MDM_GROUP
NVARCHAR
NOT NULL
Group name.
MDM_ACTIVE
CHAR(1)
NOT NULL
Source system tool access active indicator.

MDM_STAGING Columns

The MDM_STAGING table stages non-user attribute data before making it live in the hub.
MDM_STAGING Columns
Name
Data Type
Null Option
Description
MDM_STAGING_ID
INTEGER
NOT NULL
Unique staging identifier.
MDM_ENTITY_ID
INTEGER
NOT NULL
Unique record identifier.
MDM_ENTITY_CLUSTER_ID
INTEGER
NULL
Unique cluster identifier.
MDM_ENTITY_CLUSTER_NAME
NVARCHAR2(100)
NULL
Cluster name.
MATCH_TYPE
INTEGER
NULL
Match type of the incoming record.
OLD_CLUSTER_ID
INTEGER
NULL
Old CLUSTER ID if the record is migrating to a new cluster.
ROW_PROCESSED
CHAR(1)
NOT NULL
Flag indicating whether the record is processed.

MDM_TOOL_ACCESS Columns

The MDM_TOOL_ACCESS table specifies access control for entity type tools.
MDM_TOOL_ACCESS Columns
Name
Data Type
Null Option
Description
MDM_TOOL_GROUP_ID
INTEGER
NOT NULL
Entity type tool group identifier.
MDM_ENTITY_TYPE_ID
INTEGER
NOT NULL
Entity type identifier. Constrained by MDM_ENTITY_TYPES table.
MDM_TOOL_ID
INTEGER
NOT NULL
Entity type tool identifier. Constrained by MDM_ENTITY_TYPE_TOOLS.
MDM_GROUP
NVARCHAR
NOT NULL
Group name.
MDM_ACTIVE
CHAR(1)
NOT NULL
Entity type tool access active indicator.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: April 19, 2017