ADR: Tools for Reporting Client Medications

ADR: Tools for Reporting Client Medications

July 1, 2013

Data and Reporting TA Team (DART)

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(p. 20).

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

Rx-REX

Drug formulary in the ADR web system

Custom requests for Multum database tables

CAREWare

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.

Rx-REX

If you plan to use Rx-REX to create your XML file: You’ll first need to download the Rx-REX package, including the User Manual and sample ADR Client Tables.You’ll also need to install the Rx-REX application from the link provided. Note that you will need to get d-codes before you put your data into Rx-REX. For more help using Rx-REX, please refer to the User Manual.

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.