Asset Management Systems Functionality & Gap Analysis

Asset Management Systems Functionality & Gap Analysis

Asset Management System Desirables

Assets Section

  • Renewal Program Generation
  • Maintenance Scheduling
  • Asset Depreciation
  • Link to GIS
  • Must be capable of handling all asset classes including; Roads, Drainage, Water, Sewerage & Buildings, Fleet, etc
  • Browser based, and capable of generating a URL for every report
  • Users should be able to build and save custom queries/reports
  • Ability to link assets and facilities to a url
  • Open data specification/schema/format
  • Asset Register (ID, Name, Location, Manufacturers Details, Dimensions, Date of Purchase, Purchase From, Material Type)
  • Financial Recording & Reporting
  • Asset Classifications
  • Links to GIS, Lease Register
  • Customer request and work handling capabilities
  • Work costing linked to assets (Estimates is Best)
  • Failure mode classifications
  • Operations management (Insurance, Procedures, Leases, Risk, Contractors, Performance, Service levels)
  • Operations Monitoring (Asset utilisation, Energy usage, Action requests)
  • Maintenance Planning (Scheduling, resourcing, budgeting)
  • Maintenance History (Work done, failures, job costing/estimates, performance)
  • Capital Works planning (Condition scoring, Replacement cost)
  • Integration with GIS to allow leaks to be reported and associated with the asset at request creation. Closeout to confirm.
  • Simple Adhoc Queries

Water & Wastewater

  • Automatic generation of asset renewal programs from asset condition information.
  • Ability to accurately determine the current number of sewerage connections.
  • Inclusion of all water & wastewater asset components, including jump-ups, valves & hydrants
  • Job request system.
  • Performance based maintenance scheduling.
  • System Documentation

Trade Services

  • Customer Request system
  • Job Creation
  • Work Assigning
  • Work Prioritising
  • Work Escalation
  • Job Card Generation
  • Work activity reporting
  • Relevant asset data capture
  • Link to or integration with Asset register

Roads & Drainage

Environmental Services

  • Playground Inspection Program
  • Reporting on works completed and outstanding
  • Automatic CRM creation from inspections

Community Services

Governance

  • As few systems as possible
  • Proper close out of jobs in CRM

Software Deficiencies

Authority

  1. Dependent on costly external IT support

AMMS

  1. Scheduling not developed to the level required by Trade Services
  2. No Simple Adhoc Queries
  3. Dependent on continued internal IT support
  4. No Rolling Schedule Option
  5. Ability to edit an item's schedule. (Currently have to delete & reinstate)
  6. Ability to list equipment not belonging to a program
  7. Test Cycle and Date Due not displayed on Scheduled Activity Sheets
  8. No date on Scheduled Activity Sheets

CRM

  1. Dependent on costly external IT support

myData

  1. Existing disjointed table structure makes some sorts of queries virtually impossible
  2. No bulk handling
  3. No Rolling Schedule Option
  4. Work handling module not easy to use.
  5. Dependent on external IT support

myPredictor

  1. Dependent on external IT support

WHIP

  1. Not documented
  2. No Simple Adhoc Queries
  3. Dependent on continued internal IT support

Wiki

Software Functionality

Authority

AMMS

CRM

myData

myPredictor

WHIP

Wiki

Options

IF gaps are identified there are a number of options that need to be investigated to fill the gaps.

  1. IT to further develop WHIP & AMMS
  2. Assetic to further develop myData & myPredictor
  3. Civica to further develop Authority & CRM / AIM ????

If wasteful overlaps are identified, one or more of the systems could be phased out.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License