Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Properties

Number

0115

Submitting Entity (SE)

99MCR1, Medicare Advantage SEs

Add Date

Update Date

Update

Included in March 2024 Data Tips Email

Description

For data requesters receiving Arkansas Medicare fee for service data.

Arkansas Medicare fee for service claims include claims managed through Arkansas Medicare Advantage commercial plans. 

Medicare Advantage plans found in the commercial data on the Arkansas APCD can be identified using this methodology: 

Medicare Advantage plans do not always have plan names that can easily be identified as Medicare Advantage.  These plans can be identified when Insurance Product Type Code (ME003, MC003, PC003) contains the values  ‘HN','HS','MA','MB','MD','MDV','MH','MHO','MI', or ‘MPO' or when ME001, MC001 or PC001 = ‘60054M’ or '10155’. The Insurance Product code value is correct for corresponding member data). Tip: Medicare Advantage Plans

The match criteria in the table below is recommended to find the Medicare fee for service claims associated  with commercially based Arkansas Medicare Advantage plans.  NOTE:  It is important to exclude either the Medicare fee for service claim or the Medicare Advantage commercial claim to avoid duplication. Each claim type contains different information therefore an assessment of each is recommended.

Active/Resolved

Active

Action / Resolution

Active

Category 1

Medicare Advantage

Category 2

Medicare Fee for Service

Tip / Issue

Tip

Merging Criteria

Description

Notes:

APCD.PHM.PC026_Drug_Code = MCR.PartD.PROD_SRVC_ID

Drug Code Match

and APCD.PHM.PC027_Drug_name = MCR.PartD.BN

Drug Name Match

and APCD.PHM.PC032_Fill_Date = MCR.PartD.SRVC_DT

Fill Date Match

and APCD.PHM.PC043_PRESCR_ID = MCR.PartD.RX_SRVC_RFRNC_NUM_VARCHAR

Script Number Match

value formatting required to eliminate leading zeros

and APCD.PHM.PC033_Qty_Disp = MCR.PartD.QTY_DSPNSD_NUM

Quantity Dispensed Match

and APCD.PHM.PC034_Days_Supply = MCR.PartD.DAYS_SUPLY_NUM

Days Supply Match

and PC043_PRESCR_ID = MCR.PartD.PRSCRBR_ID

Prescriber ID Match

and APCD.PHM.STUDY_ID = MCR.PartD.STUDY_ID

Study ID Match

Study IDs must be retrieved from Member/Beneficiary data

and APCD.PHM.PC036_PD_AMT = (MCR.PartD.LICS_AMT+CVRD_D_PLAN_PD_AMT)-MCR.PartD.NCVRD_PLAN_PD_AMT)

Paid Amount Match

Calculation required