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 – June 2024 |
Commercial, Fully Insured Data | Jan 2013 – June 2024 |
Arkansas Employee Benefits Division Data | Jan 2013 – June 2024 |
Arkansas Medicaid Data | Jan 2013 – June 2024 |
Arkansas Qualified Health Plan Data | Jan 2014 – June 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 – June 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 for 24B. 99MDI1, 99MDI3, 99MDI4 and 99MDI5 are now correct. |
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 Pharmacy (PC108) Claims have been corrected and now have matches. Subscriber IDs on Member (ME117) data and Medical (MC141) Claims have been corrected and now have matches.
See data tip https://achiapcd.atlassian.net/wiki/x/EIDiG | 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 |
81973 | Aetna | An issue was discovered in older data where enrollment segments were incorrectly left open. The Arkansas APCD team worked with the data submitter to develop transformation rules identifying and correcting these segments. Data users should review enrollment analyses involving this submitter to ensure active members for this carrier are counted correctly. | Resolved in 24B |
60054A | Aetna | There are 26% distinct Pharmacy claims in 60054A data that are orphaned (the dental claim carrier specific unique member ID (PC107) does not exist in eligibility/member data (ME107) for this submitting entity). Resolution in development. | Issue |
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.
Add Comment