EHS Data Model 2

Here a new version of the EHS data model, updated for a meeting on September 3, 2002. A table of definitions is included below the diagram. (If your browser has problems displaying the diagram below, try this bigger version).

EHS Data Model

Description of Entities

Entity Description Examples

DLC A department-level organizational unit (Department, Lab, or Center)
Biology
Mechanical Engineering
Controllers Accounting Office
Media Lab

EHSO_lead_contact A person within the EHS Office assigned to work with a DLC to promote compliance and reporting of EHS-related issues
Joe (ID #946315439)
Sally (ID #987654321)

DLC_coordinator A person within the DLC with responsibility for EHS-related compliance and reporting
Betty (ID #900123456)
Bill (ID #900035711)

Room A room within a building at MIT
56-202
E19-010

Facility A group of one or more rooms used as a laboratory, shop, storage area, etc., where there are regulated substances (chemicals, biologicals, or radioactives), equipment (e.g., lasers, irradiators), or activities.
Prof. Smith's 4th floor bld 16 lab suite
E19 basement machine shop

Facility-type Type of facility
Laboratory suite
Machine shop
Stock room

Function A function or activity that a person performs in a laboratory or other facility that is related to training or other regulations

Works with chemicals
Uses an irradiator
Works in a Facility

Person An MIT employee, student, or affiliate
Joe (ID #946315439)
Sally (ID #987654321)

Role-within-lab A person+function+qualifier (in this case, the qualifier is a facility)

"Joe", "Uses chemicals", "4th floor bld 16 lab suite"
"Sally", "Facility Safety Coordinator", "4th floor bld 16 lab suite"

Hazard-type A generic category of substances or a type of equipment for which there may be training, certification, or policy requirements
Chemical
Radioactivity
Lasers
Large quantities of oil
Biohazard
Chemicals

PI_Supervisor A Principal Investigator or other person responsible for a lab or other facility

Certification-type MIT's local terminology for a sort of "license" required as a prerequisite for handling or working with or near a class of hazardous substances or equipment. This is linked to a group of required courses, signatures, examinations, etc. that must be completed before a person is given "certification" to work with a type of hazardous substances or equipment. Rules for who needs a certification_type are based on a combination of DLC, Function, Hazard-type, and/or Job title.
Standard chem. hygiene cert.
Special Chem. Department
chem. hygiene cert.
Biohazard Certification
Radioactive Materials Certification

Training-module A course unit that should be taken as a prerequisite for a certification-type

Job_Title An official MIT job title that is linked to certification and training requirements. Job titles for employees of the Department of Facilities will be useful for determining certification and training requirements. Within academic areas, job titles cannot be used for this determination; instead, we will use the more specific list of a person's Roles_within_facilities
Electrician
Vehicle mechanic

Entity	Description	Examples
DLC	A department-level organizational unit (Department, Lab, or Center)	Biology Mechanical Engineering Controllers Accounting Office Media Lab
EHSO_lead_contact	A person within the EHS Office assigned to work with a DLC to promote compliance and reporting of EHS-related issues	Joe (ID #946315439) Sally (ID #987654321)
DLC_coordinator	A person within the DLC with responsibility for EHS-related compliance and reporting	Betty (ID #900123456) Bill (ID #900035711)
Room	A room within a building at MIT	56-202 E19-010
Facility	A group of one or more rooms used as a laboratory, shop, storage area, etc., where there are regulated substances (chemicals, biologicals, or radioactives), equipment (e.g., lasers, irradiators), or activities.	Prof. Smith's 4th floor bld 16 lab suite E19 basement machine shop
Facility-type	Type of facility	Laboratory suite Machine shop Stock room
Function	A function or activity that a person performs in a laboratory or other facility that is related to training or other regulations	Works with chemicals Uses an irradiator Works in a Facility
Person	An MIT employee, student, or affiliate	Joe (ID #946315439) Sally (ID #987654321)
Role-within-lab	A person+function+qualifier (in this case, the qualifier is a facility)	"Joe", "Uses chemicals", "4th floor bld 16 lab suite" "Sally", "Facility Safety Coordinator", "4th floor bld 16 lab suite"
Hazard-type	A generic category of substances or a type of equipment for which there may be training, certification, or policy requirements	Chemical Radioactivity Lasers Large quantities of oil Biohazard Chemicals
PI_Supervisor	A Principal Investigator or other person responsible for a lab or other facility
Certification-type	MIT's local terminology for a sort of "license" required as a prerequisite for handling or working with or near a class of hazardous substances or equipment. This is linked to a group of required courses, signatures, examinations, etc. that must be completed before a person is given "certification" to work with a type of hazardous substances or equipment. Rules for who needs a certification_type are based on a combination of DLC, Function, Hazard-type, and/or Job title.	Standard chem. hygiene cert. Special Chem. Department chem. hygiene cert. Biohazard Certification Radioactive Materials Certification
Training-module	A course unit that should be taken as a prerequisite for a certification-type
Job_Title	An official MIT job title that is linked to certification and training requirements. Job titles for employees of the Department of Facilities will be useful for determining certification and training requirements. Within academic areas, job titles cannot be used for this determination; instead, we will use the more specific list of a person's Roles_within_facilities	Electrician Vehicle mechanic