Tip: Joining Medicare Beneficiaries to APCD Members

0102

All

Jan 12, 2022

Feb 22, 2023

Included in February 2023 Data Tips Email

Joining Medicare beneficiaries to APCD members

Active

To find members across the APCD data and Medicare data, you’ll need to join Medicare data to the other data on APCD. Using the MCR_BEN_SUMM (beneficiary member ) table, concatenate the APCD_UNIQUE_ID+SEX_IDENT_CD. Then join that value to the same concatenated fields on the APCD Member table - ME998+ME013. Once you have the join completed, you need to adjust for collisions (refer to this deck:

https://www.arkansasapcd.net/Docs/1392/). This will reduce the number of members with very common names that may cause an ‘over’ join. It is best practice to just drop these. Once you have your selected members, use the associated BENE_ID on the MCR_BEN_SUMM table to find associated claims on the other Medicare tables. Medicare table layouts can be found here, too: Data Element Lists

APCD Unique ID/Study ID

Medicare

tip