The Arkansas Healthcare Transparency Initiative (HTI) releases updates to the Arkansas All-Payer Claims Database quarterly. The Arkansas APCD 23D database is now available. The Arkansas APCD 23D release includes data through December 2023. 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 – Dec 2023 |
Commercial, Fully Insured Data | Jan 2013 – Dec 2023 |
Arkansas Employee Benefits Division Data | Jan 2013 – Dec 2023 |
Arkansas Medicaid Data | Jan 2013 – Dec 2023 |
Arkansas Qualified Health Plan Data | Jan 2014 – Dec 2023 |
Arkansas Medicare Data | Jan 2013 - Dec 2021 |
Vital Statistics Data - Arkansas Birth Certificate Data | Jan 2013 - Dec 2022 |
Vital Statistics Data - Arkansas Death Certificate Data | Jan 2013 - Dec 2022 |
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 – Dec 2023 |
Member Enrollment Selection Table (NEW!) | Jan 2016 - Dec 2022 |
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 |
47155 | Delta Dental | An internal system change at Delta Dental resulted in a data submission gap in which updated records were not received when an enrollment segment closed. Replacement data has been received and applied to years 2015 forward, correcting disenrollment dates (ME163A) to close segments appropriately. NOTE: Some disenrollment dates for years 2013 and 2014 are still open. A methodology has been identified to close them and this processing will occur in the next build. See Data Tip 0080. | Resolved for 23D. Disenrollment dates have been closed. |
67369A
67369B 99CIG2 | Cigna | Values in the APCD_Unique_ID (ME998) are formatted incorrectly on all Cigna member records preventing matching members from other submitting entities. See Data Tip Issue: Cigna Entity Study ID | Issue Resolved for 67369 and 67369F in 23D. |
62049 | Unum | The APCD_Unique_ID (ME998) has been found to contain invalid values for Q3 of 2022. These data will not be included in data releases until the issue is resolved. | Issue |
69019 | Ameritas/ Standard Insurance Company | This entity has 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. | Resolved for 23D. |
99MDI1, 99MDI2, 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. | Partially resolved for 23D. 99MDI4 and 99MDI5 are now correct. |
99UHC1 | United Healthcare | Enrollment data for pharmacy claims supplied by United Healthcare for the University of Central Arkansas has not been submitted. These claims data are usable for studies that do not require enrollment or plan information. The Arkansas APCD team is working with United Healthcare to receive the data. | Resolved for 23D. All 99UHC1 data has been moved to 79413A. |
17096 | CareSource | CareSource is a new submitting entity submitting PASSE data. It submits enrollment, medical and pharmacy claims data. The member IDs on the pharmacy data are not the same format as those on enrollment and claims data. The Arkansas APCD team is working with CareSource to receive the data. | Resolved for 23D. |
68985 62049 | Starmount/ Unum | Field values are incorrectly mapped for this data submitter. 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. | Resolved for 23D. |
83470 | Arkansas Blue Cross and Blue Shield | Less than 1% of medical claim records contain the value 9999-12-31 in Service date (MC059) and paid date (MC017). These are considered invalid. | Informational |
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. | 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