COSC_ATT_G_Interface_List.xlsx

XLSX spreadsheet 24 KB Posted

Attached to
Enterprise Resource Planning (ERP) Software and Implementation Services State and local contract opportunity
Solicitation number
2026-027
Issued by
Polk County, Florida

About this file

This is an Interface List attachment for the City of St. Cloud, Florida's Enterprise Resource Planning (ERP) system procurement, detailing the current systems requiring integration or replacement. The City identified 40 existing systems across Finance, Human Resources, Procurement, Customer Billing, and Capital Asset Management functions that must be addressed through the new ERP implementation. Systems designated for replacement with the ERP include Central Square/AS400 (accounting, payroll, and asset depreciation), OpenGov (budget preparation), Cognos (reporting), HRIS (human resources), ExecuTime (timekeeping), NeoGov (recruitment and personnel actions), and various billing systems including WasteWorks, DetailCommander, DigiTech, and TrackIt. Systems identified for retention with permanent interface connections include Operative IQ (fire department asset and maintenance management), CityWorks (work order and asset tracking), RecTrac (facility rental billing), LaserFiche (document storage), and several payment processing systems. The interface list specifies data direction requirements (inbound only, outbound only, or bi-directional), interface duration (temporary during implementation or permanent for system lifetime), and data transfer frequency parameters (real-time every 15 minutes, hourly, daily, weekly, or monthly). Vendors are required to complete this attachment by identifying all proposed Third Party Systems and defining their integration approach, data flow direction, duration, and transfer frequency relative to the new ERP system, with supporting comments on implementation strategy.

The interface list serves as a critical planning document for vendor proposals, establishing the foundation for data migration strategy and post-implementation system coexistence. Vendors must identify whether each current system will be replaced by native ERP functionality, replaced by a new Third Party System proposed as part of their solution, or retained with a permanent interface build. The document establishes standardized response options to ensure consistency across all proposals and to facilitate comparative evaluation of vendors' integration approaches. No pricing information, budget allocations, set-asides, or incumbent vendor details are included in this attachment; the interface list functions solely as a technical requirements and planning tool to guide vendor scoping and cost estimation for system integration and data conversion activities across the City's diverse operational systems.

View the file

Other files for this state and local contract opportunity

