Entity Tables :: SAS® MDM 4.3: Administrator's Guide

Overview

The following tables are generated from the metadata for the specific entity type. As attributes for an entity type are defined, columns are added to the tables. The tables that are created are not automatically removed as entity types are retired.

Sample Entity Tables

Sample Entity Tables
Name	Naming Convention	Description
Staging Table	MDM_<entity_type>_ST	Table used to prepare data before updating the hub.
Transpose Table	MDM_<entity_type>_TT	Table used to maintain record data for particular entity types.
Cluster Conditions Table	MDM_<entity_type>_CC	Table used to pre-load cluster condition data columns during a data load.
Audit Log Table	MDM_<entity_type>_AL	Table to maintain audit trail of changes to hub data.

The following columns are common to all the staging tables and transpose tables. These tables are further populated with columns representing the attributes defined for the entity type.

MDM_<Entity_Type>_ST Columns

The staging tables are schema-evolved to include columns for the attributes defined by the related entity type.

MDM_<Entity_Type>_ST Columns
Name	Data Type	Null Option	Description
MDM_STAGING_ID	INTEGER	NOT NULL	Unique staging identifier.
ROW_ID	INTEGER	NOT NULL	Identifier for row within each staging ID.
MDM_ENTITY_CLUSTER_ID	INTEGER	NULL	Unique cluster identifier.
MDM_ENTITY_CLUSTER_NAME	NVARCHAR2(100)	NOT NULL	Cluster name.
MDM_SURVIVOR	CHAR(1)	NOT NULL	Flag indicating if the record is a survivor record.
MATCH_TYPE	INTEGER	NOT NULL	Match type of the incoming record.
CID	INTEGER	NOT NULL	Intermittent cluster ID.
ROW_PROCESSED	CHAR(1)	NOT NULL	Flag indicating if the record is processed or not.
MDM_SRC_SYS_ID	INTEGER	NOT NULL	Unique source system identifier.
MDM__SRC_SYS_REC_ID	NVARCHAR2(200)	NULL	Source system record identifier.
MDM_LANGUAGE_ID	INTEGER	NOT NULL	Unique language identifier.

MDM_<Entity_Type>_TT Columns

The transpose tables are schema-evolved to include columns for the attributes defined by the related entity type.

MDM_<Entity_Type>_TT Columns
Name	Data Type	Null Option	Description
MDM_STAGING_ID	INTEGER	NOT NULL	Unique staging identifier.
MDM_ENTITY_ID	INTEGER	NOT NULL	Unique entity identifier.
MDM_SRC_SYS_ID	INTEGER	NOT NULL	Unique source system identifier.
MDM_SRC_SYS_REC_ID	NVARCHAR2(200)	NULL	Source system record identifier.
MDM_LANGUAGE_ID	INTEGER	NOT NULL	Unique language identifier.
MDM_ENTITY_CLUSTER_ID	INTEGER	NOT NULL	Unique cluster identifier.
MDM_SURVIVOR	CHAR(1)	NOT NULL	Flag indicating if the record is a survivor record.
MDM_VALID_FROM_DTTM	TIMESTAMP WITH LOCAL TIME ZONE	NULL	Start of validity for entity.
MDM_VALID_TO_DTTM	TIMESTAMP WITH LOCAL TIME ZONE	NULL	End of validity for entity.

MDM_<Entity_Type>_CC Columns

The cluster conditions tables are schema-evolved to include columns for the attributes defined by the related entity type.

MDM_<Entity_Type>_CC Columns
Name	Data Type	Null Option	Description
MDM_STAGING_ID	INTEGER	NOT NULL	Unique staging identifier.
ROW_ID	INTEGER	NOT NULL	Unique row identifier.

MDM_<Entity_Type>_AL Columns

MDM_<Entity_Type>_AL Columns
Name	Data Type	Null Option	Description
MDM_AUDIT_LOG_ID	INTEGER	NOT NULL	Unique audit log identifier.
TABLE_NAME	VARCHAR2(50)	NOT NULL	Name of the table in which the auditable action was made.
RECORD_ID	INTEGER	NOT NULL	Identifier of the record for which the auditable action was made.
USER_ACTION	VARCHAR2(10)	NOT NULL	Type of action.
MDM_MODIFIED_BY	NVARCHAR2(513)	NOT NULL	ID of the user who performed the auditable action.
MODIFIED_DTTM	TIMESTAMP WITH LOCAL TIME ZONE	NOT NULL	Date and time at which the auditable action occurred.