4100.0: Tuesday, November 14, 2000 - Board 7

Abstract #9684

Locator: A relational database approach to improving adolescent study participant retention

Gary M. Dollard, BS, Patricia Perry, PhD, and Dawn A. Lambert-Wacey, MA. Services Research, NYS Office of Alcoholism and Substance Abuse Services, 1450 Western Ave, Albany, NY 12203, (518) 485-1136, GaryDollard@oasas.state.ny.us

Multi-wave surveys require high retention rates. To achieve the highest possible retention rates it is essential to maintain contact with participants throughout the duration of the data-gathering phase. Particular challenges are posed in tracking adolescent alcohol and other drug treatment recipients. Relational Database systems are an effective means of gathering and manipulating inter-related data concerning study participants. This information enables study administrators to identify, contact, re-establish contact and track previously interviewed participants, while complying with Human Subject confidentiality regulations. The Locator database is a cost effective relational database created and maintained using Microsoft Access that provides a significant level of protection coupled with network security and user protocols. The locator system can be administered from remote sites and multiple users at multiple sites can perform data entry. The system is constructed from several basic elements that are customizable and that perform primary functions based on core information for each of the participants. The data are obtained during initial interviews and subsequent contacts and updated by the database administrator. In addition to tracking and scheduling functions, information and reports for administrative purposes are easily created and modified. For example Locator provides real time ad hoc reporting to determine the current demographic profile of the study population or assist with research data management that can be exported in numerous standard formats. Locator has been developed and refined through a number of multi-wave studies. Locator’s development and design have built on previous findings and has improved retention rates as the studies have progressed.

Learning Objectives: 1. Recognize the importance of retention in multi-wave studies and the role of a Locator system in building high retention rates. 2. Describe the components and elements of the Locator system for collecting and outputting data to achieve high retention rates while aiding all aspects of the research data management process

Keywords: Adolescents, Methodology

Presenting author's disclosure statement:
Organization/institution whose products or services will be discussed: None
I have a significant financial interest/arrangement or affiliation with any organization/institution whose products or services are being discussed in this session.
Relationship: Funded by Substance Abuse and Mental Health Services Administration, Center for Substance Abuse Treatment, grant #1 KD 1 TI 11423

The 128th Annual Meeting of APHA