Understanding the Data

Owned by Kathleen Hart (Unlicensed)
Last updated: Nov 06 2023 by Kenley Money
3 min read

Several tools are available to data requesters to optimize data use. These resources have been developed from the input of previous data analysts and data users to help data requesters more quickly use data and produce meaningful output.

Reach out to the HTI APCD Technical Support team with additional questions. Arkansas APCD Data Requests Support

Resource Name

Resource Link

Notes

Resource Name

Resource Link

Notes

Data Attributes/Linking

 

This presentation provides data requesters key information about the types of data contained in the Arkansas APCD and how they are linked and used together.

 

Data Tips

https://achiapcd.atlassian.net/wiki/spaces/ADRS/pages/2688090119

Includes tips for using the data and known issues with workarounds or resolutions.

Data Dictionaries

https://achiapcd.atlassian.net/wiki/spaces/AAR/pages/396689487

Data field definitions supporting Arkansas All Payer Claims Database (APCD) data requests are provided in several data dictionaries. Use in conjunction with Data Tips.

Data Request Infographic

https://achiapcd.atlassian.net/wiki/spaces/HTIR/pages/2621505562

The Arkansas APCD Infographic provides a high-level snapshot of the types of data available to data users.

Universe Counts

This reports contains counts by file types and years to help the data requester understand how much data is available for selection.

Data Element Frequency Counts

These reports provide row counts by data element value for all submitting entities combined. To help the data requester understand data coverage for selections.  Note, some data elements such as USPS ZIP code contain too many values to report here.  These can be obtained through a special request.

Claim Counts

 

These reports reports provide counts representing unique medical, pharmacy, or dental claims submitted by month from each submitting entity.  This information may be used to understand claim submission patterns by month and year. 

Population Distribution

 

 

What is included in the HTI Arkansas APCD?

  • The Arkansas APCD contains health insurance claims from fully insured plans, Arkansas Medicaid, Arkansas Medicare, and Arkansas Employee Benefits Division for state and public school employees

  • It does not contain health insurance claims for private, self-insured plans, small plans with fewer than 2,000 members, and the uninsured (leaving a gap in population numbers)

  • Enrollment distributions are illustrated in this pdf.

Data Release Notes

These notes are provided with each database release. They provide information about the Arkansas APCD updates, including new data, new features, changes, and issues that data users should know when using their data. 

Versioning Support Methodology

 

This methodology helps the data requester identify and manage claims data that has been updated  and/or adjusted.

Version Rank Methodology

 

This methodology helps the data requester identify the most recent version of an enrollment data.  This is applicable only if data requester receives all member records.  Best practice provides only the most recent record.