Data Steward Guide

Back Next

Consolidation Indicator

All base objects have a system column named CONSOLIDATION_IND.

The

consolidation indicator

represents the consolidation status of individual records as they progress through multiple processes in

MDM Hub

The following table describes the consolidation indicator values:

Value	State Name	Description
1	CONSOLIDATED	Indicates that the record is consolidated, determined to be unique, and represents the best version of the truth.
2	QUEUED_FOR_MERGE	Indicates that the record might have gone through the match process and is ready for a merge. Also, the record might have gone through the merge process and is ready for another merge.
3	Not MERGED or MATCHED	This record has gone through the match process and is ready to be consolidated. Also, if a record has gone through the manual merge process, where the matching is done by a data steward, the consolidation indicator is 2.
4	NEWLY_LOADED	Indicates that the record is a new insert or is unmerged and must undergo the match process.
9	ON_HOLD	Indicates that the data steward has put the record on hold until further notice. You can put any record on hold, regardless of its consolidation indicator value. The match and consolidate processes ignore records that are on hold.