Arkansas APCD 23B Release Notes - September 2023

The Arkansas Healthcare Transparency Initiative (HTI) releases update to the Arkansas All-Payer Claims Database quarterly. The Arkansas APCD 23B database is now available.  The Arkansas APCD 23B release includes data through March 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.

DATA COVERAGE

Source Category

COVERAGE

Arkansas Works Data

Jan 2014 – March 2023

Commercial, Fully Insured Data

Jan 2013 – March 2023

Arkansas Employee Benefits Division Data

Jan 2013 – March 2023

Arkansas Medicaid Data

Jan 2013 – March 2023

Arkansas Qualified Health Plan Data

Jan 2014 – March 2023

Arkansas Medicare Data

Jan 2013 - Dec 2020

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 2021

Emergency Department Data (uninsured or self-pay patients)

Jan 2013 - Dec 2021

Cancer Registry Data

Jan 2013 - Dec 2020

Medical Marijuana Cardholders Data

Jan 2013 – Sept 2020

Arkansas Workers' Compensation Data

Jan 2013 – March 2023

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

99MCR1

Medicare

Applicable to state agency users only.

The Medicare Chronic Condition data is now available.

These data link to other MCR data on Bene_ID.

This table contains the following flags/information for 27 chronic conditions:

·       First occurrence date

·       Mid year indicator

·       End of year indicator

The data dictionary can be found here.

https://resdac.org/cms-data/files/mbsf-27-cc/data-documentation

Informational

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.

Informational

67369A

67369

67369F

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 https://achiapcd.atlassian.net/wiki/spaces/ADRS/pages/3154051093

Issue

68985

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.

Issue

69019

Ameritas/

Standard Insurance Company

This entity has submitted incorrectly formatted values in ME998. 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

 

Arkansas Employee Benefits Division (EBD)

EBD data is managed by several entities. It is recommended that EBD data be grouped using the business rules outlined in data tip https://achiapcd.atlassian.net/wiki/spaces/ADRS/pages/3213459524

New: Data is no longer received from 99EBD1 after 2022-05-31. All open segments have been closed with the date 2022-06-01.

Note, MedImpact, the new EBD PBM has data submission issues noted below.

Informational

83472

 

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 and the submitting entity will resubmit to correct them in the future.

Issue

 

Arkansas Department of Health (ADH) Cancer Registry Data

The Cancer Registry file layout has changed for years 2020 forward. It is now in the Version 2023 NAACCR layout. All field names have changed and more fields have been added. Use the look up instructions provided in the data dictionary to find field definitions and to map back to older data.

NOTE: Cancer registry data is always a complete file replacement.

Informational

99MDI1, 99MDI2, 99MDI3,

99MDI4, 99MDI5

MedImpact

MedImpact is a new pharmacy submitter. No versioning rules were provided. See Data Tip for interim versioning rules to be applied manually until they are applied to a future build.

Informational

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.

Issue

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.

Issue

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.

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.