Configuration Guide

10.4

Back Next

Base Object Columns

Base objects have system columns and user-defined columns. System columns are columns that the Schema Manager creates and maintains. User-defined columns are columns that the user adds.

The following table describes the base object system columns:

Physical Name	MDM Hub Datatype (Size)	Description
ROWID_OBJECT	CHAR (14)	Primary key. Informatica MDM Hub assigns a unique value when a record is inserted into the base object.
CREATOR	VARCHAR (50)	User or process that created the record.
CREATE_DATE	TIMESTAMP	Date on which the record was created.
UPDATED_BY	VARCHAR (50)	User or process responsible for the most recent update on the record.
LAST_UPDATE_DATE	TIMESTAMP	Date of the most recent update to any cell on the record.
CONSOLIDATION_IND	INT	Integer value indicating the consolidation state of this record. Valid values are: 1 = unique. The record represents the best version of the truth. 2 = ready for consolidation. 3 = ready for match; this record is a match candidate for the currently executing match process. 4 = available for match. The record is new and needs to undergo the match process. 9 = on hold. A data steward has put this record on hold.
DELETED_IND	INT	Reserved for future use.
DELETED_BY	VARCHAR (50)	Reserved for future use.
DELETED_DATE	TIMESTAMP	Reserved for future use.
LAST_ROWID_SYSTEM	CHAR (14)	Identifier of the system responsible for the update to the most recently processed cell in the base object record. LAST_ROWID_SYSTEM is a foreign key that references the ROWID_SYSTEM column in the C_REPOS_SYSTEM table.
DIRTY_IND	INT	The DIRTY_IND system column is deprecated. Instead, the MDM Hub uses a system table called the dirty table to determine the records that it needs to tokenize.
INTERACTION_ID	INT	For state-enabled base objects. INTERACTION_ID is an interaction identifier that protects a pending cross-reference record from updates that are not part of the same process as the original cross-reference record.
HUB_STATE_IND	INT	For state-enabled base objects. Integer value indicating the state of this record. Valid values are: 0=Pending 1=Active -1=Deleted The default is 1.
CM_DIRTY_IND	INT	Indicates if data changed when you use the zero downtime process to upgrade.