Other files attached to Enterprise Resource Planning (ERP) Software and Implementation Services, newest first.
File Type Posted
Enterprise_Resource_Planning_(ERP)_Software_and_Implementation_Services_(Addendum_#3_Revision).pdf PDF
Enterprise_Resource_Planning_(ERP)_Software_and_Implementation_Services_(Addendum_#1_Revision).pdf PDF
Enterprise_Resource_Planning_(ERP)_Software_and_Implementation_Services.pdf PDF
I_COSC_ATT_I_Cost.xlsx XLSX spreadsheet
I_COSC_ATT_I_Cost.xlsx XLSX spreadsheet
COSC_ATT_H_Conversions.xlsx XLSX spreadsheet
COSC_ATT_H_Conversions.xlsx XLSX spreadsheet
COSC_ATT_G_Interface_List.xlsx XLSX spreadsheet
COSC_ATT_F_Project_Staffing.xlsx XLSX spreadsheet
COSC_ATT_F_Project_Staffing.xlsx XLSX spreadsheet
COSC_ATT_E_Requirments.xlsx XLSX spreadsheet
COSC_ATT_E_Requirments.xlsx XLSX spreadsheet
COSC_ATT_D_Project_Expectations.docx DOCX document
COSC_ATT_D_Project_Expectations.docx DOCX document
COSC_ATT_C_Technology_Deployment.docx DOCX document
COSC_ATT_C_Technology_Deployment.docx DOCX document
COSC_ATT_B_Prof_Svcs_Reference.docx DOCX document
COSC_ATT_B_Prof_Svcs_Reference.docx DOCX document
COSC_ATT_A_Prof_Svcs_Background.docx DOCX document
COSC_ATT_A_Prof_Svcs_Background.docx DOCX document
Show all 20

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

Sheet1

City of St. Cloud, FL
Attachment G (Interface List)
Column E: Available Responses
Replace w/ERPSystem is replaced with functionality native to the new the ERP
Replace w/New TPSSystem is replaced with a new Third Party System (TPS) that has been proposed as part of the new solution
KeepKeep the current system and build a permanent interface as part of the project
Column F: Available Responses
Inbound OnlyData will be pulled from the TPS into the ERP System
Outbound OnlyData will be pushed from the ERP System into the TPS
Bi-DirectionalData will be pushed from the ERP System into the TPS and pulled from the TPS into the ERP System
Column G: Available Responses
TemporaryInterface will be needed for limited amount of time during the project be will not be necessary after the project is completed
PermanentInterface will be needed for the life-time of the ERP System
Column H: Available Responses
Real-TimeData is transferred, at a minimum, every 15mins.
HourlyData is transferred, at a minimum, every 60mins.
DailyData is transferred, at a minimum, every 24 hours
WeeklyData is transferred, at a minimum, every 7 days
MonthlyData is transferred, at a minimum, every 30/31 days
Column J: Available Responses
Yes
No
NOTE: All new Third Party Systems (TPS) that are part of the proposal should be added to this list.
THIS SECTION IS TO BE COMPLETED BY THE VENDOR/PROPOSER
System NameDescription / Use CaseData ElementsCity's PlanVendor RecommendationDirectionTemporary / PermanentFrequencyComments
AS400 (Central Square)Record and depreciate capital assets as well as inventoryTransactions, Capital assets, various documentsReplace w/ERPNone
Operative IQUsed for managing all FD assets, maintenance, records, annual test, EMS, and station supply ordering, Vehicle records,and maintenanceAsset inventoryKeep
CityWorksGIS-centric application to track assets, service requests, and work orders (integrated with citizen reporting portal)Work orders, service requests, asset inventoryReplace w/ERP
LaserFischeUsed to store copies of capital purchases and resolutionCapital asset purchasesKeepNone
FacilityDude/Asset EssentialsUsed to manage work ordersWork ordersReplace w/ERP
Fuel MasterUsed to manage fuel inventory in tanksFuel inventoryKeep
Excel/Debt bookUsed to track leases, SBITA's and debt, who is allowed to use assetsLeases, debt documents,Keep
CivicPlusUsed to track disposal request resolutions for City CouncilService requestsKeep
KACE (MDM, SDA, SMA)Used to track assets, manage system updates, ties into support ticket system.Asset inventoryKeep
AS400 (Central Square)Used to house transactionsTransactions, Capital assets, various documentsReplace w/ERP
ExcelUsed for numerous required spreadsheets including financial, budgeting, asset management, etc.Budget allocations, asset inventoryKeep
OpenGovUsed for budget preparationBudget allocationsReplace w/ERP
WasteWorksUsed for billing trash and specialized recycling pickup.Service requests, service reportsReplace w/ERP
DetailCommanderUsed for billing vendors that hire police officers for special details.Vendor payments & invoicesReplace w/ERP
RecTracUsed for billing for facility rentals, summer camps, marina use, etcRental recordsKeep
CryWolfUsed for billing for false alarms through Public Safety's outsourced programOut-sourced program payments & invoicesKeep
OpenGov PermittingUsed for issuing special event permitsPermitsKeep
DigiTechUsed for billing for emergency medical transport services, Billed monthly per services based on transactionMedical services, payments & invoicesKeep
TrackItUsed for billing for citations issued by the Code Enforcement Department. / Building permit fee assessment and paymentPermits, Assessment records, payments & invoicesKeep
CognosUsed to produce pension reports from AS400 for pension portal./ Used for Building Monthly/Daily & Quarterly ReportingPension reportsReplace w/ERP
AS400 (Central Square)Used to store positions; Used to store Payroll informationTransactions, Capital assets, various documentsReplace w/ERP
HRISUsed to enter new hires, store personnel information, files, etc.Employee positions, Employee files, Employee informationReplace w/ERP
NeoGovUsed to store job descriptions, training, certifications, performance evaluations, e-formsJob descriptions, Policies, Trainings, Evaluations, CertificationsReplace w/ERP
LaserFicheUsed to store Personnel/Medical informationEmployee information, Medical recordsReplace w/ERP
CognosUsed to create and run reports from AS400/HRISVarious reportsReplace w/ERP
NeoGovUsed for recruitment (online application, onboarding)Applicant information, onboarding documentsReplace w/ERP
KACETicketing system used by departments to enter personnel actions for HR to process (pay, promotions, transfers, terms)Pay schedules, Policies, Employee filesReplace w/ERP
ExecuTimeUsed for Timesheet/timeclock entry and approvals; time off requests/approvals; pushes to AS400Schedules, Time reportsReplace w/ERP
VectorSolutionsUsed for scheduling and timekeeping all Fire Department staffsSchedules, Time entry recordsReplace w/ERP
AS400 (Central Square)Used to process payroll; Depts pull in data from ExecutimeTime reports, balances, rostersReplace w/ERP
Excel timesheetsUsed for Timesheet/timeclock entry and approvals; time off requests/approvals; pushes to AS400Replace w/ERP
PointnPay (housed in TrackIT)Used to accepts online payments and issues permits to customersPermits, ReceiptsKeep
Selectron (housed in TrackIT)Used to accepts online payments and issues permits to customersPermits, ReceiptsKeep
RecTrackUsed for record rentals, programs, activities, contractor classes, etc.Rental records, Leases, ContractsKeep
CryWolfUsed for alarm system registrationAccount informationReplace w/ERP
CoreUsed for payments to the Fire Department and transportation fees, replacement in the work ETA 3-4 months company called LIVPayment ReceiptsReplace w/ERP
WasteWorksUsed for utility bills & customer accountsUtility bills, Customer accountsKeep
OpenGov (ProcureNow)Used for vendor solicitation, contract storage, and communicationContracts, Vendor lists, Vendor solicitationReplace w/ERP
AS400 (Central Square)Used for issuing payments, maintaining vendor records, and tracking remittance information; used to generate live PO numbersVendor records, Receipts, POs, RemittancesReplace w/ERP
Shared DriveUsed to store scanned documents outside digital systemsDocument inventoryKeep
Physical file storageUsed to store paper forms outside digital systemsDocument inventoryKeep
CivicPlusUsed to generate resolution for Council reviewResolutions, PoliciesKeep

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