CASE.EDU:    HOME | DIRECTORIES | SEARCH
case western reserve university

OHIO SAMI CCOE

 
 
 

 


IMPRESSIVE NUMBERS

Ashland County is using IDDT-Affiliation-Code data to evaluate service utilization (hospital bed-days, crisis services) and costs of services for IDDT consumers in its community and has found a reduction of both with the onset of IDDT. For details, see “The Pilot Project” section below in the middle column.

 

 

1.


WHAT IS IT?

David C. Ross of the Mental Health and Recovery Board of Ashland County provides a quick explanation of the IDDT Affiliation Code, how it works, and why it proves useful.


Ross photo

David C. Ross, MA, LPCC, director of planning and evaluation at the Mental Health and Recovery Board of Ashland County.


Audio Listen to David C. Ross explain the affiliation code (2 min 5 sec).



2.


WHY DOES IT MATTER?

The reports generated with the IDDT Affiliation Code help county board members and agency providers quickly understand the impact of IDDT and make informed decisions.


Audio Listen to David C. Ross explain why this matters (1 min 17 sec).



3.


HOW ASHLAND COUNTY USES IT

Ashland County is linking data from different databases into a data table, then using the reporting function of Microsoft Excel to create graphs and charts to communicate with board members and stakeholders. For example, Ashland is examining usage of state hospital bed-days among IDDT consumers.

 

(For more information, see "The Pilot Project" section in the middle column.)


Audio Listen to David C. Ross explain how he uses the code (1 min 29 sec).



4.


SQL COMPUTER CODE & MESSAGE BOARD HELP GET THE JOB DONE

The affiliation code initiative makes use of Structured Query Language (SQL), which communicates with extract files from various databases, bringing a variety of information together. . . . Need more help understanding this?


Audio Listen to David C. Ross explain SQL code (1 min 18 sec).



5.


BEGIN TODAY

A message to county board members and agency providers throughout Ohio.

Audio Listen to David C. Ross' message to agencies and boards (39 sec).

SAMI Online




September 8, 2008

DEMONSTRATING THE IMPACT OF IDDT


Affiliation code more efficiently tracks consumer outcomes, IDDT effectiveness


—by Paul M. Kubek and Matthew K. Weiland

 

Audio Listen to David C. Ross of Ashland County explain the IDDT Affiliation Code Initiative (1 min 45 sec).


Columbus, OH--The Ohio SAMI CCOE—in partnership with the Ohio Department of Mental Health (ODMH), the Ohio Department of Alcohol and Drug Addiction Services (ODADAS), and the Mental Health and Recovery Board of Ashland County—announces the commencement of the IDDT Affiliation Code Initiative.

 

The initiative gives agency providers, county boards, and State of Ohio stakeholders 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 of Ohio. The IDDT Affiliation Code is assigned to consumers receiving IDDT services who are enrolled in the Multi-Agency Community Services Information System (MACSIS).

 

“The affiliation code enables community decision makers and researchers, among others, to draw together information that already exists in MACSIS to answer important questions in order to improve services and evaluate resource allocation,” says Deb Hrouda, MSSA, LISW, assistant director of research and evaluation at the Center for Evidence-Based Practices at Case Western Reserve University. “The affiliation code becomes the common denominator showing what types of integrated treatment services are utilized by consumers and the related outcomes.”

 

Hrouda emphasizes that use of the code will be rather simple, because the initiative is built upon MACSIS, which is a statewide database system that county boards are already using. The first phase of the initiative will focus on these three factors related to IDDT service:

  • Service utilization
  • Cost
  • Quality of life

 

IMPLEMENTATION TOOLS

Hrouda explains that the Ohio SAMI CCOE, the Ashland Board, ODMH, and ODADAS formed a workgroup this past winter to plan and implement a pilot test of the IDDT Affiliation Code. The process took several months and has culminated in the production of a number of free tools to help agency providers and boards integrate affiliation-code routines into their day-to-day work. These tools include the following:

  • Step-by-step guide (booklet) (click here)
  • Online message board for agency providers and county boards to post questions and get answers from the initiative’s partners (click here)
  • Web page of additional free resources (e.g., IDDT consumer roster, SQL computer code, data table, report templates) (click here)

 

CONSULTATION SERVICES

Consultants and trainers from the Ohio SAMI CCOE are available to provide technical assistance for utilization of the IDDT Affiliation Code and interpreting data. Agency providers and county boards that are implementing IDDT are encouraged to contact the consultant and trainer from the SAMI CCOE with whom they work and/or to make contact through the online IDDT Affiliation Code web page and message board (click here).




