 Compliance:
EHS
Compliance: EHS is designed
to conduct environmental, health and safety assessments/audits
for government and corporate entities. The software
fulfills the requirements for a periodic assessment
required under the ISO 14000 standard for corporate
customers. It also satisfies the requirement of establishing
an Environmental Assessment program for government
agencies as stipulated in EO 13148 - Greening the
Government Through Leadership In Environmental Management.
This product was purchased by the United States Forest
Service and is being used nationwide to conduct the
environmental assessments. Compliance:
EHS is designed to work on a laptop for field use
or in a networked environment, enabling the system
to fit a variety of organizational requirements.
Compliance: EHS is divided into two modules: Administration
and Findings.
ADMINISTRATIVE MODULE
The Administration Module is used to customize the
program, instead of forcing users into a predefined
assessment model.
The Administration Module is used to: create and
modify protocols, define unique scoring for an assessment,
build a hierarchal model of any organization and
define security privilege profiles.
FINDINGS MODULE
The Findings Module is use by assessment personnel
to describe incidences of non-compliance and tie
them to a location and a protocol. The Findings
module (depending on user security privileges) has
the following features:
|
Create
and modify your organizational structure |
|
Attach
pictures to findings |
|
Create
and modify findings |
|
Enter
solutions and cost estimates |
|
Track
corrective actions associated with responsible
personnel |
|
Print
reports for planning and management |
|
Search
for regulations and findings |
|
E-mail
assessment data to management or other team
members |
The search tool helps assessment personnel retrieve
a specific finding or set of findings, and full-scale
reporting functions allow for delivery of:
|
Detailed
finding sheets for quality review |
|
Summarized
and prioritized breakdowns of your problem areass |
|
Cost
summaries for budgeting |
|
Corrective
action status so you can monitor the progress
of your solutions |
|
Provide
feedback to upper management |
The protocols loaded
into the system are the comprehensive TEAM guide
and safety protocols developed by the US Army Corps
of Engineers Construction Engineering Research Laboratory
(CERL). However, any protocol or policy may be entered
into the system.
The software also enables users to track the corrective
action progress associated with Findings. The Action
Tracking screen allows the organization to note
the costs and the steps taken to resolve the problem
areas.
HSMS
Services
Mannus and its personnel have been involved with the
Hazardous Substance Management System (HSMS) since
the program’s introduction into the DOD. The
HSMS system is used by DOD activities to manage their
centralized “pharmacies” where Hazardous
Materials on a military installation are tracked from
“cradle to grave.”
Mannus personnel are uniquely qualified to work with
and improve the data manipulation and integrity of
the system. The blend of computer and environmental
expertise are mandatory in order maximize the potential
of HSMS. Mannus has developed specialized capabitlities
to supplement HSMSs weaknesses in the areas of data
entry and reporting.
Mannus has developed tools to interface standard government
data systems with HSMS. The two primary data sources
that Mannus uses are the Fedlog and the Hazardous
Materials Information System (HMIS).
Additional sources include site specific Pollution
Prevention Plans or any other electronic source of
data that has information compatible with HSMS. The
tool was designed to perform four tasks: searching,
comparing extracting and uploading.
The search feature was designed to look for Manufacturer
(CAGE), NSN, Part Number, MilSpec, CAS Number, HMIS
MSDS number, and any searchable field in FedLog or
HMIS. The results were compared to inventory data
collected in the field or residing in other HM tracking
systems (HICS, etc) to find matches. When a match
was identified the tool extracted all of the data
in the standard systems to populate the required fields
in HSMS. The matches were stored in a Microsoft Access
format and cross-checked by the environmental and
logistics personnel to insure that the correct data
was identified. The tool was then used to upload the
data from the Access data to the HSMS system.
The link from Access to the Oracle was processed by
developing table links through extensible markup language
(XML). This process has enabled Mannus to load the
Material, Manufacturer and MSDS tables accurately
and in significantly less time than a hand searching
and loading operation. Mannus’s goal for data
entry side of HSMS is to develop a tool to allow users
to enter a NSN and a CAGE code and the system would
automatically extract the information from Fedlog
and populate HSMS. This same tool would be used to
extract MSDS data from HMIS and populate HSMS.
Mannus has the knowledge of HSMS and software programming
to develop Crystal Reports or develop custom reporting
software. Mannus personnel have modified numerous
Crystal Reports for various customers to meet site-specific
reporting requirements. In addition, Mannus programmers
have developed custom reporting tool to provide EPCRA
and Pollution Prevention reports from HSMS. The tool
allows users to obtain inventory and usage information
organized by location, chemical constituents and product
name. The tool was developed for Fort Knox in the
Delphi programming language and was distributed as
shareware at the Tri Services Pollution Conference.
The
newest Mannus product to support HSMS is the Authorized
Use List and the Ordering Module. These systems enable
the HSMS system to be migrated to the activity level
without installing the HSMS client or purchasing additional
Oracle licenses. The modules allow activity personnel
to request and order hazardous materials via a browser.
This system saves the activities and the Hazardous
Material Pharmacy several steps in the material ordering
and management process. The system allows the activity
to order the materials on line and enables the pharmacy
personnel to prepare the order before the activity
sends the personnel to pick up the requested materials.
The
system is built using Borland’s Delphi and ExpressWeb
framework. The browsers send the requests to an Apache
server that delegates them to the Mannus designed
module. The module performs actions against the Oracle
system and generates html to return to the browser.
The submit order triggers a server based email is
sent to the Hazardous Material Pharmacy personnel
for processing.
FAA
Environmental and Occupational Safety and Health Assessment
Software
The FAA contracted Mannus personnel to construct an
Environmental/Occupational Safety and Health Assessment
tool designed for field personnel.
The FAA design called for the field tool to upload
data to the Intranet/Oracle based Compliance and Project
Management Modules. The system was also required to
download software, protocol and facility updates.
The system uploads and downloads using HTTP and XML
with all data compressed for optimal performance and
to maintain data integrity. The tool enables users
the flexibility of preparing for assessments in different
regions of the country and uploading the data once
a viable connection to the intranet is established.
This process also allows the firewall to be maintained
as well as traditional security measures.
USACERL’s
Team Guide Import
USACERL personnel process Microsoft Word Team Guide
documents into Microsoft Access database using the
Team Guide Import program. The tool is designed to
aid Team Guide authors to standardize the development
of the protocols and to provide database versions
to its customers. The product converts Microsoft Word
documents into a Microsoft Access database. The tool
extracts data from Word and moves it into Access,
enabling USACERL’s Team Guide Customers to use
their protocols in a database environment.
WPAFB’s
Environmental Quality (EQ) database
The EQ system is used by AFMC to request, approve
and track funding for environmental projects. Mannus
aided in the design and construction of the system
using Delphi and a multi-tier Simple Object Access
Protocol (SOAP) architecture over secure HTTP.
Mannus
Corporation’s Internal Tools
Mannus has developed internal two internal tools used
to increase the performance of the data analyst, while
minimizing the input of the software programmer. The
Data transform program enables the data analyst
to load data into a high end server based database
(Oracle, Informix) from a laptop based Microsoft Access
or similar database. The system enables the data analyst
to set up the data migration instructions in XML in
order to perform the data translation. The tool, which
is built using Delphi, allows the user to map key
fields, replace serial numbers across numerous tables
and allows the input of large volumes of data directly
into the target system.
The
Data Evaluation tool is constructed in
Microsoft’s newest development language C#
(C-Sharp). The tool allows the data analyst to develop
scoring rules in XML that are used to compare similar
data or groups of data fields. The goal of the comparison
is to select the best group of data from the data
sets and to set the resultant set as primary reference
database. This “winning” data set is
then presented in a report comparison format against
the data that was used as the evaluation set in
order for the data analyst to check the validity
of the normalized data set. The rules may be changed
and the data re-evaluated prior to replacing existing
data with the new reference data base.
|
