Exhibit-A-Applications-Interfaces-Inventory-1.xlsx

XLSX spreadsheet 40 KB Posted

Attached to
RFP Enterprise Resource Planning Suite and System integrator Services
Solicitation number
RFP 26-00268-AHAC
Issued by
Philadelphia County, Philadelphia City, Pennsylvania

About this file

This file is an Applications and Interfaces Inventory exhibit (Exhibit A) for the Southeastern Pennsylvania Transportation Authority (SEPTA) Enterprise Resource Planning (ERP) Software and Implementation Services RFP. The document provides a comprehensive baseline inventory of SEPTA's software applications and technical interfaces relevant to the ERP implementation, including 37 SEPTA-owned internal applications and 16 external applications owned by organizations outside SEPTA. The inventory categorizes each application by name, functionality, business division owner, hosting environment (SaaS or on-premises), integration requirements with the new ERP, and strategic disposition (Keep or Replace). Key systems to be replaced include the legacy Infor E-Series Financials and HCM (mainframe-based AP, AR, Fixed Assets, GL, Benefits, and Payroll), CPM (financial consolidation and planning), CPMS (Capital Project Management System), ASI (procurement system), and various custom-built applications including CAPES (timekeeping), FASTER (reporting), and e-Procurement System.

The current environment heavily relies on on-premises mainframe systems that will be retired, while numerous applications marked "Keep" will require integration with the new ERP solution, including VMIS M4 and M5 (vehicle maintenance), CLAIMS (legal claims management), TrainPlan and Trapeze systems (scheduling and workforce management), SEPTA Key 1.0 (fare payment), B2G Now (vendor diversity tracking), and the Fixed Assets Suite. External applications requiring ERP integration include health and benefits providers (IBX, United Concordia, CVS/Caremark), retirement and voluntary benefits systems (Empower 457, AFLAC), pension actuarial services (Milliman), driver license validation systems across PA, NJ, and DE, and various tax reporting entities. The inventory indicates that proposers must understand these integration requirements and develop solutions that accommodate systems being retained while replacing legacy mainframe applications with modern ERP functionality, with some applications like SAP SuccessFactors and Workers Compensation marked as "TBD" for final disposition decisions.

View the file

Other files

Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Instructions

SEPTA ERP Software and Implementation Services
Exhibit A: Applications & Interfaces Inventory
Instruction for RFP Proposers
Proposers and vendor evaluation teams must use the column descriptions provided in this sheet to review and interpret the detailed records in the subsequent tab ('Applications & Interfaces'), which contains the baseline inventory of SEPTA's software applications and technical interfaces relevant to the ERP implementation. The tabs are split up into SEPTA owned, internal applications and external applications owned by organizations external to SEPTA. The definitions below specify the functional meaning, business ownership categories, hosting deployment models, and strategic disposition decisions (Keep/Replace) established for SEPTA's ERP transformation.
COLUMN DEFINITIONS
Column HeaderDescription & Functional Meaning
Application NameThe official software title, common acronym, product name, or system alias recognized within SEPTA's operating divisions.
DescriptionOverview of the application's core functionality, business scope, key data flows, and current integration touchpoints.
SEPTA Division OwnerThe internal SEPTA division, department, or administrative unit holding business ownership, operational responsibility, or administrative oversight for the system.
Hosting
(i.e., SaaS, On-premises)Specifies the deployment architecture and hosting environment where the software application currently resides.
Integrate with ERPIndicates whether the future-state ERP solution is required to establish a direct technical interface/integration with this application to exchange data or support business workflows.
Keep/ ReplaceSEPTA's planned strategic disposition for the application under the ERP transformation roadmap indicating whether the system will be retained, retired, or replaced by the new ERP.

SEPTA Applications SEPTA ERP Software and Implementation Services Applications & Interfaces Inventory