THE PILOT PROJECT

The Mental Health and Recovery Board of Ashland County volunteered to pilot test use of the IDDT Affiliation Code. In the process, it developed the computer code to generate reports from affiliation-code data. The board is using these tools to evaluate IDDT services in its county and to communicate with board members, agency providers, and advocates and stakeholders in its community.

 

We asked David C. Ross, MA, LPCC, director of planning and evaluation at the Ashland board, a few questions about his participation in the initiative.

 

WHAT IS THE IDDT AFFILIATION CODE?

DR: It is basically a code assigned to an individual within the service system that stays with the person regardless of the services he or she receives. For example, in the State of Ohio, there’s a database that’s strictly for reporting and recording outcomes information. There’s another system that is specific to capturing costs. The IDDT Affiliation Code is a bridge, if you will, between these different kinds of disparate databases.

 

WHY DID ASHLAND COUNTY GET INVOLVED IN THIS INITIATIVE?

Our field is not one that is always easy to explain to folks—what we do, how we do it, why we do it this way and not another way. It’s a constant education to present reports about programming at a level of clarity that we really haven’t had before the affiliation code. Most board members want to know:

  • What’s a program about and what’s it supposed to do?
  • Do people get better because of this program?
  • Does the program work and how much does it cost?

With the affiliation code, the tangible result [is that] we’re able to provide to our board members information that gives them a far better idea about what IDDT is and how it’s working in the county.

 

WHAT IS THE ADVANTAGE OF THE AFFILIATION CODE?

DR: If we know a consumer is in a specialized program like IDDT and we know the time frames of services, the boards and agencies can then access this data and evaluate service utilization, costs, and outcomes. In my mind, it’s a relatively pain-free way to track evidence-based practices, specifically Integrated Dual Disorder Treatment.

 

WHAT IS YOUR MESSAGE TO OTHER COUNTY BOARD MEMBERS THROUGHOUT THE STATE?

DR: I ask the boards and agencies who are implementing IDDT currently to give this process a try. It really doesn’t require much additional effort and in my opinion the payoff is well worth any efforts that will be expended.

 

 

WHAT HAS YOUR DATA ANALYSIS FOUND?

 

The people (n=)

+Listen to David Ross explain the data sample (2 min 48 sec).

 

DR: We looked at data for people in our county enrolled in IDDT during a six-year span—three years before they started IDDT services (pre-IDDT) and three years after they started (post-IDDT). The number of consumers varied. Sometimes there were 12, 19, or 20 consumers receiving services during the time span.

 

1.) Service utilization/ hospital bed-days

+ Look at the graph (click here).


+ Listen to David Ross discuss cost of hospital bed-days (1 min 38 sec).

+ Listen to David Ross discuss redirecting hospital bed-day dollars to IDDT (2 min 9 sec).

+ Listen to David Ross discuss redirecting hospital bed-day dollars to IDDT, part 2 (1 min 50 sec).

 

Summary

  • Pre-IDDT/2 to 3 years: 76 bed days (x $481 per day = $36,556)
  • Pre-IDDT/1 to 2 years: 52 bed days (x $481 per day = $25,012)
  • Pre-IDDT/1 year: 118 bed days (x $481 per day = $56,758)
  • Post-IDDT/1 year: 16 bed days (x $481 per day = $7,696)
  • Post-IDDT/1 to 2 years: 19 bed days (x $481 per day = $9,139)
  • Post-IDDT/2 to 3 years: 1 bed day (x $481 = $481)

 

Policy implications/decisions

DR: We are re-directing the dollars we receive from the Ohio Department of Mental Health to pay for hospital bed-day usage to support community-based IDDT services.

 

 

2.) Service utilization/ crisis services

+ Look at the graph (click here).

+ Listen to David Ross discuss the data (1 min 9 sec).

 

Summary

  • 23 hours of service = pre-IDDT/2 to 3 years
  • 67 hours = pre-IDDT/1 to 2 years
  • 87 hours = pre-IDDT/1 year
  • 71 hours = post-IDDT/1 year
  • 15 hours = post-IDDT/1 to 2 years
  • 12 hours = post-IDDT/2 to 3 years

 

Policy implications/decisions

DR: A decrease in hospital bed-days appears at the same time there is a decrease in crisis services, which has a direct impact on total average costs of services.

 

 

3.) Cost/ Total average cost per client per service

+ Look at the graph (click here).

