Each row in the cross-reference table represents a separate record from a source system. If multiple sources provide data for a single column (for example, the phone number comes from both the CRM and ERP systems), then the cross-reference table contains separate records from each source system. For timeline-enabled base objects, the cross-reference table also contains separate records for each version of a base object record. Each base object record has one or more associated cross-reference records.

The cross-reference record contains:

An identifier for the source system that provided the record.
The primary key value of that record in the source system.
The most recent cell values provided by that system.
The original ROWID_OBJECT value of the record.
The original GBID value of the record, if applicable.
The start date and end date of the period of effectiveness of the record, if applicable.

The load process populates cross-reference tables. During load inserts, new records are added to the cross-reference table. During load updates, changes are written to the affected cross-reference records.

Cross-reference records are visible in the Merge Manager and can be modified using the Data Manager. For more information, see the

Multidomain MDM Data Steward Guide

.