Current_Application_Environment_Tables.pdf

3.4 Current Application Environment

Below are tables which identify the City’s current inventory of systems and applications, along with the legend for what the City’s intent is related to each system/application.

Legend for current applications

Legend Code Description R Replacement The City intends to replace this application with the selected solution.

C Consider The City will consider replacing this application with the selected solution based on the strength of the finalist vendor’s offering and the cost/benefit of the replacement module.

M Maintain The City intends to retain the application, not replace it, through this effort.

I Interface The City intends to keep the application and interface/integrate it with the selected solution.

C/I Consider/Interface The City will consider replacing this application with the selected solution based on the strength of the finalist vendor’s offering and the cost/benefit of the replacement module. If the City maintains this application, it would require an interface to the ERP. Therefore, the vendor must provide interface experience and pricing for these applications.

Current ERP Application

Application Notes/Description Current Platform

Likely Future

Alteryx Data analytics, preparation, and workflow automation platform that enables users to blend, cleanse, analyze, and model data using low-code, drag-and-drop workflows.

On- Premise

I

Atlantis Inventory A new inventory management system being rolled out citywide (already in use by the Finance Department) that specializes in tracking supplies and automating stock control.

Cloud C/I

Axon Public safety software used for drafting police report narratives based on body-worn camera audio.

Cloud M

B3 Real Estate Property management and real estate services platform primarily used as a third-party business tax processor.

Cloud R

Bank of America Primary bank used for ACH, e-pay, and p-Card payments. Third- Party

I

Cartegraph Asset management and operations platform used primarily for capitalized assets, including tracking vehicle lifecycles.

Cloud I

Ceridian Dayforce The current ERP system for human capital management. Cloud I

Computronix Permitting, licensing, and regulatory compliance system. Cloud I

CSS (Business Taxes)

Tax and payment management system for collecting business taxes.

Cloud I

CSS (Real Estate Taxes)

Tax and payment management system for collecting real estate taxes. Currently being implemented.

(Implementation started - scheduled go-live in 2027)

Cloud I

Docusign Electronic agreement and signature management software. Cloud I

DPW Portal Microsoft Power Apps application built by DPW for procurement processes.

Cloud R eCivis Grants management platform that helps the City manage the full grants lifecycle — from researching funding opportunities to application tracking, budgeting, reporting, and compliance.

Cloud C/I

ECMS PennDOT's web-based platform for managing the entire lifecycle of transportation projects. It allows municipalities to enter projects into the system, such as after they have been designed or bid, to handle contract awards and payments electronically.

Cloud I eProval Firm and event permitting system used to collect payments and generate financial reports.

Cloud I

First National Bank

The primary bank for City investment accounts. Third- Party

I

Fiscal Focus A financial transparency and reporting tool that provides public access to City spending, budgets, and performance metrics.

Cloud I

Global Payments

(NCR)

An omnichannel payment solution primarily used for global payments.

Cloud I

Hexagon System used by Fleet to track all City vehicles and equipment, manage work orders, record maintenance/repair costs, and schedule preventative maintenance for assets.

On- Premise

M

Huntington The primary bank for City non-investment accounts. Third- Party

I iPayment Payment processing platform for deposit cashiering, walk-in payments, and other payment types.

Cloud I

Legistar Government-focused agenda and legislative management system used to manage agendas, minutes, legislative files, approvals, voting, and public meeting transparency.

Cloud M

Matrix Legal case management system used by law enforcement, courts, attorneys, and investigators to manage case files, documents, evidence, appointments, and workflows.

On- Premise

M

Monday.com Work management (Work OS) platform that provides project management, task tracking, workflow automation, collaboration tools, dashboards, resource management, and customizable boards.

Cloud M

OnBase An enterprise content management system (ECM) used primarily for document storage.

Cloud I

OneStopPGH Permitting system that handles accounts receivables for the Departments of City Planning (DCP), Mobility and Infrastructure (DOMI), and Permits, Licenses, and Inspections (PLI), and the Pittsburgh Bureau of Fire (PBF) departments' receipts.

On- Premise

I

OpenBook Contract and solicitation management system used to track and maintain vendor contracts.

Cloud I

OpenGov System used for all solicitations and contract management. Cloud C/I

OPEX Document and mail automation system, including scanning workflow solutions for high-volume environments.

On- Premise

M

Oracle JD Edwards The current ERP system for financials. Cloud R

Osmium Grant management and constituent engagement software that helps ensure compliance with CDBG requirements by supporting a separate item master, distinct fund codes, and structured reporting needs. Currently being implemented.

Cloud I

Petlogix Software platform to manage and document daily field operations and activity logs. Serves as a centralized database for ACC tasks and case records, allowing staff to record and track information on animal control incidents (such as service calls, stray animal pickups, investigations, and quarantines).

Cloud M

PNC Bank The primary bank for City departmental checking accounts. Third- Party

I

PowerDMS Software solutions and digital tools designed to replace paper processes. Document management system used to track certifications and expirations.

Cloud M

Procore Construction management platform that connects project teams, workflows, and data across the entire construction lifecycle. Currently being implemented across two departments.

Cloud C/I

Questica Budgeting and performance management software that specializes in planning, forecasting, and reporting.

Cloud R

QuickBooks Accounting software for managing invoices and expenses, primarily used by Fleet.

On- Premise

R

ReportsNow A business intelligence and reporting tool that streamlines report creation and offers real-time dashboards.

On- Premise

R

RollKall Third party portal responsible for collecting and remittance for off duty officers. Officers can find, schedule, and track off-duty jobs with the portal.

Cloud M

RT Lawrence Payment processing system primarily used for check scanning, invoices, and payment coupons.

On- Premise

M

Samsara System that links City vehicles and equipment via onboard GPS/telematic devices, providing live location tracking, engine diagnostics, usage (idling, mileage) data, and video safety (dashcams) to improve fleet efficiency and safety.

Cloud M

Wdesk Financial reporting and compliance platform by Workiva, currently used by OMB to assist with budget reporting.

Cloud C/I

Western Pennsylvania Regional Data Center

A public open data portal that provides transparency into City datasets.

Third- Party

I