Configuration Guide

10.4 HotFix 1

Back Next

Delete a Relationship Example

Your organization has the PARTY base object that contains a record for Mary Adam. The PARTY GROUP base object contains the details of the Adam household to which Mary belongs. The relationship between the PARTY and the PARTY GROUP base object is defined in the associated PARTY GROUP REL relationship base object. You need to delete the relationship between Mary and the Adam household that is effective from October 6, 2006.

You want to delete a version of Mary's relationship record that is incorrect. When you delete Mary's relationship record, the MDM Hub adds a record in the deleted state to the cross-reference table associated with the PARTY GROUP REL relationship base object.

The following changes occur in the cross-reference table, RL PARTY GROUP CROSS-REFERENCE, that is associated with the PARTY GROUP REL relationship base object:

A record is inserted for the relationship between Mary and the Adam household without any change to the effective period.

The deleted indicator of the new record is -999999999.

The hub state indicator of the new record is deleted.

The original record does not change.

Before you delete the relationship between Mary and the Adam household, the cross-reference table shows that the relationship is active.

Rowid XREF	Rowid Object	Party ID	Deleted Indicator	Hub State Indicator	Party Group ID	Period Start Date	Period End Date
63	22	147		Active	28	6 October 2006	31 December 2999

After you delete the relationship between Mary and the Adam household, the cross-reference table shows a new record with the relationship deleted.

Rowid XREF	Rowid Object	Party ID	Deleted Indicator	Hub State Indicator	Party Group ID	Period Start Date	Period End Date
63	22	147		Active	28	6 October 2006	31 December 2999
621	22	147	-999999999	Deleted	28	6 October 2006	31 December 2999

The relationship base object shows that the relationship between Mary and the Adam household is deleted.

Rowid Object	Party ID	Deleted Indicator	Hub State Indicator	Party Group ID
22	147	-999999999	-1	28

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Delete a Relationship Example

Delete a Relationship Example