Friday, 12 December 2003
Sheraton Boston Hotel Grand Ballroom (1100)
EVAL-176-266

This presentation is part of EVAL-176. Poster Session

California Online Database for Enforcement (CODE): Past, Present, and Future

Rebecca A. Lourenco, MPH, State of California, Department of Health Services, Tobacco Control Section, rlourenc@dhs.ca.gov, Kieren Jameson, MLIS, Kierenj@etr.org.

Learning Objectives: Describe what the CODE system is and how information is entered by the California State-funded enforcement contracts and then collected by the California State Dept. of Health Services, Tobacco Control Section.

Abstract:
Problem/Objective: In October 2001, for the first time, the California Tobacco Control Section (TCS) funded enforcement projects to conduct site inspections and issue citations for violations of state and local tobacco control laws. TCS wanted to create a database for centralized systematic data collection of these enforcement activities.
Methods:TCS worked with the Tobacco Education Clearinghouse of California (TECC) for the greater part of 2002 to develop a web-based system (CODE) that would centralize data collection, increase validity of data collection, facilitate running agency-specific reports, and allow exporting of data. TECC also worked with 3 enforcement contracts to beta-test CODE in October 2002.
Results:From January 1, 2002 to March 18, 2003, a total of 10,913 site inspections were conducted by the 13 enforcement contracts. Of these 10,913 site inspections, 783 resulted in citations. The establishment type with the most issued citations was the "store" at 436 citations.
Conclusions: CODE is a state-of-the-art efficient data management system that standardizes and streamlines data collection across TCS enforcement contracts. In terms of the future and what is next for CODE, TCS and TECC hope to build the ability for non-enforcement contracts to run reports in CODE and also add optional fields to track prosectution status of issued citations.


Back to Poster Session
Back to Evaluation and Surveillance

Back to The 2003 National Conference on Tobacco or Health (December 10-12, 2003)