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.
...
Source Category | COVERAGE |
Arkansas Works Data | Jan 2014 – March June 2024 |
Commercial, Fully Insured Data | Jan 2013 – March June 2024 |
Arkansas Employee Benefits Division Data | Jan 2013 – March June 2024 |
Arkansas Medicaid Data | Jan 2013 – March June 2024 |
Arkansas Qualified Health Plan Data | Jan 2014 – March June 2024 |
Arkansas Medicare Data | Jan 2013 - Dec 20212022 |
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 20222023 |
Emergency Department Data (uninsured or self-pay patients) | Jan 2013 - Dec 20222023 |
Cancer Registry Data | Jan 2013 - Dec 20202021 |
Medical Marijuana Cardholders Data | Aug 2018 – Dec 2022Sept 2024 |
Arkansas Workers' Compensation Data | Jan 2013 – March June 2024 |
Member Enrollment Selection Table (NEW!) | Jan 2016 - Dec 2023June 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.
...
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|||
| , 99MDI3
| 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 | 24A24B. 99MDI1, 99MDI3, 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. | |
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 Pharmacy (MC141PC108) Claims , and Pharmacy (PC108have been corrected and now have matches. Subscriber IDs on Member (ME117) data and Medical (MC141) Claims have been corrected and now all have matches.
See data tip https://achiapcd.atlassian.net/wiki/x/EIDiG | Partially resolved 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.