Configuration Guide

10.5 HotFix 3

Back Next

Delete All Relationship Periods 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.

You want to delete Mary's relationship record because her relationship with the Adam household is incorrect. You must delete all relationship record versions that are effective for different periods. When you delete Mary's relationship records for all effective periods, the MDM Hub changes the hub state of the record versions to the deleted state in the cross-reference table associated with the PARTY GROUP REL relationship base object.

When you delete all relationship periods, the hub state indicator of all the original record versions is set to deleted in the cross-reference table, RL PARTY GROUP CROSS-REFERENCE, that is associated with the PARTY GROUP REL relationship base object.

Before you delete all the relationship periods, the cross-reference table shows that all the effective relationships between Mary and the Adam household are active.

Rowid XREF	Rowid Object	Party ID	Hub State Indicator	Party Group ID	Period Start Date	Period End Date
63	22	147	Active	28	October 6, 2006	December 31, 2015
66	22	147	Active	28	January 1, 2016	December 31, 2999

After you delete all the relationship periods, the cross-reference table shows that all relationships between Mary and the Adam household are deleted.

Rowid XREF	Rowid Object	Party ID	Hub State Indicator	Party Group ID	Period Start Date	Period End Date
63	22	147	Deleted	28	October 6, 2006	December 31, 2015
66	22	147	Deleted	28	January 1, 2016	December 31, 2999

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

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

Rename Saved Search

Table of Contents

Configuration Guide

Configuration Guide

Delete All Relationship Periods Example

Delete All Relationship Periods Example