Enterprise Asset Data Collection System for Public Water Utility Company
 | The Asset Data Collection System is a web-enabled project, designed with C# .NET on a Microsoft Windows server, for the public water utility company. The system was to manage all water utility production parts and network assets (Plant Equipment Data and Network Equipment Data from client-owned utility systems) for storage, retrieval, searching, reporting, and administration via an Oracle database. The software was to be user-friendly, easily accessible, secure, and reliable. Data was to be collected from electronic, hard-copy or field-gathered methods and entered directly into the web-enabled system. Previously, users were using paper formats, various small applications, excel spread sheets, some other major applications, etc. to conduct their businesses. The creation of an Enterprise Asset Management (EAM) system, increases efficiencies and optimizes the enterprise's facility and equipment life cycles. It increases the availability of asset information by developing widespread institutional knowledge and creates Enterprise wide consistency in the asset management process. The software allows users to input collection data for Production and Network Water company assets. Two main menu options are available to the user to access the appropriate input forms for these items. After adding an asset to the software, the user is provided with an asset reference ID name. The user may search for and modify his records at a later time and generate reports. Printable templates may be created by accessing the desired asset type module and pre-populating desired fields. The template is displayed and printed in a single-page format, which may be used by data collectors in the field for recording data. Administrative functionality within the software is available for administrative users. These users may create and edit users, change permissions, passwords, and account status. | | Upon authenticating and logging in to the system, users are presented with a main menu of options to manage Production and Network assets for the water utility company. Such assets include PWSID / NPDES, Facility, Class, Type, Sub-Type, Location, Attributes, Plant Equipment Data, Hydrant, Sewer Treatment, HVAC, Boilder, Electrode, Pipe, Tube, etc. The user may choose from Product or Network related assets. |  |  | From the Asset Data Entry screen, new assets may be added to the system. This example shows the creation of a Water Production Asset. Information is organized in a hierarchical fashion, allowing the user to drill down the information details until the exact asset is described. Additional detailed information, recorded from the actual plant, may be entered including Manufacturer, Serial Number, Model, Location, Priority, Legacy Equipment ID, Unit or Sub-Unit. |
|