Exhibit-A-Applications-Interfaces-Inventory-1.xlsx
XLSX spreadsheet 40 KB Posted
- 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
| File | Type | Posted |
|---|---|---|
| Response-Form-1-QA-Submission.xlsx | XLSX spreadsheet | |
| Attachment-03B-Software-Price-Proposal.xlsx | XLSX spreadsheet | |
| RFP-26-00268-AHAC-for-ERP-Software-and-Implementation-Services.pdf | ||
| Exhibit-C-Reports-Inventory.xlsx | XLSX spreadsheet | |
| Appendix-2B-Exit-Services.pdf | ||
| Response-Form-3-Functional-Requirements.xlsx | XLSX spreadsheet | |
| Attachment-03A-Price-Proposal-for-SI-Services.xlsx | XLSX spreadsheet | |
| Invitation-to-Propose-ERP-SI.pdf | ||
| Response-Form-2-Proposer-Information.xlsx | XLSX spreadsheet | |
| Appendix-2C-Performance-Management.pdf | ||
| Exhibit-B-Key-Personnel.pdf | ||
| Response-Form-4-Non-Functional-Requirements.xlsx | XLSX spreadsheet |
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 Header | Description & Functional Meaning | |
| Application Name | The official software title, common acronym, product name, or system alias recognized within SEPTA's operating divisions. | |
| Description | Overview of the application's core functionality, business scope, key data flows, and current integration touchpoints. | |
| SEPTA Division Owner | The 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 ERP | Indicates 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/ Replace | SEPTA'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 Name | Description | SEPTA Division Owner | Hosting | |||
| (i.e., SaaS, On-premises) | Integrate | ||||||
| with ERP | Keep/ Replace | ||||||
| 1 | INFOR E-Series Financials | Enterprise-level software suite for Accounts Payable, Accounts Receivable, Fixed Assets, and General Ledger. | Finance | On-premises; mainframe | No | Replace | |
| 2 | Infor E-Series HCM | Enterprise-level software suite for Human Resources' Benefits and Payroll | Finance; Human Resources | On-premises; mainframe | No | Replace | |
| 3 | CPM | Aggregates 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. | Finance | On-premises | No | Replace | |
| 4 | CPMS | ||||||
| (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. | Finance | On-premises | No | Replace | ||
| 5 | VMIS (Vehicle Maintenance Information System) M4 | Maintenance 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. | Operations | On-premises | Yes | Keep | |
| 6 | VMIS (Vehicle Maintenance Information System) M5 | Maintenance 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. | Operations | On-premises | Yes | Keep | |
| 7 | FASTER | Custom-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) | Finance | On-premises | No | Replace | |
| 8 | CLAIMS | Manages 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 Counsel | On-premises; mainframe | Yes | Keep | |
| 9 | SymPro | Emphasys 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. | Finance | SaaS | No | Replace | |
| 10 | B2G Now | Tracks 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 Office | SaaS | Yes | Keep | |
| 11 | CAPES | Custom-built, in-house timekeeping system of record for all employees. | Finance | On-premises; mainframe | No | Replace | |
| 12 | TrainPlan | Regional Rail schedule creation tool; will be integral to regional rail transportation staff timekeeping. | Operations | On-premises | Yes | Keep | |
| 13 | Trapeze 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. | Operations | On-premises | Yes | Keep | |
| 14 | Trimble 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. | Finance | SaaS | No | Keep | |
| 15 | ASI | SEPTA'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. | Finance | On-premises; mainframe | No | Replace | |
| 16 | e-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 payments | Finance | On-premises | No | Replace | |
| 17 | REAMS | Custom-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. | Finance | On-premises; mainframe | No | Replace | |
| 18 | Sundry | Manages miscellaneous cash/revenue (homegrown VSAM file based). | Finance | On-premises; mainframe | No | Replace | |
| 19 | Yardi | Proposed successor to REAMS; will have interface from AR to recreate "aging report"; specifications / requirements necessary. | Finance | SaaS | Yes | Keep | |
| 20 | Crew 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. | Operations | On-premises | Yes | Keep | |
| 21 | Workers Compensation | Custom-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 Counsel | On-premises; mainframe | TBD | TBD | |
| 22 | Data Dictionary / P10 | Used for project cost reporting and is linked to the GL for projects. | Finance | On-premises; mainframe | No | Replace | |
| 23 | Control D | Mainframe-based reporting application; contains many canned and custom reports generated on routine bases for end-users. | Information Technology | On-premises; mainframe | No | Replace | |
| 24 | SAP SuccessFactors | HCM 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 Resources | SaaS | TBD | TBD | |
| 25 | Fixed Assets Suite (AKA FA Suite) | Burgeoning enterprise asset management (AEM) system; user base of approximately 350 persons across the EM&C Division. | Finance | On-premises | Yes | Keep | |
| 26 | Synario - Capital | Synario software subscription for Budgets (5-years) for Operating & Capital Budgets - Budgeting & Forecasting / Capital Planning; can be replaced by ERP if scoped'. | Finance | SaaS | No | Replace | |
| 27 | LCP 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. | Finance | SaaS | No | Keep | |
| 28 | APS (Attendance Point System) | Custom-built tracking application for union-based attendance points, earned excused days, etc. | Finance; Human Resources | On-premises; mainframe | No | Replace | |
| 29 | Gov Deals | Used buy Procurement to sell scrap, deprecated items, etc.; some analyses should be performed to determine if transfer of electronic payments to ERP is feasible. | Finance | SaaS | Yes | Keep | |
| 30 | TextRecruit | Text platform, part of acquire talent function; ensure in functional scope section of RFP language. | Human Resources | SaaS | No | Replace | |
| 31 | CCURE 9000 | Badging 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&C | On-premises | Yes | Keep | |
| 32 | SEPTA Key 1.0 | Conduent provided; SEPTA's fare payment system of record; provides signficant reporting. | Finance | On-premises | Yes | Keep | |
| 33 | Computer-Aided Radio Dispatch (CARD) | Bus dispatching software. | Information Technology | On-premises | Yes | Keep | |
| 34 | Debt Book | Cloud‑based treasury, debt, lease, and subscription management platform. | |||||
| No current integration, will need an integration in future state. | Finance | SaaS | Yes | Keep | |||
| 35 | Modula Vertical Lift Module (VLMs) | Decatur Warehouse storage bays | Finance | On-premises | Yes | Keep | |
| 36 | Trapeze Mobility, Planning, and Scheduling (AKA Trapeze Blockbuster / FX) | Surface Transportation and Metro Rail schedule creation tool; will be integral to surface transportation staff timekeeping. | Operations | On-premises | Yes | Keep | |
| 37 | Primavera P6 | Project and portfolio management solution. | Finance | On-premises | TBD | Keep |
External Applications SEPTA ERP Software and Implementation Services Applications & Interfaces Inventory
| # | Application Name | Description | SEPTA Division Owner | Hosting | |||
| (i.e., SaaS, On-premises) | Integrate | ||||||
| with ERP | Keep/ Replace | ||||||
| 38 | IBX | (Medical/Vision). Monthly outbound from SEPTA to IBX in 834 format | Not owned by SEPTA | External app | Yes | N/A | |
| 39 | United Concordia | (Dental) Per notes: Receives outbound eligibility files for benefits. Multiple flavors of export. Monthly. | Not owned by SEPTA | External app | Yes | N/A | |
| 40 | CVS / Caremark | (Prescription) Per notes: Receives outbound eligibility files for prescription benefits. Monthly - single file. | Not owned by SEPTA | External app | Yes | N/A | |
| 41 | WEX | Acts 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 SEPTA | External app | No | N/A | |
| 42 | Empower | (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 SEPTA | External app | Yes | N/A | |
| 43 | AFLAC | Insurance - voluntary benefits are offered - similar to Empower - bidirectional send participants, get deductions | Not owned by SEPTA | External app | Yes | N/A | |
| 44 | Milliman | Insurance Notes: Milliman provides pension actuarial services. Outbound. | Not owned by SEPTA | External app | Yes | N/A | |
| 45 | CIS | Computer 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 SEPTA | External app | No | N/A | |
| 46 | Railroad retiree file | Railroad retiree file transmitted to third-party Notes: Supports Railroad Retirement Board filings and tax calculations. Annual export. | Not owned by SEPTA | External app | Yes | N/A | |
| 47 | W-2 reporting - IRS | frequency = annual. | Not owned by SEPTA | External app | Yes | N/A | |
| 48 | W-2 reporting - PA | frequency = annual. | Not owned by SEPTA | External app | Yes | N/A | |
| 49 | W-2 reporting - NJ | frequency = annual. | Not owned by SEPTA | External app | Yes | N/A | |
| 50 | Driver license validation - PA | Call 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 SEPTA | External app | Yes | N/A | |
| 51 | Driver license validation - NJ | Call 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 SEPTA | External app | Yes | N/A | |
| 52 | Driver license validation - DE | Call 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 SEPTA | External app | Yes | N/A | |
| 53 | DHS 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 SEPTA | External app | Yes | N/A |
image1.png
File details come from the government source that posted it. Updated .