Combine a Company/Individual (With Duplicate ADDRESS\Entity Entry)

This occurs when there is one entry in CARS_ENTITY but two or more records in CARS_ADDRESS for the same client with ADDRESS_TYPE = 2 (this will result in the display of more than one record for the company while there is actually one record in CARS_ENTITY).

Open

1. Get CLIENT_ID from CARS_ENTITY using the COMPANY_LEGAL_NAME / FAMILY_NAME

2. Keep note of the CLIENT_ID (ENTRY) that will be kept

3. Go to CARS_ADDRESS and filter By CLIENT_ID (BOTH OR MORE)

4. Go to CARS_AUTHORIZED_PARTICIPANTS and filter By ADDRESS.SEQUENCE_NO (USING CARS_ADDRESS SEQUENCE_NO for those entries

5. Combine the CLIENT_ID and ADDRESS_SEQUENCE_NO to the one that will be kept in CARS_ADDRESS

6. Delete the CARS_ADDRESS entry that is removed from CARS_AUTHORIZED_PARTICIPANTS (Keep a note of the SEQUENCE_NO)

7. Delete redundant record from CARS_ENTITY

8. There are other TABLES that might need to be consolidated with the CLIENT_ID that will be KEPT