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 2014-12-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 <= '2014-12-31' and
ME163A >= '2013-01-01'.
Only EBD member/enrollment data source from EBD and associated with EBD Pharmacy claims is usable for 2015-01-01 to 2022-05-31:
select records from Member data
where ME001 = '99EBD1'
and PC012 = ME013 (member gender)
and PC013 = ME014 (member date of birth, else MC013_year = ME014_year)
and PC107 = ME107 (carrier specific unique member ID)
and PC017 (paid date) is between (ME162A (member enrollment date)
and ME163A (member disenrollment date))
To find EBD member/enrollment data from 2015-01-01 forward:
Select records from member data
where ME001 = '95442' and ME003 = 'EBD'
Note: These member records can be associated with medical
claims and/or pharmacy claims or they may have no associated
claims at all.
Medical Claims:
select records from medical claims
where MC001 = '99EBD1' and MC059 <= '2014-12-31'
Note: There are no records where MC001 = '99EBD1'
and MC059 > '2015-01-01'
To find associated EBD member/enrollment data sourced from EBD for medical claims 2014-12-31 back:
select records from Member data
where ME001 = '99EBD1'
and MC012 = ME013 (member gender)
and MC013 = ME014 (member date of birth, else MC013_year = ME014_year)
and MC137 = ME107 (carrier specific unique member ID)
and MC059 (service from date) is between (ME162A (member enrollment date)
and ME163A (member disenrollment date))
Medical claims data from 2015-01-01 forward are no longer sourced from EBD and are now sourced from Arkansas Blue Cross and Blue Shield:
select records from medical claims
where MC001 = '95442' and MC003 = 'EBD' and MC059 >= '2015-01-01'
To find associated EBD member/enrollment data for medical claims from 2015-01-01 forward:
select records from Member data
where ME001 = '95442' and ME003 = 'EBD'
where MC001 = ME001 and MC137 = ME107
Pharmacy Claims:Pharmacy claims data 2022-05-31 back are still sourced from EBD:
select records from pharmacy claims
where PC001 = '99EBD1' and PC017 <= '2022-05-31'
Note: There are no records where PC001= '99EBD1'
and PC017 > '2022-06-01'
To find associated EBD member/enrollment data for pharmacy claims:
select records from Member data
where ME001 = '99EBD1'
and PC012 = ME013 (member gender)
and PC013 = ME014 (member date of birth, else MC013_year = ME014_year)
and PC107 = ME107 (carrier specific unique member ID)
and PC017 (paid date) is between (ME162A (member enrollment date)
and ME163A (member disenrollment date))
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 Hash ID methodology to join members across submitters. See Data Tip: Tip: APCD Unique ID, aka Hash ID |
0 Comments