IDDT Affiliation Code: Step-by-Step Guide

The Integrated Dual Disorder Treatment (IDDT) Affiliation Code is assigned to consumers receiving IDDT services who are enrolled in the State of Ohio's Multi-Agency Community Services Information System (MACSIS). The IDDT Affiliation Code gives the state, county boards, and service agencies the capacity to collect data and to examine indicators and outcomes systematically for IDDT consumers and to use this knowledge to inform and advance public policy, community service plans, and day-to-day service delivery locally and across the state.

This booklet is a practical guide to support this effort. The success of this initiative depends upon many people in Ohio's behavioral healthcare systems and, therefore, is written primarily for the following:
  • Agency providers
  • County boards
  • State of Ohio stakeholders¬†


  • 16-page booklet
  • A step-by-step guide
  • Free PDF


IDDT Affil Code ChecklistAt-A-Glance Checklist
One-pager to track your progress.
| get resource |

Message Board
Ask questions, get answers about the IDDT Affiliation Code. Visit the "Discussions" section of this website.

Consumer Roster
Free. Click to retrieve the file:

Sample SQL Code
Free. Click to retrieve the files:

Sample Table
Free. Click to retrieve the file:

Sample Reports
Free. Click to retrieve the file:


MACSIS Screen ShotUse this resource only for MACSIS-specific questions. Get help for:

  • Enrolling consumers
  • Navigating screens
  • Affiliation extract files

Contact MACSIS:

  • Call: 877-462-2747
  • Send email (click)
  • Get web site (click)


In September 2008, the State of Ohio commenced its "IDDT Affiliation Code Initiative," which included a pilot project that was a collaboration among the following:

  • Center for Evidence-Based Practices and its Ohio SAMI CCOE initiative
  • Ohio Department of Mental Health (ODMH)
  • Ohio Department of Alcohol and Drug Addiction Services (ODADAS)
  • Mental Health and Recovery Board of Ashland County

| learn more |


Integrated Dual Disorder Treatment (IDDT), the evidence-based practice, was developed and is studied by researchers at the Dartmouth Psychiatric Research Center of Dartmouth Medical School in Lebanon, New Hampshire. The researchers include Robert E. (Bob) Drake, MD, PhD, Kim T. Mueser, PhD, and their colleagues.


Title: IDDT Affiliation Code: Step-by-Step Guide
Author(s): Ohio IDDT Affiliation Code Partnership
Publication Year: 2008
Volume #: August
Publisher City: Cleveland, Ohio
Publisher Name: Center for Evidence-Based Practices, Case Western Reserve University
For fast resource download, right-click, save-target-as.
This resource is currently NOT in stock. However, a free download might be available on this page.
  • Ohio orders: $0/free PDF
  • Non-Ohio orders: $0/free PDF
This section applies only to products available from us. If an order form appears in the "Purchase Info" section above, ...
  • Print the form, complete it, mail or fax it to us.
  • Make checks payable to "Case Western Reserve University".
  • To pay by credit card, call our office.
  • If a free PDF is available, a link will appear above.
  • Our high-resolution PDFs (300 dpi) will print to a standard desktop printer
  • For best results, use a large-format color photocopier (try FedEx/Kinkos, Office Max/Copy Max).
  • Many local printers now have low-cost digital color printing, which will produce a high-quality output.
We invite and encourage you to add the hyperlink of this page to your website and to distribute it to anyone who might be interested.
  • IDDT Affiliation Code: Step-by-Step Guide

    This booklet and web page are practical guides for the IDDT Affiliation Code initiative, which gives the State of Ohio, county boards, and service agencies the capacity to collect data and to examine indicators and outcomes systematically for IDDT consumers in local communities and throughout the state. Free PDFs.

    | learn more |