[407] in magellan
Environmental Health & Safety Management System Bi-Weekly
daemon@ATHENA.MIT.EDU (Rob Smyser)
Thu Mar 2 09:36:45 2000
Message-Id: <200003021436.JAA17748@melbourne-city-street.MIT.EDU>
Date: Thu, 02 Mar 2000 09:40:06 -0500
To: magellan@mit.edu
From: Rob Smyser <smyser@MIT.EDU>
Cc: rclarke@mit.edu
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Project Name: EHSS (for short)
Project Leaders: Rob Smyser, Rocklyn Clarke
Report Date: 2/16/2000
Submitted by: Rob Smyser
URL: http://web.mit.edu/is/discovery/ehss/
Accomplishments past period:
- Received and started evaluating a "hazards volume shipped" database from
Jennifer combs of facilities. The database was used to plan the hazards
shipping to the Stata center loading dock. It was built from data
submitted by 8 vendors about what they actually shipped to MIT. The
chemical names alone are an invaluable resource for building databases of
our own. A similar annual report of "hazards on hand" is required for
SARA compliance.
- Met with Deborah Ellis, the chemicals buyer for Procurement, to discuss
the existing procurement process for chemicals. Captured a process map.
Goals for the coming period:
- define databases to support the Materials Master Data
- meet with Jim Repa to discuss the use of Roles to support hazmat training
and authorizations.
- codify the narrative-style user requirements gathered to date into
something more formal upon which to build some prototype databases and
reports.
- determine what line item purchasing data is captured now in the Data
Warehouse. For instance, can we see the short text description of every
line item in the 1320 (Chemicals) material group?
- build a glossary of terms (like SARA) for the project notebook.
Issues:
- just what does a suitable User Requirements report look like? Is the
grouper project a good example? Or who?
- there is some hope of having the vendors send us monthly reports on what
they've sent to MIT, as they did the one time for the Stata project. If
so, what hooks exist to integrate their report data into an Inventory
module of our EHSMS?
Key Learnings:
- there are many ways to buy chemicals, several of which don't lend
themselves to capturing line-item detail at the point of ordering.
Team Dynamics:
- all is well.
Additional Comments:
none
----------------
Rob Smyser Business Liaison Team, MIT Information Systems, N42-040
smyser@mit.edu 617.253.1358 http://web.mit.edu/blt
