title: Development of an exposure database and surveillance system for use by practicing OSH professionals.
abstract: This report summarizes the development of an occupational exposure database and surveillance system for use by health and safety professionals at Rocky Flats Environmental Technology Site (RFETS), a former nuclear weapons production facility. The site itself is currently in the cleanup stage with work expected to continue into 2006. The system was developed with the intent of helping health and safety personnel not only to manage and analyze exposure monitoring data, but also to identify exposure determinants during the highly variable cleanup work. Utilizing a series of focused meetings with health and safety personnel from two of the major contractors at RFETS, core data elements were established. These data elements were selected based on their utility for analysis and identification of exposure determinants. A task-based coding scheme was employed to better define the highly variable work. The coding scheme consisted of a two-tiered hierarchical list with a total of 34 possible combinations of work type and task. The data elements were incorporated into a Microsoft Access database with built-in data entry features to both promote consistency and limit entry choices to enable stratified analyses. In designing the system, emphasis was placed on the ability of end users to perform complex analyses and multiparameter queries to identify trends in their exposure data. A very flexible and user-friendly report generator was built into the system. This report generator allowed users to perform multiparameter queries using an intuitive system with very little training. In addition, a number of automated graphical analyses were built into the system, including exposure levels by any combination of building, date, employee, job classification, type of contaminant, work type or task, exposure levels over time, exposure levels relative to the permissible exposure limit (PELS), and distributions of exposure levels. Both of these interfaces, allow the user to "drill down" or gradually narrow query criteria to identify specific exposure determinants. A number of other industrial hygiene processes were automated by the use of this database. Exposure calculations were coded into the system to allow automatic calculation of time-weighted averages and sample volumes. In addition, a table containing all the PELs and other relevant occupational exposure limits was built into the system to allow automatic comparisons with the current standards. Finally, the process of generating reports for employee notification was automated. The implementation of this system demonstrates that an integrated database system can save time for a practicing hygienist as well as provide useful and more importantly, timely information to guide primary prevention efforts.
authors.affiliation: Tri-County Health Department, Commerce City, Colorado, USA.
authors.forename: M V
authors.initials: MV
authors.lastname: Van Dyke
authors.forename: A D
authors.initials: AD
authors.lastname: LaMontagne
authors.forename: J W
authors.initials: JW
authors.lastname: Martyny
authors.forename: A J
authors.initials: AJ
authors.lastname: Ruttenber
mesh_terms: D003120:Colorado; D016208:Databases, Factual; D003666:Decontamination; D006801:Humans; D016273:Occupational Exposure / Q000706:statistics & numerical data*; D011850:Radioactive Waste; D017751:Safety Management / Q000379:methods*; D012985:Software Design; D013597:Systems Analysis; D014481:United States
chemical_list: D011850:Radioactive Waste