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 | Jan 2014 – December 2024 |
Commercial, Fully Insured Data | Jan 2013 – December 2024 |
Arkansas Employee Benefits Division Data | Jan 2013 – December 2024 |
Arkansas Medicaid Data | Jan 2013 – December 2024 |
Arkansas Qualified Health Plan Data | Jan 2014 – December 2024 |
Arkansas Medicare Data | Jan 2013 - Dec 2022 |
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 2023 |
Emergency Department Data (uninsured or self-pay patients) | Jan 2013 - Dec 2023 |
Cancer Registry Data | Jan 2013 - Dec 2021 |
Medical Marijuana Cardholders Data | Aug 2018 – Sept 2024 |
Arkansas Workers' Compensation Data | Jan 2013 – December 2024 |
Member Enrollment Selection Table (NEW!) | Jan 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 | ||||||||||||||||||
| 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.
| |||||||||||||||||||
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 | USAble HMO Partners (Both are Arkansas BCBS) | Pharmacy NPI (PC021) was corrected using a crosswalk file from Arkansas Blue Cross and Blue Shield (BCBS). | Resolved in 24C | ||||||||||||||||||
AETNA??? |
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.
0 Comments