#Application NameDescriptionSEPTA Division OwnerHosting
(i.e., SaaS, On-premises)Integrate
with ERPKeep/ Replace
1INFOR E-Series FinancialsEnterprise-level software suite for Accounts Payable, Accounts Receivable, Fixed Assets, and General Ledger.FinanceOn-premises; mainframeNoReplace
2Infor E-Series HCMEnterprise-level software suite for Human Resources' Benefits and PayrollFinance; Human ResourcesOn-premises; mainframeNoReplace
3CPMAggregates data from the mainframe (and other systems) providing financial consolidation, budgeting, planning, forecasting, and reporting. (aka project reporting). Project Reporting does not happen from CPM, it happens from CPMS (geared to Capital dollars). Bi-directional interface w/ GL.FinanceOn-premisesNoReplace
4CPMS
(Capital Project Management System)It handles its own Accounts Payable, General Ledger, Payroll interfaces and functions almost as a secondary ERP. It handles its own Invoicing for Capital Projects. Bi-directional interface w/ GL.FinanceOn-premisesNoReplace
5VMIS (Vehicle Maintenance Information System) M4Maintenance system of record for steel wheels, i.e., subway-elevated, trolley, and regional rail cars; Tracks parts and vehicle maintenance work orders. Sends inventory consumption to ASI by way of M5; receives inventory details from ASI by way of M5; receives charge numbers from chart of accounts / GMP-11 by way of M5; directly receives employee data from mainframe.OperationsOn-premisesYesKeep
6VMIS (Vehicle Maintenance Information System) M5Maintenance system of record for rubber tires, i.e., buses and non-revenue vehicles; Tracks parts and vehicle maintenance work orders. Sends inventory consumption to ASI; receives inventory details from ASI; receives charge numbers from chart of accounts / GMP-11; directly receives employee data from mainframe.OperationsOn-premisesYesKeep
7FASTERCustom-built, in-house application; consolidates mainframe data sources and allows users to run canned and ad-hoc reports; valuable for reporting against SEPTA-generated, six-digit work orders (not charge numbers)FinanceOn-premisesNoReplace
8CLAIMSManages legal claims, creates its own vendors, and initiates payments. Heavily integrated with AP and GL; relies on its own AP paying entity, CLMS; could be succeeded by PCIS' ClaimsVision by the time ERP implementation begins.Office of General CounselOn-premises; mainframeYesKeep
9SymProEmphasys is the manufacturer; cash management software that was a bolt-on to Infor's CloudSuite Financials (FSM); contract expires Q3 2026 and will not be renewed; business processes must be captured as ERP 2.0 requirements.FinanceSaaSNoReplace
10B2G NowTracks vendor diversity/compliance. Relies on AP spend data.It pulls vendor information’s related to PO invoices and uses this information to determine spend of diverse vs. non-diverse vendors to total spend.Chief of Staff's OfficeSaaSYesKeep
11CAPESCustom-built, in-house timekeeping system of record for all employees.FinanceOn-premises; mainframeNoReplace
12TrainPlanRegional Rail schedule creation tool; will be integral to regional rail transportation staff timekeeping.OperationsOn-premisesYesKeep
13Trapeze Workforce Management (AKA Trapeze Ops)Surface Transportation and Metro Rail resource management tool; used as employee recordkeeping system; desires to be a timekeeping system but lacks configuration and interface to mainframe to do so; Configure this to handle timekeeping.OperationsOn-premisesYesKeep
14Trimble Unity Connect (AKA eBuilder)Construction project management application; bastardized by SEPTA to manage contracts' task order processes and unique right-of-entry (ROE) request process.FinanceSaaSNoKeep
15ASISEPTA's legacy procurement system of record; serves as "bookends" for the procurement process, i.e., requisition creation and PO creation; loose responsibility with SEPTA AP in vendors' details management; system of record for class / lot numbers of stock items; system of record for bin locations across 21 storerooms and two warehouses.FinanceOn-premises; mainframeNoReplace
16e-Procurement System (ePS)Custom-built supplier portal; allows would-be vendors opportunity to respond to procurements, i.e., EOIs, sealed bids, and RFPs; also provides vendors read-only insights into ACH paymentsFinanceOn-premisesNoReplace
17REAMSCustom-built Access front-end, SQL back-end; had one-time connection to legacy document management product, e-Cabinet by Ricoh; connection broken and not restored following 2020 malware event; also used to receive "aging report" data from SEPTA's AR system of record; that is now manually provided to REAMS; REAMS used to manage revenue generating leases and serve as starting point for responses to deed and other parcel information inquiries; will be succeeded by Yardi; will not integrate with ERP.FinanceOn-premises; mainframeNoReplace
18SundryManages miscellaneous cash/revenue (homegrown VSAM file based).FinanceOn-premises; mainframeNoReplace
19YardiProposed successor to REAMS; will have interface from AR to recreate "aging report"; specifications / requirements necessary.FinanceSaaSYesKeep
20Crew Pro (AKA Crew Management System AKA CMS)Regional Rail resource management tool; used as employee recordkeeping system; desires to be a timekeeping system but lacks configuration and interface to mainframe to do so; SEPTA DECISION: Configure this to handle timekeeping or leave as-is.OperationsOn-premisesYesKeep
21Workers CompensationCustom-built mainframe application for Workers' Compensation calculations; tightly integrated with CAPES timekeeping system to capture hours worked and related details; should be assessed for consumption by ERP, consumption by Sedgwick Absence Management services, or other option.Office of General CounselOn-premises; mainframeTBDTBD
22Data Dictionary / P10Used for project cost reporting and is linked to the GL for projects.FinanceOn-premises; mainframeNoReplace
23Control DMainframe-based reporting application; contains many canned and custom reports generated on routine bases for end-users.Information TechnologyOn-premises; mainframeNoReplace
24SAP SuccessFactorsHCM product. Used currently in onboarding. Generates a file which is transferred to the mainframe. Creates its own employee ID (in addition to a second ID created on mainframe). SuccessFactors also providing a Learning Management System (LMS) function.Human ResourcesSaaSTBDTBD
25Fixed Assets Suite (AKA FA Suite)Burgeoning enterprise asset management (AEM) system; user base of approximately 350 persons across the EM&C Division.FinanceOn-premisesYesKeep
26Synario - CapitalSynario software subscription for Budgets (5-years) for Operating & Capital Budgets - Budgeting & Forecasting / Capital Planning; can be replaced by ERP if scoped'.FinanceSaaSNoReplace
27LCP Tracker, Inc.This software-as-a-service allows Procurement / SEPTA’s P&SCM’s Contract Grant Compliance (CGC) department to track and streamline projects' certified payrolls for SEPTA, its prime contractors, and subcontractors.FinanceSaaSNoKeep
28APS (Attendance Point System)Custom-built tracking application for union-based attendance points, earned excused days, etc.Finance; Human ResourcesOn-premises; mainframeNoReplace
29Gov DealsUsed buy Procurement to sell scrap, deprecated items, etc.; some analyses should be performed to determine if transfer of electronic payments to ERP is feasible.FinanceSaaSYesKeep
30TextRecruitText platform, part of acquire talent function; ensure in functional scope section of RFP language.Human ResourcesSaaSNoReplace
31CCURE 9000Badging system. CCURE (Johnson Controls) is a security and event management system used for access control, credential management, monitoring, and enterprise physical security; it has a component called CCURE ID. Serves building access control. (receives employee information - some integration)EM&COn-premisesYesKeep
32SEPTA Key 1.0Conduent provided; SEPTA's fare payment system of record; provides signficant reporting.FinanceOn-premisesYesKeep
33Computer-Aided Radio Dispatch (CARD)Bus dispatching software.Information TechnologyOn-premisesYesKeep
34Debt BookCloud‑based treasury, debt, lease, and subscription management platform.
No current integration, will need an integration in future state.FinanceSaaSYesKeep
35Modula Vertical Lift Module (VLMs)Decatur Warehouse storage baysFinanceOn-premisesYesKeep
36Trapeze Mobility, Planning, and Scheduling (AKA Trapeze Blockbuster / FX)Surface Transportation and Metro Rail schedule creation tool; will be integral to surface transportation staff timekeeping.OperationsOn-premisesYesKeep
37Primavera P6Project and portfolio management solution.FinanceOn-premisesTBDKeep

