Tip: Submitting Entity Merge - 90328, 10155

0062

90328, 10155, 99CAR1

Dec 15, 2020

Jan 27, 2021 Jun 3, 2022 May 24, 2023

Updated description. Included in June 2023 Data Tips email

First Health & Life (90328) stopped medical claim submission after Q3 2017 due to low membership count.    

First Health & Life (90328) was acquired by Wellcare (10155). They then stopped submitting eligibility and pharmacy data in Q4 2019. These data have been moved to SE 99CAR1, which is the Wellcare pharmacy benefit manager (PBM). 

Select the Caremark (99CAR1) member records where the Employer Name field (ME082) contains the values WELLCARE PDP S5768 or WELLCARE PDP S5810.

Find the SE 99CAR1 member records selected above, related to the SE 90328 member records by grouping on Study ID (created by concatenating APCD Unique ID (ME998) and member gender (ME013)).

Then, use the SE 99CAR1 and SE 90328 member IDs (ME107) to select claims.

UPDATE: Wellcare and Caremark member IDs have begun to use the same member IDs therefore users can use ME107 to find members across sources for newer data.

Active

Merged SE & Overlap

PBM

Tip