Table Description
Merged Record: A list of new records created as a result of a merge.

Details of any information added to the original client as a result of a merge.

Example

Jimmy Smith has been marked as a duplicate of James Smith. The user selects to merge selected details about Jimmy Smith (the duplicate) to James Smith (the master record). A history is kept of the records that were merged and the new records that were created as a result of the merge process.

Model Details
Location in Model: Logical View::MetaModel::Curam::Core::Reference Model::Service Layer::ClientMerge::Entity::MergedRecord
Controlling File: core\model\Packages\Reference Model\Service Layer\ClientMerge\Entity\Entity_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
mergedRecordIDkeynoUnique identifier of the merged record.MERGE_RECORD_ID SVR_INT64
concernRoleMergeIDdetails Unique identifier of the concern role merge record.CONCERN_ROLE_MERGE_ID SVR_INT64
recordTypedetails Code table code to indicate the type of record that has been merged.RECORD_TYPEMergeEntitySVR_STRING<10>
mergedFromRecordIDdetails Unique identifier of the record that was merged.RECORD_ID SVR_INT64
mergedToRecordIDdetails Unique identifier of the record created during the merge process.RECORD_ID SVR_INT64
Indices (1)
Index NameAttributes
IND_1848105983concernRoleMergeID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: mergedRecordID
Standard Operation 
searchByConcernRoleMergeIDreadmulti Returns all merged records for specified concern role merged id. 
countByMergedToRecordIDAndTypens Method to check if a record has been part of the merge process.SQL
countByMergedFromToRecordIDAndTypens Method to check if a record has been already merged.SQL
Related Pages (79)
Match Client (Application_matchClientConfirmation)
Add Client (Application_registerPersonAndAddAsClient)
Register Person (Application_registerProspectPersonAsPerson)
Register Person (BenefitSample_registerPerson)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCase)
Register Person and Create Case (Case_registerPersonAndCreateIntegratedCasePDC)
Add Client (CommonIntake_addClient)
Register Client (CommonIntake_registerClient)
New Absent Parent Evidence (EVD_addToCaseAbsentParentEvidence_sa)
New Household Member Evidence (EVD_createHouseholdMemberEvidence_sa)
Edit Absent Parent Evidence (EVD_incomingModifyAbsentParentEvidence)
Edit Absent Parent Evidence (EVD_modifyAbsentParentEvidence)
Edit Alternative Identifier (ExternalParty_modifyAlternateIDFromList)
Edit Alternative Identifier (ExternalParty_modifyAlternateIDFromView)
Add Member (HCRAddMemberWizard_summary)
Register Person (ICSample_registerPerson)
Register Person (IncomeScreening_registerHouseholdMember)
Register Person (IncomeScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPerson)
Register Person (IncomeSupportScreening_registerPersonForHouseholdEvidence)
Register Prospect Person as Person (Individual_registerProspectAsPerson)
Related Persons (Intake_listRelatedPerson)
Register Person (Intake_personFullRegistration)
Person Search Results (Intake_personSearchResult)
Register Prospect Person as Person (Intake_registerProspectAsPerson)
Register Prospect Person as Person (Intake_registerProspectPersonAsPerson)
Register Prospect Person (Intake_registerProspectPersons)
Register Prospect Person (Intake_registerProspectPersons_Reset)
Register Prospect Person (Intake_registerProspectPersons_Reset1)
Register Prospect Person (Intake_registerProspectPersons1)
Register Person (IntakeShortCuts_registerPerson)
Register Person (InvestigationSample_registerPerson)
Register Person (InvestigationSample_registerPersonForPDC)
Add Household Member (ISAddMemberWizard_summaryDetails)
Register Person (ISP_registerPerson)
Basic Intake Information (ISPIntakeInformation_createFromScreening)
Re-add a Member (ISReAddMemberWizard_submit)
Register Person (LiabilitySample_registerPerson)
Merge Duplicate (Participant_mergeAddresses)
Merge Duplicate (Participant_mergeAddressEvidence)
Merge Duplicate (Participant_mergeAlternateIDEvidence)
Merge Duplicate (Participant_mergeAlternateNameEvidence)
Merge Duplicate (Participant_mergeAlternativeIDs)
Merge Duplicate (Participant_mergeAlternativeNames)
Merge Duplicate (Participant_mergeBankAccountEvidence)
Merge Duplicate (Participant_mergeBankAccounts)
Merge Duplicate (Participant_mergeCitizenships)
Merge Duplicate (Participant_mergeCommunicationExceptions)
Merge Duplicate (Participant_mergeContacts)
Merge Duplicate (Participant_mergeEducation)
Merge Duplicate (Participant_mergeEmailAddresses)
Merge Duplicate (Participant_mergeEmailAddressEvidence)
Merge Duplicate (Participant_mergeEmployment)
Merge Duplicate (Participant_mergeForeignResidencies)
Merge Duplicate (Participant_mergeNotes)
Merge Duplicate (Participant_mergeNotes1)
Merge Duplicate (Participant_mergePhoneNumberEvidence)
Merge Duplicate (Participant_mergePhoneNumbers)
Merge Duplicate (Participant_mergeRelationshipEvidence)
Merge Duplicate (Participant_mergeRelationships)
Merge Duplicate (Participant_mergeSpecialCaution)
Merge Duplicate (Participant_mergeWebAddresses)
Edit Alternative Identifier (Participant_modifyAlternateID)
Edit Alternative Identifier (Participant_modifyAlternateIDFromList)
Edit Alternative Identifier (Participant_modifyAlternateIDFromView)
Unmark Duplicate (Participant_unmarkDuplicate)
Register Person (Person_register)
Register Person (Person_registerForPDC)
Confirm Registration (Prospect_registerPersonFromProspect)
Register Prospect Person as Person (ProspectPerson_registerAsPerson)
Register Prospect Person as Person (ProspectPerson_registerAsPersonForPDCWizard)
Register Prospect Person as Person (ProspectPerson_registerAsPersonWizard)
Step 5: Register Person (ProviderManagement_duplicateRegisterPersonAsProvider)
Step 5: Register Person (ProviderManagement_registerPersonAsProvider)
Register As Person (ProviderManagement_registerProviderAsPersonFrmProviderHome)
Register Person (RegisterPerson_registerForPDCWizard)
Register Person (RegisterPerson_registerWizard)
Application (RightsAndResponsibilitiesForCase)
Application (RightsAndResponsibilitiesForCaseSubmit)