Print      Open PDF Version of Online Help

Previous Topic

Next Topic

Adding DEA Information to Contact Addresses

Contacts in the pharmaceutical or medical industry in the U.S. use a Drug Enforcement Administration (DEA) number to receive controlled substances from suppliers. For example, a physician might work in several different hospitals and require a different DEA number for each location to receive controlled substances or pharmaceuticals at each location. Complete the following procedure to add DEA numbers to a contact address record.

Before you begin. The DEA fields are not available on a Contact Address page by default. Your company administrator must customize the Contact Address Detail page and allow access for you to add DEA information to a contact address.

About DEA Numbers

A DEA number is a series of numbers assigned to a health care provider (such as a medical practitioner, dentist, veterinarian) allowing the provider to write prescriptions for controlled substances. The DEA number is used to track controlled substances. However, it is often used by the pharmaceutical or medical industry as a general prescriber number; that is, it is used as a unique identifier for anyone who can prescribe medication. A valid DEA number consists of: two letters, six numbers, and one check digit. The first letter is a code identifying the type of registrant. The second letter is the first letter of the registrant's last name. Of the seven digits that follow, the seventh digit is a checksum that is calculated as follows:

  • Add together the first, third, and fifth digits. Call this SUM135.
  • Add together the second, fourth and sixth digits and multiply the sum by 2. Call this DoubleSUM246.
  • Add SUM135 and DoubleSum246. Call this CHECK.
  • The rightmost digit of CHECK is used as the check digit in the DEA number.

For example, the DEA string XY1234563 meets the requirements as follows:

1 + 3 + 5 = 9

2*(2+4+6) = 24

9 + 24 = 33

The last digit is 3.

The registrant type (the first letter of the DEA number) can be one of the following:

  • A - Deprecated (It can be used by some older entities.)
  • B - Hospital/Clinic
  • C - Practitioner
  • D - Teaching Institution
  • E - Manufacturer
  • F - Distributor
  • G - Researcher
  • H - Analytical Lab
  • J - Importer
  • K - Exporter
  • L - Reverse Distributor
  • M - Mid-Level Practitioner
  • N - Military Practitioner
  • P - Narcotic Treatment Program
  • R - Narcotic Treatment Program
  • S - Narcotic Treatment Program
  • T - Narcotic Treatment Program
  • U - Narcotic Treatment Program
  • X - Suboxone/Subutex Prescribing Program

To add DEA information to a contact address

  1. On a Contact Detail page, navigate to the Addresses section, if this section is configured.
  2. From the list of addresses, select Edit from the record-level menu (if shared addressing is configured), or Edit Rel (if shared addressing is not configured, and you are configured to access the top-level Address records).
  3. Complete the DEA fields as described in the following table, and then save the Contact Address record.

    DEA Field


    DEA Number

    A valid DEA number.                                                                                    

    DEA Issue Date

    The date when the DEA number is issued from the Federal Government of the United States. Use the Date selector to specify the date.

    DEA End Date

    The date when the DEA number is no longer active or valid. Use the Date selector to specify the date. This field displays the DEA issue date plus three years by default.

    DEA Active Flag

    Read-only field. Oracle CRM On Demand determines whether the DEA number is active or inactive. Oracle CRM On Demand uses the DEA Issue Date, the DEA End Date, and the current date to determine the status.

    Acceptable Schedules

    A long text field where you can enter comma separated values for acceptable schedules, for example, Schedule 1, Schedule 2, Schedule 3, and so on.

    NOTE: This field does not affect any Oracle CRM On Demand processing.

Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.