Arkansas APCD 24C Release Notes - March 2025 (internal)
- Kenley Money
- Ashley Sigler
The Arkansas Healthcare Transparency Initiative (HTI) releases updates to the Arkansas All-Payer Claims Database quarterly. The Arkansas APCD 24C database is now available. The Arkansas APCD 24C release includes data through December 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 | January 2014 – December 2024 |
Commercial, Fully Insured Data | January 2013 – December 2024 |
Arkansas Employee Benefits Division Data | January 2013 – December 2024 |
Arkansas Medicaid Data | January 2013 – December 2024 |
Arkansas Qualified Health Plan Data | January 2014 – December 2024 |
Arkansas Medicare Data | January 2013 - December 2022 |
Vital Statistics Data - Arkansas Birth Certificate Data | January 2013 - December 2023 |
Vital Statistics Data - Arkansas Death Certificate Data | January 2013 - December 2023 |
Inpatient Hospital Discharge Data (uninsured or self-pay patients) | January 2013 - December 2023 |
Emergency Department Data (uninsured or self-pay patients) | January 2013 - December 2023 |
Cancer Registry Data | January 2013 - December 2021 |
Medical Marijuana Cardholders Data | August 2018 – September 2024 |
Arkansas Workers' Compensation Data | January 2013 – December 2024 |
Member Enrollment Selection Table (NEW!) | January 2016 - June 2024 |
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 | ||||||||||||||||||
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.
Update: Issues with 99MDI1 and 99MDI3 have been resolved. | Partially resolved. 99MDI1, 99MDI3, 99MDI4 and 99MDI5 are now correct. | ||||||||||||||||||
99MDI1, 99MDI2, 99MDI3, 99MDI4, 99MDI5 | MedImpact | MedImpact submitting data without versioning requirements, stating that their data could not be versioned. Investigation revealed that there was a versioning method. All MedImpact data in this release has been versioned. Counts for the 24C build will be lower as only the most current, versioned claims will be selected.
| Informational | ||||||||||||||||||
10155 | WellCare | ME001_CAT has been updated to differentiate between Medicare Advantage plans (MCR_ADV) and Medicare Advantage Pharmacy plans (MCRAdvPhrm). | Informational | ||||||||||||||||||
70998A, 95448A | QualChoice | Pharmacy NPIs (PC021) on the pharmacy claims records for these QualChoice entities were populated using the APCD provider data (PV023) when missing on the pharmacy claim records. Not all pharmacy NPIs were populated because of data quality issues between the claims records and the provider data. | Resolved in 24C | ||||||||||||||||||
99MCD1 | Medicaid | Duplicate enrollment records were identified in Arkansas Medicaid enrollment records because of conflicting data points used to set versionrank. These have been resolved so no duplicate enrollment records exist with versionrank = 1. | Resolved in 24C | ||||||||||||||||||
17096 99NAV1 99ESA1 | Caresource Navitus Express Scripts | ME001_CAT has been changed from COM to PASSE for all 17096 records. ME001_CAT has been changed from COM to EBD_PBM for all 99NAV1 records. ME001_CAT has been changed from COM to QHP for all 99ESA1 records when HIOS ID (ME992) ends in the following values: 00, 01, 02, 03, 04, 05, 06. ME001_CAT has been changed from COM to MCD_QHP for all 99ESA1 records when HIOS ID (ME992) ends in the following values: 32, 36, 21, 41, 61,81, 11. | Informational | ||||||||||||||||||
83470 95442 16751 | USAble HMO Partners (All are Arkansas BCBS) | Pharmacy NPI (PC021) was corrected using a crosswalk file from Arkansas Blue Cross and Blue Shield (BCBS). | Resolved in 24C | ||||||||||||||||||
60054A | AETNA | There are 26% distinct Pharmacy claims in 60054A data that are orphaned (the pharmacy claim carrier specific unique member ID (PC107) does not exist in eligibility/member data (ME107) for this submitting entity). The orphaned records are from 2019 and earlier. No resolution possible. | Informational |
Important Information
The APCD Unique ID (ME998, Hash ID, or Study 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.