Primary key that uniquely identifies this record in the cross-reference table.

Primary key value from the source system. You must concatenate keys that contain multiple fields or multiple columns into a single key value. Use the MDM Hub internal cleanse process or an external cleanse process such as an ETL tool or some other data loading utility to concatenate the keys.

Foreign key to C_REPOS_SYSTEM, which is the MDM Hub repository table that stores an MDM Hub identifier and description of each source system that can populate the ORS.

Foreign key to the base object. The

MDM Hub

assigns ROWID_OBJECT to the associated base object record.

The original ROWID_OBJECT of the cross-reference record.

The original global identifier value.

Name of the staging table whose lookup configuration was used when the

MDM Hub

loaded the cross-reference record.

A shadow column that contains the value used to look up the foreign key column.

Last source update date. The

MDM Hub

updates SRC_ LUD when the source system sends an update to the cross-reference record.

User or process responsible for creating the cross-reference record.

Date on which the cross-reference record was created.

User or process responsible for the most recent update to the cross-reference record.

Date of the most recent update to any cell in the cross-reference record. The

MDM Hub

updates LAST_UPDATE_DATE as applicable during the load process and consolidation process.

Reserved for future use.

Reserved for future use.

Reserved for future use.

Start date of an effective period of a record. A PERIOD_START_DATE value is required for cross-reference records of timeline-enabled base objects.

End date of an effective period of a record. A PERIOD_END_DATE value is required for cross-reference records of timeline-enabled base objects.

When the value is 1, indicates that a Put API call updated that particular record by specifying the ROWID_OBJECT value in the Put API request.

For state-enabled base objects. Interaction identifier that is used to protect a pending cross-reference record from updates that are not part of the same process as the original cross-reference record.

For state-enabled base objects. Integer value indicating the state of the record. Valid values are:

0 = Pending
1 = Active
-1 = Deleted

For state-enabled base objects. Integer value indicating the promotion status. The promote process uses PROMOTE_IND to determine whether to promote the record to an ACTIVE state. Valid values are:

0 = Do not promote the record.
1 = Promote this record to ACTIVE.