Arkansas APCD 24B Release Notes - December 2024 DRAFT

The Arkansas Healthcare Transparency Initiative (HTI) releases updates to the Arkansas All-Payer Claims Database quarterly. The Arkansas APCD 24B database is now available.  The Arkansas APCD 24B release includes data through September 2024??.  The Data Coverage table provides overall coverage periods.  Some submitters have submitted data through the next quarter and some submitters have exemptions affecting missing coverage. The Universe Counts report provides detailed counts for all file types included in this update.

DATA COVERAGE

Source Category

COVERAGE

Arkansas Works Data

Jan 2014 – March 2024

Commercial, Fully Insured Data

Jan 2013 – March 2024

Arkansas Employee Benefits Division Data

Jan 2013 – March 2024

Arkansas Medicaid Data

Jan 2013 – March 2024

Arkansas Qualified Health Plan Data

Jan 2014 – March 2024

Arkansas Medicare Data

Jan 2013 - Dec 2021

Vital Statistics Data - Arkansas Birth Certificate Data

Jan 2013 - Dec 2023

Vital Statistics Data - Arkansas Death Certificate Data

Jan 2013 - Dec 2023

Inpatient Hospital Discharge Data (uninsured or self-pay patients)

Jan 2013 - Dec 2022

Emergency Department Data (uninsured or self-pay patients)

Jan 2013 - Dec 2022

Cancer Registry Data

Jan 2013 - Dec 2020

Medical Marijuana Cardholders Data

Aug 2018 – Dec 2022

Arkansas Workers' Compensation Data

Jan 2013 – March 2024

Member Enrollment Selection Table (NEW!)

Jan 2016 - Dec 2023

With a few exceptions, all required submitting entities have submitted data in the ranges indicated in the Data Coverage table above.  Refer to the Source Specific Release Notes section for more information.

Source Specific and Data Release Notes

 

SE_ID

Submitting Entity

Release Notes

Release Status

68985

62049

Starmount/

Unum

These entities have submitted incorrectly formatted APCD_Unique_ID (ME998) values. The Arkansas APCD team is working with the submitting entity to resolve the data. These data will not be included in data releases until the issue is resolved.

Issue

99MDI1, 99MDI2, 99MDI3

99MDI4, 99MDI5

MedImpact

MedImpact is a new pharmacy submitter. Member IDs and subscriber IDs are problematic on much of the member data and pharmacy claims causing orphaned claims. Use with caution. The Arkansas APCD team is working with the submitter to resolve the issue.

Issue: MedImpact Pharmacy Orphans

Partially resolved for 24A. 99MDI4 and 99MDI5 are now correct.

69019

Ameritas/

Standard Insurance Company

26% of the Standard Insurance Company (Ameritas) dental claims have no matching member records (ME107). The APCD Technical Support team is working with the carrier to resolve this issue.

https://achiapcd.atlassian.net/wiki/x/AoDt1Q

Issue

16751

USAble HMO, Inc.

This is a new AR BCBS submitter. Submitted data begins January 2024.

Informational

99HSM1

HealthSmart

Member IDs on Medical (MC137) and Pharmacy (PC107) Claims have been corrected and now match Member (ME107) data.

Subscriber IDs on Member (ME117) data and Medical (MC141) Claims, and Pharmacy (PC108) Claims have been corrected and now all have matches.

Subscriber IDs on Member (ME117) data and Pharmacy (PC108) Claims have not been resolved and do not currently match. The APCD Technical Support team is working on transformation rules to resolve this issue. See data tip https://achiapcd.atlassian.net/wiki/x/EIDiG

Partially resolved in 24B

10155

WellCare

ME001_CAT has been updated to differentiate between Medicare Advantage plans (MCR_ADV) and Medicare Advantage Pharmacy plans (MCRAdvPhrm).

Informational

Important Information

  • The APCD Unique ID (ME998 or Hash ID) is consistent with the previous build.

  • Review the latest published on the APCD website for information about the latest data available.

  • Utilize the searchable Arkansas APCD data dictionaries and tip sheets (be sure to review all of them).

  • For high level descriptions of the APCD and its data, refer to the Arkansas APCD Infographic for a summary of the latest data available to data requesters.