External Applications SEPTA ERP Software and Implementation Services Applications & Interfaces Inventory

#Application NameDescriptionSEPTA Division OwnerHosting
(i.e., SaaS, On-premises)Integrate
with ERPKeep/ Replace
38IBX(Medical/Vision). Monthly outbound from SEPTA to IBX in 834 formatNot owned by SEPTAExternal appYesN/A
39United Concordia(Dental) Per notes: Receives outbound eligibility files for benefits. Multiple flavors of export. Monthly.Not owned by SEPTAExternal appYesN/A
40CVS / Caremark(Prescription) Per notes: Receives outbound eligibility files for prescription benefits. Monthly - single file.Not owned by SEPTAExternal appYesN/A
41WEXActs as the COBRA administration system of record and receives weekly and monthly status change files. WEX is the vendor. We provision ability for the benefits department to create that. We are not sending - ad hoc. This is more like a canned report for the vendor. Talk to Benefits for more details.Not owned by SEPTAExternal appNoN/A
42Empower(457) Manages the 457 savings plan and provides an inbound data feed for deductions. Bidirectional. Roster of participants, receive deductions employee has chosen.Not owned by SEPTAExternal appYesN/A
43AFLACInsurance - voluntary benefits are offered - similar to Empower - bidirectional send participants, get deductionsNot owned by SEPTAExternal appYesN/A
44MillimanInsurance Notes: Milliman provides pension actuarial services. Outbound.Not owned by SEPTAExternal appYesN/A
45CISComputer Imaging System - supporting mainframe payroll and finance report archiving. Contracted service. They receive exports for long term archiving. Formatted report output. Capability should be replaced by modern ERP. Retrieval is physical via CD-ROM. (W2, GL reports).Not owned by SEPTAExternal appNoN/A
46Railroad retiree fileRailroad retiree file transmitted to third-party Notes: Supports Railroad Retirement Board filings and tax calculations. Annual export.Not owned by SEPTAExternal appYesN/A
47W-2 reporting - IRSfrequency = annual.Not owned by SEPTAExternal appYesN/A
48W-2 reporting - PAfrequency = annual.Not owned by SEPTAExternal appYesN/A
49W-2 reporting - NJfrequency = annual.Not owned by SEPTAExternal appYesN/A
50Driver license validation - PACall and response between SEPTA and DMV to receive monthly updates on staff and their status as a licensed operator (includes all employees, not just bus drivers). There is a separation here between employees and contracted drivers (so two interfaces, same DMV)Not owned by SEPTAExternal appYesN/A
51Driver license validation - NJCall and response between SEPTA and DMV to receive monthly updates on staff and their status as a licensed operator (includes all employees, not just bus drivers). There is a separation here between employees and contracted drivders (so two interfaces, same DMV)Not owned by SEPTAExternal appYesN/A
52Driver license validation - DECall and response between SEPTA and DMV to receive monthly updates on staff and their status as a licensed operator (includes all employees, not just bus drivers). There is a separation here between employees and contracted drivders (so two interfaces, same DMV)Not owned by SEPTAExternal appYesN/A
53DHS E-Verify (via SuccessFactors)The current process is manual. The original goal was to use SuccessFactors to automate eVerify - not live at this time.Not owned by SEPTAExternal appYesN/A

image1.png

File details come from the government source that posted it. Updated .