EHS Auditing Data Model 1

The following is a data model for the Auditing component of the proposed EHS system, based discussions at the meeting of the EHS Auditing team on August 29, 2002. A table of definitions is included below the diagram.

EHS Audit Data Model

Description of Entities

Entity Description Examples

Citation A requirement defined by a government agency, or defined by MIT itself, related to proper procedures for the use of substances, equipment, or other Hazard Types within labs or other facilities

government_regulation A specific regulation associated with a Citation. If we know what government regulation is associated with each Citation, we will be able to run reports on auditing findings related to a given regulation.

self_assessment_item An item on a self-assessment list to be checked in a lab or other facility
Are all the caps fastened on the bottles?
Are all lab workers wearing safety glasses?

SA_category Self-assessment items may be grouped into categories for the purpose of reporting, or rotating through a list of items for periodic audits.

Hazard_type A generic class of hazards for which there are special procedures to be followed, training requirements, or government regulations
Chemicals
Lasers
Pathogenic agents

Hazard_type_group A categorization of hazard types
Biological
Radiation-related

Responsible_role The role of the person responsible for doing the self-assessment for a particular self_assessment_item
C-level person
EHS Office Lead Contact
PI

Facility_type The facility_type in which a particular Self_assessment_item is applicable
Laboratory
Machine shop

SA_result The results of a given self assessment item, as evaluated at a particular location on a particular day

lab_or_facility The lab or facility in which a particular self_assessment_item was evaluated

person_doing_SA The person who recorded the SA_result for a particular self_assessment_item at a particular location on a particular day

response_to_problem If a particular SA_result is unsatisfactory, then we need to keep a record of the response to the problem

Entity	Description	Examples
Citation	A requirement defined by a government agency, or defined by MIT itself, related to proper procedures for the use of substances, equipment, or other Hazard Types within labs or other facilities
government_regulation	A specific regulation associated with a Citation. If we know what government regulation is associated with each Citation, we will be able to run reports on auditing findings related to a given regulation.
self_assessment_item	An item on a self-assessment list to be checked in a lab or other facility	Are all the caps fastened on the bottles? Are all lab workers wearing safety glasses?
SA_category	Self-assessment items may be grouped into categories for the purpose of reporting, or rotating through a list of items for periodic audits.
Hazard_type	A generic class of hazards for which there are special procedures to be followed, training requirements, or government regulations	Chemicals Lasers Pathogenic agents
Hazard_type_group	A categorization of hazard types	Biological Radiation-related
Responsible_role	The role of the person responsible for doing the self-assessment for a particular self_assessment_item	C-level person EHS Office Lead Contact PI
Facility_type	The facility_type in which a particular Self_assessment_item is applicable	Laboratory Machine shop
SA_result	The results of a given self assessment item, as evaluated at a particular location on a particular day
lab_or_facility	The lab or facility in which a particular self_assessment_item was evaluated
person_doing_SA	The person who recorded the SA_result for a particular self_assessment_item at a particular location on a particular day
response_to_problem	If a particular SA_result is unsatisfactory, then we need to keep a record of the response to the problem