Tip: TPA and PBM Replacement Data for EBD - Original
Number | 0124 |
|---|---|
Submitting Entity (SE) | 99EBD1, 95442 |
Add Date | Mar 6, 2023 Apr 14, 2023 Jul 14, 2023 |
Update Date | Sep 18, 2023 |
Update | Included in the Sept. 2023 data tips email with update. See Description. |
Description | Update: A new field has been added to the APCD - ME001_CAT. See data tip https://achiapcd.atlassian.net/wiki/spaces/ADRS/pages/3167027315/Redefined+field+-+ME001+CAT for definitions. EBD members can be selected where ME001_CAT in ('EBD','EBD_TPA','EBD_PBM','EBD_RET','EBD_NOHLTH'). Submitting Entity ID (ME001) and Member ID (ME107) for records with these values in ME001_CAT can be matched to medical and pharmacy claims for claim selection.
Description below pertains to data from Spring 2023/22D update. TPA replacement data for EBD EBD medical claims and pharmacy claims data submission has changed. Older EBD claims data is still sourced from EBD while new data is now sourced by third party administrators (TPA) and pharmacy benefit managers (PBM). This is applicable only to data requested after March 2023. Data users with data pulled before March 2023 should NOT use this tip. The selection criteria is described here: Member Data:All EBD member/enrollment data sourced from EBD for 2022-05-31 back is usable for both EBD medical and pharmacy claims in that time period. To select these data: select records from member data
where ME001 = '99EBD1' and ME162A <= '2022-05-31' and
ME163A >= '2013-01-01'.Only EBD member/enrollment data sourced from EBD and associated with EBD Pharmacy claims is usable for 2013-01-01 to 2022-05-31: select records from Member data
where ME001 = '99EBD1'
and ME162A <= '2022-05-31' and ME163 >= '2013-01-01'To find EBD member/enrollment data for the EBD TPA Health Advantage from 2022-06-01 forward: Select records from member data
where ME001 = '95442' and ME003 = 'EBD'
and ME162A <= '9999-12-31' and ME163 >= '2022-06-01'Future Member Data: Member data associated with EBD pharmacy data managed by its pharmacy benefit manager, MedImpact (99MDI2 and 99MDI3), are still being finalized. Medical Claims:
To find associated EBD member/enrollment data sourced from EBD for medical claims 2022-05-31 back: Medical claims data from 2022-06-01 forward are no longer sourced from EBD and are now sourced from Health Advantage (Arkansas Blue Cross and Blue Shield). There is no field to flag a claim as EBD so the medical claims must be matched to the member data to identify it as an EBD claim. Pharmacy Claims:Pharmacy claims data 2022-05-31 back are still sourced from EBD: To find associated EBD member/enrollment data for pharmacy claims: Pharmacy claims data from 2022-06-01 forward are no longer sourced from EBD and will be submitted by its TPA MedImpact. These data are not available yet. Once available, selection criteria will be provided.
Therefore, medical claims and associated member data (whether from EBD or Arkansas Blue Cross Blue Shield) is available from 2013-01-01 through current. Pharmacy claims and associated member data is available from 2013-01-01 through 2022-05-31. Linking between EBD and TPAs:EBD, Arkansas Blue Cross and Blue Shield, and MedImpact member IDs do not match across source systems. Users must use the Study ID methodology to join members across submitters. See Data Tip: https://achiapcd.atlassian.net/wiki/spaces/ADRS/pages/406847537 |
Active/Resolved | Active |
Action / Resolution | Active for data request pulled before March 2023 |
Category 1 | EBD |
Category 2 | TPA |
Tip / Issue | Tip |