+ Listen to David Ross discuss the data (4 min 5 sec).

 

Summary

DR: Average costs were calculated for the following services: hospital bed-days; mental health assessment from a non-physician; mental health crisis intervention; employment/vocational support; group psychiatric support; group counseling; individual psychiatric support; individual counseling; pharmacological management.

  • $23,693 = pre-IDDT/ 2 to 3 years
  • $18,322 = pre-IDDT/1 to 2 years
  • $18,194 = pre-IDDT/1 year
  • $12,469 = post-IDDT/1 year
  • $12,149 = post-IDDT/1 to 2 years
  • $6,883 = post-IDDT/2 to 3 years

 

Policy implications/decisions

DR: This data may help those agency providers and boards that are on-the-fence about IDDT to tip their decision to start implementation.

 

 

4.) Outcomes/ Quality-of-life scale

+ Look at the graph (not yet available).

+ Listen to David Ross discuss cost and outcomes data (1 min 31 sec).

+ Listen to David Ross discuss the State of Ohio's outcomes scalses (1 min 43 sec).

 

Summary

DR: We are still writing the SQL code to examine outcomes data from affiliation-code extract files, so we don’t have a report for this yet. I am very interested in seeing the results. We know that IDDT is decreasing costs and that’s important. But it’s just as important to see an improvement in consumer outcomes, such as their quality of life. The goal of services is to improve lives.




SHARE YOUR RESULTS

County boards and agency providers are encouraged to use the free computer code available online and to create their own code and share it via the IDDT Affiliation Code web page (click here).




ACADEMIC-COMMUNITY PARTNERSHIP

The Ohio SAMI CCOE is a program of the Center for Evidence-Based Practices at Case Western Reserve University, which is a partnership between the Mandel School of Applied Social Sciences and the Department of Psychiatry at the Case School of Medicine. The Center for EBPs works in collaboration with and is supported by the following:

  • Ohio Department of Mental Health
  • Ohio Department of Alcohol and Drug Addiction Services

 www.centerforebp.case.edu



Paul M. Kubek, MA, is director of communications and Matthew K. Weiland, MA, is senior writer, producer, and new-media specialist at the Center for Evidence-Based Practices at Case Western Reserve University.



SAMI eNews



guy at chalkboard image




Ashland and Columbus map image

 

ASHLAND COUNTY
AT-A-GLANCE

• Land area/square miles = 424

• Population = 54,727

• Persons per square mile = 124

• Median household income = $41,074

• Persons below poverty = 9.7%

• Unemployment in 2006 = 5.5%

(Source: www.fedstats.gov/qf/ states/39/39005.html)

 


MENTAL HEALTH SERVICES IN ASHLAND COUNTY, 2007-2008

• 2,200 = total number of people receiving publicly supported services

• 1,500 = adults

• 700 = children

• 1,200 = adults with severe mental illness (SMI)

• 12 to 35 = adults with co-occurring SMI and substance use disorders receiving IDDT services

 

(Source: Mental Health and Recovery Board of Ashland County)

 

+ Listen to Steve Stone, executive director of the Ashland Board (1 min 50 sec).

 


Hrouda photo


Deb Hrouda, MSSA, LISW, assistant director of research and evaluation at the Center for Evidence-Based Practices at Case Western Reserve University. Hrouda is a 1994 graduate of the Mandel School of Applied Social Sciences at Case.

 


IDDT AFFILIATION CODE INITIATIVE PARTNERSHIP

• Mental Health and Recovery Board of Ashland County

• Ohio Substance Abuse and Mental Illness Coordinating Center of Excellence (Ohio SAMI CCOE)

• Ohio Department of Mental Health (ODMH)

• Ohio Department of Alcohol and Drug Addiction Services (ODADAS)

 


THE MESSAGE BOARD

Service organizations and county boards throughout the state that are implementing IDDT are encouraged to make use of the IDDT Affiliation Code and consulting services of the Ohio SAMI CCOE regarding use of the code. Post your questions and get answers online.

 

| click here |

 


STEP-BY-STEP GUIDE

Learn how to use the IDDT Affiliation Code with this easy-to-use booklet, which is available as a free PDF.

 

| get free PDF |

 

Affiliation cover image

 


FREE TOOLS

A few free tools created by the Mental Health and Recovery Board of Ashland County will help you get started today.

• IDDT consumer roster

• SQL code

• Data table

• Sample reports

 

| click here |

 


AT-A-GLANCE CHECK LIST

Track your progress with this free PDF.

 

| get free PDF |