Refactor the Claim Domain

In this step, you will refactor the Claim domain by adding mappings for each related table in the relational database and embedding all claim-related information under a single MongoDB claim document. Since the Claim and Litigation domains are closely related, you will also recreate the many-to-many relationship between the two domains by referencing the Litigation entity from the claim document.

About this Task

The Claim domain includes the following key entities:

Claim: Claim for coverage or compensation
Claim Party Role: An associative entity which links the following entities:
- Party
- Party Roles
- Insurable Objects
Insurable Object Party Role: An associative entity which links the following entities:
- Party
- Party Roles
- Insurable Objects

Before You Begin

Refactoring the Claim & Litigation domain is the fourth step of the insurance data model example tutorial. Before you refactor the Claim & Litigation domain, ensure that you:

Connected to your PostgreSQL database in Relational Migrator.
Refactored the Party domain.
Refactored the Policy domain.

Steps

From the MongoDB view, click the claim document

On the right side of the screen, the Mappings menu opens.

Add mappings for the claim_party_role table

Next to Mappings from relational tables, click Add. Click Embedded array and select claim_party_role from the Source table drop-down menu.

Under the All fields checkbox, uncheck the claimIdentifier field and click Save and close.

Add mappings for the the insurable_object table under the claim document

Next to Mappings from relational tables, click Add and select Embedded documents. Choose insurable_object from the Source table drop-down menu.

Click Save and close.

Embed the policy_coverage_detail table within insurableObject

Policy coverage details help establish the link between claims and policies. To embed the information from the policy_coverage_detail table, click Add and select Embedded array. Choose policy_coverage_detail from the Source table drop-down menu.

Under the All fields checkbox, uncheck the insurableObjectIdentifier field, and click Save and close.

Map the many-to-many relationship between litigation and claim

Since Litigation is a separate entity, you just need to reference that entity from the claims document as an array of litigation identifiers.

Next to Mappings from relational tables, click Add and select Embedded array. Choose litigation_party_role from the Source table drop-down menu.

Under the All fields checkbox, uncheck the litigationIdentifier field, and click Save and close.

Remove collections that are no longer needed

Now that you mapped all the necessary tables to the claim collection, you can delete the claimPartyRole collections from the MongoDB view of Relational Migrator.

Next Steps

After you map the Claim domain, refactor the Litigation domain in a similar manner. See Refactor the Litigation Domain.

Back

Refactor the Policy Domain

Refactor the Litigation Domain