Report on the Final Integrated Data Base (IDB)

This 1999 report provides a detailed description of the activities involved in the development of the Integrated Data Base (IDB), which integrates mental health services, drug and alcohol services, and Medicaid data for three states (Delaware, Oklahoma, and Washington).

Volume 1 describes the general concept of the data base and the detailed design including extensive file definitions and information, flow charts and crosswalks. Separate sections detail the State-specific preprocessing activities, and other aspects of the data base. These are intended to help the researcher understand the approach we took in processing data for each State and data source. Since source data received for this project varied in terms of layout and content, each was processed separately according to the contents of the file. This volume also contains appendixes with detailed information on the selection of the population and contents of the final files.

Volume 2 contains all source code used in processing the data, including programs used to load State data into SAS and routines for linking person-level data. These programs can be viewed in any text editor (such as Notepad, BBEdit, or Emacs). This code is primarily of interest to programmers and other parties interested in how files were processed and constructed. Also included in Volume 2 is the users guide, which provides users of the data base with detailed technical information regarding the structure and composition of the data base. Electronic versions of the data dictionary with State-specific documentation are also included as part of this volume. 

Download Volume 1 (PDF): IDB_Report_Volume_1.pdf (539.03 kb)

Download Volume 2 (PDF): IDB_Report_Volume_2.pdf (195.98 kb)