Integrations_Scope_Tables.pdf
PDF 209 KB Posted
- Attached to
- Enterprise Resource Planning (ERP) Solution State and local contract opportunity
- Solicitation number
- 2026-RFP-064
- Issued by
- Allegheny County, Philadelphia City, Pennsylvania
About this file
This is a Scope of Work document for the City of Pittsburgh's Office of Management & Budget, on behalf of the Department of Innovation & Performance, detailing the integration requirements for a proposed Enterprise Resource Planning (ERP) solution. The document presents a comprehensive integration scope table identifying 36 distinct data flows required to support seamless data exchange and end-to-end business processes across the City's existing and future application landscape. The proposed ERP solution must accommodate integrations with numerous City systems including Atlantis Inventory, Ceridian Dayforce, Bank of America, First National Bank, PNC Bank, Huntington Bank, Cartegraph, Docusign, OnBase, Procore, eCivis, and multiple payment processing systems. The integrations encompass critical functions such as inventory transaction posting, purchase order and vendor management, bank reconciliation and cash position updates, payroll journal entries and labor cost tracking, permit and license fee processing, tax billing and revenue posting, asset lifecycle management, document management and e-signature workflows, grant management, and treasury operations.
The document acknowledges that while the City has compiled a comprehensive list of required integrations based on business process analysis, the specific set of integrations may vary depending on the proposed solution's architecture, functionality, and delivered capabilities. Of the 36 identified integrations, only three currently exist within the ERP environment: cleared transactions and balances from Bank of America, payment instructions to Bank of America, and payroll journal entries from Ceridian Dayforce. Additionally, cashiering and walk-in payment data integration with iPayment currently exists. The remaining 32 integrations represent new requirements that must be supported by the selected ERP vendor to enable comprehensive financial posting, reconciliation, compliance tracking, and reporting across all City departments and external stakeholders.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Enterprise_Resource_Planning_(ERP)_Solution_(Addendum_#1_Revision).pdf | ||
| Attachment_B_-_Functional_&_Technical_Requirements.xlsx | XLSX spreadsheet | |
| Attachment_G_-_Standard_SLA_with_Remedy.pdf | ||
| Attachment_D_-_Pricing_Forms.xlsx | XLSX spreadsheet | |
| Attachment_C_-_Staffing_Forms.xlsx | XLSX spreadsheet | |
| Attachment_A_-_Vendor_Forms.xlsx | XLSX spreadsheet | |
| Current_Application_Environment_Tables.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
3.5 Integrations Scope
The table below identifies the integrations the City has compiled based on its business process analysis to support seamless data exchange and end-to-end business processes. The proposed ERP solution must support integration with the City’s existing and future application landscape; however, the specific set of required integrations may vary based on the proposed solution’s architecture, functionality, and delivered capabilities.
Data Flow
Item # Data Flow Description Source Application
Target Application
Currently Exists in ERP Environment
1 Inventory transactions (receipts, issues, adjustments) to the ERP for financial posting and valuation.
Atlantis Inventory New ERP No
2 Purchase orders, item master data, vendor information, and cost center/project codes from the ERP.
New ERP Atlantis Inventory
No
3 Cleared transactions and balances to the ERP for reconciliation and cash position updates.
Bank of America New ERP Yes
4 Payment instructions (ACH, wires) from the ERP for vendor disbursements and payroll.
New ERP Bank of America
Yes
5 Asset lifecycle updates and maintenance/work order information.
Cartegraph New ERP No
6 Payroll journal entries to the ERP for GL posting and labor cost tracking.
Ceridian Dayforce New ERP Yes
7 Chart of accounts, cost centers, and budget/position data to support payroll coding and compliance.
New ERP Ceridian Dayforce
Yes
8 Permit/license fees and fines to the ERP for cash and revenue posting.
Computronix New ERP No
9 Tax billing and payment data for cash and revenue posting.
CSS New ERP No
10 Signed documents and signature status updates to the ERP for recordkeeping and workflow automation.
Docusign New ERP No
11 Documents and signer metadata from the ERP to initiate e-signature processes.
New ERP Docusign No
12 Project, contract, and reimbursement data for PennDOT-funded transportation projects. Includes approved pay estimates and reimbursement amounts to support AR and project accounting.
ECMS New ERP No
13 Vendor invoices and payments. New ERP ECMS No
14 Investment account activity and balances to the ERP for treasury and GL updates.
First National Bank New ERP No
15 Fund transfer instructions and investment transactions from the ERP for execution.
New ERP First National Bank
No
16 Payment receipts (online, card, kiosk) to the ERP for cash and revenue posting.
Global Payments
(NCR)
New ERP No
17 Billing data and payment requests from the ERP to facilitate citizen payments.
New ERP Global Payments
(NCR)
No
18 Check activity to the ERP for reconciliation and cash tracking and management.
Huntington New ERP No
19 Payment files. New ERP Huntington No
20 Cashiering and walk-in payment data to the ERP for cash and revenue posting.
iPayment New ERP Yes
21 Finalized documents and data. OnBase New ERP No
22 Contract and solicitation details (updated vendor contracts, contract terms, awarded bid information, and contract limits or budgets).
OpenBook New ERP No
23 Grant-related billing transactions. Osmium New ERP No
24 Check activity to the ERP for reconciliation and cash tracking and management.
PNC Bank New ERP No
25 Payment files. New ERP PNC Bank No
26 Project commitments, contracts, and approved invoices to the ERP for AP and project accounting.
Procore New ERP No
27 Project master data, vendor info, purchase orders, and payment information.
New ERP Procore No
28 Financial and budget data from the ERP for reporting, compliance, and external publication.
New ERP Wdesk No
29 Public datasets (e.g., budget, expenditures) from the ERP for transparency and open data access.
New ERP Focused - Western Pennsylvania Regional Data Center
No
30 Processed datasets, analytics outputs, and financial models into the ERP for reporting, forecasting, and decision support.
Alteryx New ERP No
31 Grant application data, award details, and compliance tracking metrics to the ERP for financial posting, budget alignment, and reporting.
eCivis New ERP No
32 Actual expenditures, budget updates, and financial status from the ERP to support grant lifecycle management, drawdown tracking, and compliance reporting.
New ERP eCivis No
33 Permit and license application data, fee assessments, and status updates for cash and revenue posting.
eProval New ERP No
34 Summarized financial data, budget performance, and expenditure reports from the ERP to support public-facing dashboards and transparency initiatives.
Fiscal Focus New ERP No
35 User-submitted applications, payments, and service requests to the ERP for cash and revenue posting.
OneStopPGH New ERP No
36 Awarded bid and contract data (vendor, pricing, terms) to ERP for PO creation and fund encumbrance, as well as vendor registration info to ERP’s vendor master upon award.
OpenGov New ERP No
File details come from the government source that posted it. Updated .