This is an HTML version of an attachment to the Official Information request 'Proposed new IT system'.
Application Name
Description
Targetted for replacement
Aconex is an online (Internet web site) document management, web collaboration and project management software for construction, engineering and facility 
management.  
It is being used by the City Housing project management team for the housing upgrade programme of work and is also used by one staff member in Building Consent and 
Compliance to help Christchurch City Council to process some of their consent backlog.
Aconex
Used by Building Resilience for managing information on the Seismic Upgrade project for the town hall.
Y
Active Network - Recreational 
Bookings
This is an online recreation facility booking system. It is currently limited to Learn to Swim and Aquatic courses bookings only.
Y
CLASS is an application managing Recreational Facilities, including Pools, Recreation Centres and Sports grounds, Memberships, Courses and Enterprise front of house 
ActiveNetwork - CLASS
cashiering functions.
Y
Payment Manager is an application provided by Active Network. It is a module of the ActiveNetwork CLASS system.  It is used for secure point of sale and cash receipting. 
ActiveNetwork - Payment Manager The main users of Payment Manager are the Service Centre, Parks and Recreation.
Y
BO (Housing)
Reporting
Y
BOXI (BPR)
Y
BOXI is a single reporting platform which can be accessed by all members of a business unit, or across the Council if required. Business Objects InfoView collects and 
presents business intelligence information and provides: 
1) Complete viewing and interaction for query & analysis, reporting, and performance management
2) Integrated collaboration with threaded discussions, intuitive navigation, and support for 3rd party documents
3) Advanced scheduling and distribution capabilities making it easier to share information with others
4)  On Demand services that enable users to easily access a wide variety of shared information.
Business Objects BOXI
Y
Cemeteries Search is an online service that provides access to burial and cremation records for Bolton Street, Karori and Makara cemeteries.
Cemeteries Search
There are Web based search tools that retrieve data from the CMS database.
Y
Cemetery Management system is an MS Access database application written and supported by an external consultant.  The database has been converted to a SQL server 
Cemetery Management System
to provide improved back up functionality.
Y
Closed Landfill System is used to manipulate and maintain the data which are related to each physical landfill area in Wellington. Council statutory obligations for 
providing all possible information relating to the landfills can be met. This is to be achieved by allowing a restricted subset of documents, reports and data held by Closed 
Landfills to be viewed by Council business units.
This application will provide a tool for business units to more easily access closed landfill information, so to integrate its use into their operational procedures.
Closed Landfill
Y
Community Venues Search
Community Venues Search is an online web application that provides a user-maintained listing of community-based venues.
Y
Confirm is an asset management system that provides tracking of the Council’s assets (lands and facilities) from their creation in the system, through to monitoring 
contracted work on them and managing payment for that work.  Most Maintenace in Confirm - Assets is "reactive".  CEM is major system for active maintenance of 
assets.
Confirm - Pitney Bowes 
Asset Management
Confirm is used to record customer enquiries.
Y
Confirm - RAMM
ConfirmRAMM is a Council built batch component, it synchronizes the Confirm Enquiries data with RAMM Jobs.  
Y

Confirm Mobile
Asset Management in the field
Y
Confirm-Event Manager Interface
System that City Care uses to manage facilities maintenance jobs. EM integrated with Confirm via Confirm-Em interface. WCC does not support this EM.
Y
The Core Property System (CPS) is a centralised repository of all core property data within Wellington City. The CPS is an application developed by the Council to 
maintain and manage property data that is considered core to the business of Council.  It records, relationships between properties and their changes over time. The CPS 
Maintain Property process enables the user to: 
1) Add and Update all types of properties - namely Survey, Valuation, Title and Occupied
2) Maintain and query on addresses
3) Assign addresses to properties
4) Maintain and verify property associations - namely Ancestor-Descendant, Cross Property (type) and Parent-Part (valuation properties).
CPS (Core Property System)
Y
This is the data forwarded to WCC from LINZ (via CoreLogic) which is the basis of the GIS survey parcel, i.e. a surveyed boundary line. As I understand there is 
information is stored as attributes against the Arcview shape file. These attributes are synchronised against the survey parcels in the core property system. Council has 
already created these properties as it has known about them since the subdivision resource consent and then the subdivision certification process which verifies the 
intended land transfer plans as being in accordance with the resource consent. And it provides the link between the spatial view and the textual data.
CRS_PARCEL [2]
Y
Crystal Reports
report run transaction data - has connections to other databases using ODBC connections
Y
CustomerView is the view of Council's External Customer Database (ECDB). The ECDB stores customer data for all property owners & ratepayers, as well as Building 
Consent and Compliance (BCC) customers. It is a web application that allows users to search and browse customer information from a number of different applications. 
Currently it can display information about customers from CPS, TEAMwork and Confirm Call Centre information. It will also link to CityView so users can move between a 
CustomerView
property centric view of WCC data and a customer centric view of WCC data.
Y
DPS is a payment gateway used to provide a secure environment for customers to pay remotely with a credit card. It is used for most credit card payments made via the 
DPS Payment Gateway
website (e.g. Home Earthquake Proneness Assessment, Swim Bookings and LIM applications online) and for payments taken over the phone at the Call Centre.
Y
ECDB is an internally developed application used to manage all customers’ information. Customers include all persons and organisations that interact with Council. ECDB 
ECDB (External Customer 
is the fundamental source of customer information for rating and regulatory matters linking to the Core Property System (Valuation properties) and TEAMwork (Service 
Database)
Requests) respectively.
Y
ePetitions
ePetitions is used to enable public to petition the Wellington City Council, via the internet, on matters relevant to the Council's business.
Y
eRecruitment
eRecruitment is used to provide a list of job vacancy currently available in the Council.
Y
Face2Face Retention System
Face2Face Retention System is used to manage gyms membership and programme.
Y
Fix It
Fix It is a web form that allows customers to send request repairs to the Council.
Y
FixIT - Mobile App
FixIT is a mobile application (both iOS and Android) used by general public to report problems in Wellington City.
Y
GetSmart
GetSmart is an online survey tool used to conduct marketing research and collect feedback from customers.
Y
Grants Funding is an online service for applying Council funding for community projects. 
For more information, visit: http://www.wellington.govt.nz/services/grants/profiles/general.html 
Grants Funding
Y
Home Assessment Package is a cloud-based application for applying earthquake resilience home assessment. 
For more information, visit:
 http://wellington.govt.nz/services/earthquake/safety/reshomeowners.html#resilience-assessment 
