Integrated chemical management system: A tool for managing chemical information at the Rocky Flats Environmental Technology Site Page: 4 of 21
This article is part of the collection entitled: Office of Scientific & Technical Information Technical Reports and was provided to UNT Digital Library by the UNT Libraries Government Documents Department.
Extracted Text
The following text was automatically extracted from the image on this page using optical character recognition software:
level. The sitewide data base lies "down
stream" the information flow and can
neither update nor modify chemical
data. Faster response times and
improved quality control have resulted
from placing the responsibility for data
processing at the facility level.
The ICMS operates on the
FileMaker Pro software platform. This
off-the-shelf, desk-top program provides
a user-friendly interface to access,
retrieve, sort and report chemical data.
FileMaker Pro operates on both IBM and
Apple hardware. The sitewide data base
at the SITE resides on a Power
Macintosh, Model 8100. Facility-level
data bases are installed on Apple
Macintosh CI or newer models.A.
Data BaseFacility-Level Chemical
The facility-level data base
forms the core of the ICMS. This data
base consists of three (3) main files:
Product, Empty, and Disposed (also
referred to as Waste). Access to other
files (MSDS, Chemical Exchange,
Synonyms) at the sitewide level is also
provided through the facility-level data
base.
The Product file stores
information on chemical types,
locations and quantities. Chemicals
entering a facility are tracked by unique
container codes. Storage locations
within the facility are identified by
unique location codes. These container
and location codes are imprinted on
electronically-readable bar code labels
and can be read with hand-held laser
scanners.Information on each
container is entered into the facility data
base via the data entry screen (Figure 2).
Container and location code
information may be entered from
scanners or manually along with the
chemical name, manufacturer, CAS #,
size, units, physical state and container
type. Additional information about the
chemical (i.e., NFPA ratings, availability
of Material Safety Data Sheet, status as a
carcinogen or reactive) also can be
entered by chemical users. Several
standard reports are available on
product chemicals or the chemical
owner develop custom reports using the
FileMaker Pro software.
Once the contents of a
container are exhausted, the record of
that container is transferred to the
Empty Container file. Information in
this file is identical to the Product file
(Figure 2) excepting the status has been
changed to "empty". The Empty
Container file allows the chemical
owner to track and report chemical use
for regulatory purposes including the
annual Form R report required by the
Emergency Planning and Community
Right-to-Know Act and the Clean Air
Act operating permit.
Records of containers
whose contents have been declared
waste, are transferred to the Waste
(Disposed) file. These records are
augmented with information on
compatibility and EPA codes, drum
numbers and storage units (Figure 3).
The Waste file completes the "grave"
portion of the "cradle-to-grave"
management of chemicals.
Upcoming Pages
Here’s what’s next.
Search Inside
This article can be searched. Note: Results may vary based on the legibility of text within the document.
Tools / Downloads
Get a copy of this page or view the extracted text.
Citing and Sharing
Basic information for referencing this web page. We also provide extended guidance on usage rights, references, copying or embedding.
Reference the current page of this Article.
Costain, D. Integrated chemical management system: A tool for managing chemical information at the Rocky Flats Environmental Technology Site, article, July 1, 1995; Golden, Colorado. (https://digital.library.unt.edu/ark:/67531/metadc791944/m1/4/: accessed April 24, 2024), University of North Texas Libraries, UNT Digital Library, https://digital.library.unt.edu; crediting UNT Libraries Government Documents Department.