Arkansas APCD Data Request Data Dictionaries

 Data field definitions supporting Arkansas All Payer Claims Database (APCD) data requests are provided in three data dictionaries. 

  1. Arkansas APCD Data Dictionary: Claims Based Data Dictionary
  2. Arkansas APCD Data Dictionary: Non-Claims Based Data Dictionary (Updated 9/22/2021 - new Cancer and Birth fields)
  3. Arkansas Medicare Data Dictionary Element List

Data requesters should reference these documents to better understand the data elements they want to request.  These documents can be used with the 2018 Data Attribute Supplement for Data Requesters  when selecting data elements for a data request.

 
These data dictionaries have corresponding data element lists for data requesters' use when selecting data elements for a data request.
 
The Arkansas APCD also provides downloadable reference tables, supporting the data dictionaries listed above. 

Arkansas APCD Data Dictionary: Claims Based Data

Claims based data sourced from commercial carriers and Arkansas Medicaid are available for all approved projects.  The Arkansas APCD Claims Based Data Dictionary contains all the data elements available for commercial carriers and Arkansas Medicaid.  It can be used to support standard or custom data requests.  If a custom data request includes new derived or aggregated fields, additional documentation will be provided when the data request is fulfilled with definitions and/or methodologies supporting these fields.

Table 1:  Commercial Carrier and Arkansas Medicaid Claims Based Data Categories

Source

Data Categories

Arkansas APCD Claims Based Data

(Commercial Carrier and Arkansas Medicaid)

 

Member Enrollment Data

Medical Claims Data

Pharmacy Claims Data

Dental Claims Data

Provider Data

Appendices (containing reference data supporting data elements defined in the data sections)

 

Arkansas Medicare Data Dictionary Resources

Arkansas Medicare data is available for state directed/state funded projects.  Arkansas Medicare data are also considered claims based data however these data are kept in their native state where possible.  It can be used to support standard or custom data requests.  If a custom data request includes new derived or aggregated fields, additional documentation will be provided when the data request is fulfilled with definitions and/or methodologies supporting these fields.

Except for state and county information, Arkansas Medicare beneficiary and claims data are provided in their native layout and have not been transformed to the Arkansas APCD layout. Available data elements are listed in the Arkansas Medicare Data Dictionary Element List  spreadsheet.  Each Arkansas Medicare data category is represented in a separate tab. Data transformations are noted in this data element list.

Arkansas Medicare data is sourced from the Centers for Medicaid and Medicare Services (CMS) and the Research Data Center (ResDAC).  These organizations have made available online information and data dictionaries that better represent the Arkansas Medicare data definitions. To find a data element definition, select the data element from the Arkansas Medicare Data Dictionary Element List spreadsheet and search for it at one of the resources in Table 2.

NOTE:  If postal values present in the data do not comply with the CMS/ResDAC data definitions. check Arkansas Medicare Data Dictionary Element List or the APCD Data Tips and Issues section for additional transformation information.
 

Table 2:  Arkansas Medicare Data Dictionary Resources

Resource

Link

ResDAC

https://www.resdac.org/

CMS Chronic Conditions Warehouse (CCW)

https://www.ccwdata.org/web/guest/data-dictionaries

CMS Part D Users Guide CMS Part D Users Guide

 

If a data element cannot be located at either of these sites, search for it using an internet search engine such as Google, Bing, or Yahoo.  If it still cannot be located, contact Arkansas APCD Technical Support.

Arkansas APCD Data Dictionary: Non-Claims Based Data

Non-claims based data sourced from the Arkansas Department of Health and Arkansas Workers’ Compensation Commission are available for all approved projects.  The Arkansas APCD Non-Claims Based Data Dictionary contains all the data elements available these data types.  It can be used to support standard or custom data requests.  If a custom data request includes new derived or aggregated fields, additional documentation will be provided when the data request is fulfilled with definitions and/or methodologies supporting these fields.

Table 3:  Non-Claims Based Data Categories

Source

Data Categories

Arkansas APCD Non-Claims Based Data

 

Sources:

Arkansas Department of Health (ADH)

Arkansas Workers’ Compensation (AWC)

ADH Birth Certificate Data

ADH Death Certificate Data

ADH Hospital Discharge Data (for self-pay and uninsured only)

ADH Emergency Department Data (for self-pay and uninsured only)

ADH Cancer Registry Data

Arkansas Medical Marijuana Cardholder Data (administered by ADH)

AWC Claims Data

AWC Form 2 Data

AWC Form 4 Data

AWC Claims Data