Section C: OFFICB SUPPORT
<br />Page IO
<br />MAINTENANCE MANAGEMENT
<br />SYSTEM
<br />The computerized equipmenC maintenance man-
<br />agementsystem was implemented in late 1984. At
<br />that time, the plant had no centralized storeroom,
<br />parts were located throughout the plant. When the
<br />new stores clerk was hired, a major responsibility
<br />was to gather information on all equipment and
<br />enter it into the new system. Once in place, equip-
<br />ment maintenance schedules were established.
<br />Original preventive maintenance schedules were
<br />expanded to include mechanical, electrical, and
<br />instnunentation. In October 1985, the first pre-
<br />ventive maintenance schedules were sent to the
<br />mechanics.
<br />Once the preventive maintenance schedules were
<br />in place, work began on implementing the correc-
<br />tive maintenance portion of the system and on
<br />capturing data for inventory control. By March
<br />1987, the maintenance management system data
<br />was fully loaded. Problems with speed and storage
<br />ability were experienced. At that time, an AT286
<br />computer and video backup system was purchased
<br />that enhanced the speed of the maintenance man-
<br />agementsystem and provided additional disk stor-
<br />age.The video backup allowed staff to backup the
<br />system on one VCR tape rather than on floppy
<br />disks. In May 1987, a contact programmer was
<br />hired to upgrade the system from dBase 2 to dBase
<br />3.Other modifications occurred over the nextfew
<br />years, revising the system to meet the needs of the
<br />division.
<br />In May 1989, a MicroVAX computer and new
<br />digital terminals were purchased to capture the
<br />output from the new distributed control computer
<br />system. A software program called `Reflections"
<br />allowed the plant PCs to "communicate" with the
<br />MicroVAX. The M icroVAX also provided an elec-
<br />tronic mail system to help employees communi-
<br />catemore effectivelywithinthe division. Planning
<br />began to implement a new maintenance manage-
<br />ment system on the MicroVAX.
<br />A program called "20/20" was selected for spread-
<br />sheets, and "Oracle" was selected for database
<br />needs. Other electronic equipment purchased by
<br />the division included a Macintosh PC that pro-
<br />duced drawings, organizational charts, and other
<br />graphics and a second AT286 computer for an
<br />AUTOCAD programing with a digitizer and color
<br />printer for modification, storage, and printing of
<br />drawings.
<br />PROPERTY MANAGEMENT
<br />The Environmental Protection Agency (EPA)
<br />required that all assets purchased with EPA money
<br />be tracked and recorded by serial and model num-
<br />bers,purchase price, life expectancy, contractand
<br />grant numbers, manufacturer, owner (MWMC,
<br />City of Eugene, or City of Springfield) and the
<br />location of the asset. In late 1984, the plant began
<br />compiling the information required by the EPA.
<br />Over the next several years, staff also tracked
<br />assets not considered equipment, such as office
<br />furniture, lab equipment, vehicles, radios, elec-
<br />tronic equipment, computer equipment, shop
<br />equipment, and other miscellaneous assets. Asset
<br />tags were placed on any item that didn't have an
<br />equipment number. Although the EPA only re-
<br />quiredtracking ofitems valued at more than $300,
<br />for property management purposes the plant
<br />tracked some items of less value.
<br />In 1990, the EPA audit of the plant was to begin.
<br />In preparation, information from the audit report
<br />and from the City of Eugene's inventory informa-
<br />tionwere merged to produce a listing, by contract,
<br />of each asset purchased with grant monies. The
<br />purchase prices and life expectancies were re-
<br />viewedand revised as needed. The revised infor-
<br />mation was entered into the maintenance man-
<br />agement system, then downloaded to a spread-
<br />sheetand is now used by the City of Eugene and
<br />the MWMC to produce their annual audit report.
<br />DOCUMENT CONTROL
<br />The goal of the centralized document control
<br />system is to maintain copies of documents written
<br />or receivedby the division, thus reducing the need
<br />for individually maintained filing systems. The
<br />document control system was started in 1984. As
<br />documents were typed or received, they were
<br />routed to document control. Documents created
<br />internally were stored in the computer, and no
<br />paper copies were kept. A listing was maintained
<br />to reference where to find the document, i.e., and
<br />paper files, computer files, or computer backup. A
<br />standardnamingprocedureforelectronicfiles was
<br />used.
<br />
|