Home Assessment Package
Y
IBIS Rate Modelling tool is used by the Council to model rating scenarios and assesses alternative funding options for funding our activities. It was also used extensively 
IBIS Rate Modelling
during the work on potential regional amalgamation to analyse potential impacts of amalgamation.
Y
ICDB application is used to retrieve, add, modify and remove WCC employee and Business Unit details. The database holds information about the location of the 
ICDB (Internal Customer Database) employee, their telephone numbers and email details.
Y
Infocouncil is a solution for managing electronic agendas and minutes. The application covers all the business processes involved in reporting up to Council, recording 
InfoCouncil
decisions and putting them into action.
Y

The main functions of Pathway are:
1) Rates
2) Water Billing
3) Encroachments
Pathway is the system which handles WCC Rates sending out quarterly rate accounts for approximately 70,000 (properties) Property Information along with 
Owner/Ratepayers is exported to Pathway from "Valuation" properties managed in the Core Property System.
Pathway creates Invoices.
Infor Pathway
Enchroachments functionality has been built using Pathway.
Y
Intranet Phonebook
Intranet Phonebook is a phone book system for searching staff contact information.
Y
IQP Register
IQP Register is a register for Independent Qualified Persons. This is a function managed by BCC for all IQP members covering 9 Councils.
Y
Jira is a proprietary issue tracking product, used for bug tracking, issue tracking, and project management.
Jira
In scope for those functions that make sense to move, e.g. As used by the Mayor and CEO.
Y
Kofax Digital Scanning
Kofax Digital Scanning is an application used to enable caption of the paper-based information in software imaging form.
Y
LIM Application Online is a web application for applying Land Information Memorandum, Property Report or Building Information Report.
This application triggers a business process that automates the handling of LIM request.  This includes:
1) Search and match customer details.
LIM Application Online
2) Link customer to service request.
Y
Link Manager
Link Manager is a system for linking various entities e.g. a property (identified by WUFI) and a specific DM document.  
Y
Linking Browser is an internally developed application used to create links between DM5 documents and various master data (property, customer and service request) 
stored in WCC.
Linking Browser
Linking Browser is part of the Cityview application.
Y
Mercury is a job dispatching software that delivers records out from the Confirm application to receivers via emails, pagers & mobile phone text messages.
Mercury
It contains data about who should receive notifications.
Y
Mobile Phonebook
Mobile Phonebook is a web application that allows WCC staff to use cell phones to access the internal WCC phonebook.
Y
Northgate First Housing
Northgate Housing is used to manage the tenancy and housing information.
Y
Planet Press is used to create or design transactional business documents. Documents created with Planet Press Suite can be printed, archived, emailed and/or faxed as 
Objectif Lune Planet Press
part of a sophisticated output management application driven by the Planet Press workflow tools.
Y
OrgPlus
OrgPlus is a tool used by all employees to view organisation structure.
Y
P&G Booking System
Bookings Database is used to record bookings for all the park, reserves and coastal areas excluding artificial turf.
Y
PeopleSoft EPM
PeopleSoft EPM is a tool used by the Council for financial planning and budgeting.
Y
PeopleSoft FMIS is an off-the-shelf financial management solution provided by Oracle. It is the core financial system and is used for WCC and the Council Controlled 
Organisations (CCO) for: 
1) General Ledger
2) Asset Management
3) Accounts Receivable and Debt Management
4) Accounts Payable
5)Purchasing
6) Management of Delegated Financial Authorities
7) Project Costing
8)Financial Reporting
PeopleSoft FMIS
Y

