ADR: Tools for Reporting Client Medications

ADR: Tools for Reporting Client Medications

July 1, 2013
Data and Reporting TA Team

The ADAP Data Report (ADR) includes specific medications for client level data. The ADR uses the Drug Identification Code (d-code) for reporting drugs. For more information on which client medications to report, see the ADR Instruction Manual.

This page describes tools available for ADAPs to report client medications, including how to get the d-codes you need.

Why D-Codes?

There are many, many drugs with different names and product codes which vary across state data systems. HAB needed a way to standardize and simplify drug reporting for the ADR. D-Codes are unique 5 digit codes assigned by Multum. You may also see d-codes referenced as “DNUM” or drug number, or “DIN” which stands for drug identification number. The d-code is the same for all drugs with the same Generic Name. So, instead of needing to track and report hundreds of individual drug product codes for the ADR, there are just a few dozen d-codes you’ll need to report.

HAB has made several tools available for ADAPs to report client medications:

  • CAREWare
  • TRAX
  • Drug formulary in the ADR web system
  • Custom requests for Multum database tables


Grantees that use CAREWare will find the d-code for drugs embedded in the new version of CAREWare for the ADR. You’ll need to set up your ADAP formulary in the data system, and enter the medication that was dispensed to the client, start date, days dispensed, and cost. You need to make sure that you receive this information from your pharmacy, PBM or other provider.


TRAX (formerly RX-REX) is a free tool for converting ADAP client-level data files into the correctly structured XML file for ADR reporting. TRAX is available for grantees who don’t already input data into an ADR-ready system, such as CAREWare, and don’t have the resources to create the client-level data XML export for reporting. The TRAX download package also includes an instruction manual. There are several steps involved in using TRAX: Become familiar with the ADR data elements and identify the structure of the required input files. Prepare the input files, and use CHEX to check the data quality. Download and install TRAX, then load data into TRAX to create the client-level data XML file.

If you aren’t going to use CAREWare, and don’t already have the d-codes that you need to report: Don’t worry! HAB has three resources available to help you.

Drug Formulary in ADR Web System

Grantees may check the formulary in the ADR web system to obtain d-codes when the system is open. For accessing the d-codes in the ADR web system, simply open a report and click on Q7a-c on the left navigation menu and all the drugs are listed by generic name, brand name and d-code. Programmers have their pick of d-codes needed for ADR reporting.

Custom requests for Multum database tables

Multum information is provided in lookup tables. So, it is a good option if you use Access or SQL and are used to using lookup tables, or have a programmer who knows how to work with lookup tables. This database will enable you to collect, manage and submit required data to HAB. If Multum fits your needs, you will need to complete a form to request medication information from the Multum Drug Database. You can download the request form from the TARGET Center, or email [email protected] to request a copy.

HAB contracts with Lexicomp, the proprietors of the Multum database to allow HAB to provide medication information to their funded grantees. In order to be eligible to receive this information, you must use it for the purposes of HAB reporting outlined in your request, and you may not share it.