AWWA IMTECH57885

This paper describes a database that was developed for use by a consulting engineering firm for alltreatment facility design projects. That database manages data traditionally kept inequipment data sheets, but also allows for linking of electronic catalog files, digitalphotographs, and other supporting documentation. The database may be accesseddirectly through an application interface or by using a web browser. The design of thedatabase allows for the automatic generation of valve, piping, control device, andequipment schedules used in the contract documents. This automatic generation allowschanges to equipment numbering or naming to be reflected in the various contractdocuments, even late in the design process. A table of drawing references for each pieceof equipment is populated during the Quality Control (QC) review. Using this, queriesrun during the QC process will quickly show inconsistencies between the drawings andspecifications. Furthermore, the data are quickly accessible during the review of shopdrawingsto ensure that what was specified is actually installed. Next, the designinformation may be easily integrated into the electronic O&M manual, through the use ofstandardized database queries. Finally, the equipment data may be easily migrated fromthis database, to the owner's CMMS or SCADA databases, to ensure that the newequipment is reflected in the utility's databases immediately after startup. The use of suchan application improves the quality of the contract documents and speeds the migrationof design information from the plant designers to the utility personnel.

Product Details

Edition:

Vol. - No.

Published:

04/27/2003

Number of Pages:

13

File Size:

1 file , 570 KB