PeopleSoft HRIS is an off-the-shelf Human Resource management system provided by Oracle. It is used by for WCC and the Council Controlled Organisations (CCO) for: 
1) Leave and absence management
2) Skills and training management
3)Compensation/Remuneration & Payroll
4)eRecruitment (no longer used?)
5)Position management and budgeting
6)HR reporting
PeopleSoft HRIS
Y
PerfectForm
PerfectForm is an online tool used to automate paper forms.
Y
Pivotal
Pivotal is a tool used for remuneration allocation.
Y
POS Perfect
POS Perfect is a Point of Sale system used by Wellington Zoo.
Y
Print Management System is an internally developed system used by Publication and Design for managing photo catalogues, corporate products (name signs, business 
Print Management System
cards) and order forms.
Y
ProjectPartner
EnTech ProjectPartner is a tool used by IT/IM, Human Resource and Building Consent and Compliance (BCC) for time sheeting.
Y
The Property Search UI part was built by Blair Lundin, and it is maintained by the BIT Application Development Services team. The backend is built and maintained by the 
Property Search
BIT integration developers. This application is a viewer to the Pathway database. 
Y
Rates Invoices by Email
Rates Invoices by Email is a web form that allows customer to opt-in for electronic mailing of Rates Invoices.
Y
Rates Payment Online
Rates Payment Online is an online payment facility for rates. It relies on external EFTPOS’s ePayment System to capture and process the credit card details.
Y
Ratesview is used by WCC staff & authorised parties to view property rating information. It is also used by the contractor Capacity. The information is currently retrieved 
Ratesview
from the Pathway rates system.
Y
A street-opening notice or Road Works Notice (RWN) is taken out by anyone wishing to undertake a range of activities on our roads - as required under a document 
Road Works Notice
called the Code of Practice for Working on the Road (WCC).
Y
Shift Report is an android mobile app for local host team to record shift information when they are out in the field that can be used to generate reports against KPIs.  
Shift Report
WalkWise incident reporting.
Y
Small Plant & Equipment System
Small Plant & Equipment System is used to track plant equipment (weed eaters, chainsaws, etc.) that are under $2000 in value.
Y
Solicitors' Statement of Account 
Online
Solicitors' Statement of Account Online is an online service used to provide property Statement of Account, and is available only to registered users.
Y
SPM Assets
Used by Strategic Asset Planning team to perform analytic reporting on roading assets.
Y
Stop Tags
Stop Tags is an online (SaaS) application used to manage all aspects of graffiti removal, from incident reporting to clean up details and provides comprehensive statistics. Y
Street Name History Database is an in-house developed PHP application that provides users the ability to search and view land information stored in MYSQL database. 
The information was previously extracted from Lands application in VAX system.
Street Name History Database
It contains history of names of streets and reasons for change.  It is current accessed by a link from CPS, but it is not being updated.
Y
SyncWUFI
SyncWUFI is used to manage the association between the spatial CRS_PARCEL and the WCC CPS (Core Property System) Survey Properties
Y

TEAMwork is a bespoke workflow and information system used to manage (but is not limited to) regulatory processes such as building and resource consents, health and 
liquor licenses, and dog registrations etc. TEAMwork has links to property (CPS), customer (External Customer DB, Internal Customer DB) and documents (Document 
Management System - DM5). The fundamental entity of TEAMwork is a "Service Request". A service request is given a unique number and the system is used to monitor 
any request for service. The system has searches/reports to find consents by SR#, property or customer. Currently a summary of the main types of service request types 
that TEAMwork manages are: 
1) Building Consents - from application to compliance
2) Building Warrants of Fitness
3) Building Information
4) Building Strength Investigations (Earthquake Proneness of Buildings)
5) Weather Tightness Resolution of Buildings
6) Resource Consents applications- both Land Use and Subdivision
7) Resource Consent monitoring
8) Subdivision and Right of Way Certifications
9) Environmental Complaints
10) Land Information Memoranda applications
11) General Information applications
12) Health Licenses and Inspection
13) Liquor Licenses and Inspections
14) +B97
15) Dogs and Dog Owners
16) Development Contributions
The TEAMwork database also records Solicitors Statements of Rate Accounts and Encroachments Service Requests.
TEAMwork Powerbuilder
Y
TradeWaste Database
Waste products from kitchens etc.
Y
VisionCRE is a stand-alone property management system containing current and historic data on: 
1) legal details
2) information on acquisitions and disposals
3) property and building details e.g. numbers, names and addresses
4) tenant details including leases
5) construction details and date
6) asset, insurance and rating valuations
7) details of which business unit owns and manages the property or building.
VisionCRE
Y
VMWare Service Manager
VMWare Service Manager is a call and incident management used by IT Helpdesk.
Y