Skip to end of banner
Go to start of banner

Arkansas APCD 23D Release Notes - June 2024

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

The Arkansas Healthcare Transparency Initiative (HTI) releases update 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.

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

Jan 2013 – Sept 2020

Arkansas Workers' Compensation Data

Jan 2013 – Dec 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

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

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 Issue: Cigna Entity Study ID

Issue

Resolved for 67369 and 67369F in 23D.

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.

Resolved for 23C.

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

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. Issue: Versioning for MedImpact Entities

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: MedImpact Pharmacy Orphans INTERNAL NOTE: for 23D need to change this data tip!

Partially resolved for 23C. 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.

Issue: United Health Care (99UHC1) missing enrollment data INTERNAL NOTE: for 23D need to change this data tip!

Resolved for 23C. 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.

Issue: CareSource PASSE orphans INTERNAL NOTE: for 23D need to change this data tip!

Resolved for 23C.

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.

  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.