Background:
Currently STD MIS is the only electronic tool for analysis of STD program work, but it is not entirely functional for the investigative process.

Objective:
To develop and implement a comprehensive electronic STD system that will reduce an STD investigator's administrative hours and increase accurate data flow.

Method:
Interface between data elements, investigation process, and reporting forms were analyzed to develop a Microsoft Access application that ensures accurate and reliable links between data elements. Design was heavily influenced by the need to configure reports to match NY State health department forms. Data entry safeguards and prompts were built into the screens to reduce data entry error and protect the database window. Search features for data retrieval, navigation, and report selection were made “one click driven” or “drop down list select”. A restricted access supervisor data management screen was incorporated. The database was password protected and placed on a restricted server.

Result:
The database was implemented in March 2007, using live data. The database has (1) considerably reduced redundant data entry by use of a single demographic screen, (2) increased data accuracy and facilitated data entry through use of drop down lists for commonly used data options, (3) generated all required NY State health department reports and multi-lingual patient letters via simple one click prompts, (4) facilitated supervisor and staff administrative duties, (5) ensured confidentiality via password protection and restricted server access, (6) allowed simultaneous multi-user data entry.

Conclusion:
This database has greatly reduced manual paperwork, increased accuracy of clinical data and improved the flow and communication of information, thereby allowing public health advisors to better focus on investigative activities.

Implications:
Development of a similar system on a National level, with possible linkages to STD MIS and other data systems could potentially improve data communication and reduce staff time spent in administrative duties.