Merge actions performed on ContactMain and UserMain records
As part of the merge process, the following actions are performed on all IDs that are merged or deleted:
| Table | Field(s) | Updated to |
|---|---|---|
| ContactMain | SyncContactID | NULL |
| ContactMain | ContactStatusCode | 3 (Delete) |
Additionally, if the merged or deleted ID had an associated user record, the following actions are performed:
| Table | Field(s) | Updated to |
|---|---|---|
| UserMain | ContactMaster, UserId | Empty |
| UserMain | IsDisabled | 1 (True) |
NoteFor optimal performance, purge unused users and contacts using the DB Maintenance Utility after you have merged contact records.
Important:
DMM will not merge any data from .NET tables (other than ContactMain and UserMain). Merging contact records that have associated .NET records may result in orphaned records. Examples include (but not limited to):
- DocumentMain.CreatedByUserKey
- DocumentMain.UpdatedByUserKey
- GroupMain.MemberContactKey
- GroupMain.MemberContactKey