EH&S Training Data Model

Below is a data model for the training component of the EH&S system. This is an adjunct to the main EH&S data model. (Last updated 1/25/2002.)

Let's briefly describe the entities below and what they mean. Each entity is also described in a table below the data model. There will be rules (training-requirement-rules) that state what MIT-defined certification-types a person must have based on whether the person (1) works in one or more facility (lab or other facility type) under a given DLC, (2) performs a given function (e.g., "works with chemicals") in one or more facilities, or (3) works in a facility in which there exists a given hazard-type. For any given certification-type there are a set of cert-fulfillment-rules that state which training-modules and other-cert-requirements a person needs in order to be granted the MIT certification. Since MIT defines its own certification-types, we need to define how they are associated with specific government-regulations in order to do reports for government agencies such as the EPA or OSHA in their terminology.

Description of Entities

Entity	Description	Examples
DLC	A department-level organizational unit (Department, Lab, or Center)	Biology Mechanical Engineering Controllers Accounting Office Media Lab
Function	A business function that a person performs -- in this context, it will refer to a person's function within a laboratory or other facility	Works with chemicals Uses an irradiator Works in a Facility
Hazard-type	A class of materials (chemicals, biohazards, or radioactive substances) or type of equipment which requires special training or emergency response procedures	Chemical Radioactivity Laser Biohazard Extra hazardous material
Training-requirement-rule	One of a set of rules that determines which certification-types a person must obtain, based on the DLCs, functions, and/or hazard-types that a person is associated with	If you are affiliated with the dept. of Chemistry then you need Special Chem. Dept. Chemical Hygiene certification If you work with Select Agents, then you need Biohazard Cert. If you work in a lab with radioactive materials, then you need Radioactive Materials Certification
Government-regulation	A regulatory requirement from the EPA, OSHA, or other agency for which training is required. When a government agency wants a report, we translate MIT's certification-types into government-regulation descriptions.	TSCA RCRA
Certification-type	MIT's local terminology for a specific "license" or group of successfully completed courses, requirements, signatures, etc., that must be granted to a person as a prerequisite for handling or working with or near a class of hazardous substances or equipment (based on government regulations and MIT policies)	Standard chem. hygiene cert. Special Chem. Department chem. hygiene cert. Biohazard Certification Radioactive Materials Certification
Cert-fulfillment-rule	One of a set of cert-fulfillment-rules for a given certification-type that lists all of the course modules or other requirements that must be fulfilled in order to receive the given certification	For Radioactive Materials Certification you must pass training module 12345 For Radioactive Materials Certification you also need a signature on form XYZ from the RPO director
Training-module	A course unit that should be taken as a prerequisite for a certification-type
Other-cert-req	Something other than a training module that is part of the requirement for a certification-type	Signature on form XYZ from the RPO director A medical exam verifying you have healthy lungs