Environmental Health and Safety Project

Below is a list of various web-based documents related to the planning and decision making for the EHS project.

• Data models and technical notes (Jim Repa)
  • Definition of EHS-related functions in the Roles Database (updated 7/23/2004)
  • Description of tables and views related to the Labs Database (from ehsweb). Updated 2/26/2003.
  • A newer data model - simplified model of EHS required data, prepared for "data requirements intersection" meeting of September 4, 2002
  • A data model for the EHS Auditing component.
  • A data model for laboratories (or other facilities), rooms, environmental hazards, people's roles, etc.
  • A training-related data model to complement the main EHS data model
  • Description of Training Requirements and Records Component (a work in progress as of 10/28/2003)
  • Description of phase I training solution using Traincasters plus a front-end server at MIT (document written 9/20/2002)
  • Specifications and samples for training-related servers (Traincasters, SAP, Kevin Cunningham's FileMaker DB, etc.)
    • Specifications for data transfers to/from Traincasters and other training-related servers
    • Sample forms document for testing MIT -> Traincasters data transfer via forms variables
  • Specifications for the proposed, simple, Authorized Project component:
    • New specs for Andrey (updated January, 2004)
    • More specs and info
  • Training requirements
    • Training notification of uncompleted courses: specifications
      • Review the format of the Email message
    • Training registration web pages
    • Training administrators' tools and reports
    • Tables for training requirements database
    • Companion to "tables for training reqs DB" document: Sample data for training requirements database tables
    • Notes and questions related to determining training requirements
    • Diagrams of activities and related training requirements
      • Radiation-related training (from August, 2002 meeting)
      • Biosafety-related training (from September, 2002 meeting)
    • Draft proposal for enhancements to EHSWEB for handling training data for people gone from MIT (6/30/2004)
    • Draft proposal for enhancements to EHSWEB for academic subject-based certification requirements (7/16/2004)

• Other documents
  • New: Proposed systems-related tasks, with a timeline (revised 9/30/2002). Download this Excel spreadsheet
  • Spreadsheet of short-term questions to be answered (from Thursday EHS team leaders meeting of 3/14/2002)
  • A different copy of the spreadsheet of short-term questions with proposed answers from Jim Repa.

• Labs Database
  • Task items for Lab registration (revised October 3, 2002)
  • Tentative list of hazard types (revised October 29, 2002)
  • The Labs Database is an interim system that will be used to record information on labs and other facilities. A prototype web-based interface is available.

    You need special authorizations to access the web interface to the prototype system. If you have been authorized to use is, you can try the web interface to the Labs Database.