SunGard Payroll and Personnel Employee personnel data and payroll Human Resources R Human Resources / Payroll SunGard Building Permits Building inspections and permits Planning R Permitting SunGard Building Permits Mobile Inspection Field building inspections and permits Planning R Permitting SunGard Field Connect Building Permits Field building inspections and permits Planning R Permitting SunGard Land and Parcel Management Addressing and land management Planning R Land Management SunGard Occupational Licenses Business licenses City Clerk R Business Licensing SunGard HTE Utility Utility billing for sewer, and trash Utilities R Utility Billing SunGard Customer Information System Customer accounts for utility billing Utilities R Customer Information System SunGard Case Management Court case management Municipal Court R Court Management SunGard Municipal Courts (Mod) Court docket management Municipal Court R Court Management SunGard NaviLine Extended HTE functionality using Windows-like user interface Multiple R Reporting / Business Intelligence SunGard Extended Reporting Reporting Financial Services R Reporting / Business Intelligence
SunGard Click2Gov (C2G) Web portal, online payments, and citizen self service Financial Services R Citizen Self Service SunGard Document Management Services (DMS) Document retention and retrieval Multiple R Document Management ArcGIS Desktop, ArcSDE Data Collection Maintenance, and Analysis Data Management, Storage Planning I N/A ArcGIS Online Hosts Web maps and applications. Administration tool for named users Planning I N/A ArcGIS Portal, ArcGIS Pro (Future) Hosts Web maps and applications Administration tool for named users Planning I N/A ArcGIS Server GIS data available to web browsers and other applications Planning I N/A Badger meter software / AMI Utilities I N/A CityWorks Server Service requests Work orders Asset management Reporting Planning I Work Orders Cognos Reporting (SunGard to Financial Services Human Resources Court Planning R Reporting / Business Intelligence
Faster Fleet Management Public Works I/C N/A FuelMaster Fuel Management Public Works I N/A Infoworks CS Sewer Modeling Planning M N/A Infoworks WS Modeling Planning M N/A IPS Meters & Parkfolio Parking Meter Revenue Data Financial Services - Treasury I N/A Laserfische Electronic Content Management Multiple I N/A Legistar Council agenda management City Clerk M N/A Microniche ETS Workers' Compensation and Workplace Incident Case Management Human Resources R Human Resources / Risk Management Microsoft Access Applicant tracking and report tracking Human Resources R Resources Microsoft Access Stores manual checks that are written-information for all Trip activity Financial Services - Treasury R Payroll Microsoft Budget prep and budget Multiple R Budgeting Monarch Reporting Payroll R Reporting / Business Intelligence
Methods for the City to identify, specify, and develop required custom City reports during the implementation. Integrations and Interfaces (Section 6.6) It is expected that information generally would need to be entered only once into the system. Modules within the system should be integrated in real-time with each other such that batch processes are not required to transfer information from one area of the system to another unless that is the preference of the City. Existing City interfaces between core modules that may currently exist (e.g., AP posting to GL) or shadow systems that will likely be replaced are not included as they are assumed to be included in an integrated ERP System. The following tables contain a listing of current and/or desired City application interfaces and their likely need in a future integrated software environment. Data Flow Item # Data Flow Description Source Application Target Application Currently Exists Needed in new ERP Environment 1 Send Positive Pay files to bank Accounts Payable Bank of Oklahoma X X 2 Yearly 1099 & W2 submission Accounts Payable US Treasury X X 3 Vendor Payment ACH file export / import Accounts Payable Bank of Oklahoma X X 4 Online Payments Authorize.net Cash Receipts X X 5 Upload/download of read information Badger Utility Billing X X 6 Import bank statement electronic file Bank of Oklahoma Bank Reconciliation X X 7 Daily lockbox transfers Bank of Oklahoma Cash Receipting / Miscellaneous Receivables / Utility Billing / General Ledger X X 8 Traffic citation receivable status routed from Brazos to the ERP system to maintain a Brazos Cash Receipts / General Ledger X X
18 Fleet information Faster Fixed Assets X X 19 Vehicle information for risk management, claims, and insurance records Faster Risk Management X X 20 Fuel inventory FuelMaster General Ledger X X 21 Monthly sales tax reports Monthly NAICS reports General Ledger Oklahoma Tax Commission X X 22 Requests for service and complaints / Code Compliance GovQA / WebQA Work Orders / Utility Billing / Customer Management System X X 23 Grant opportunities Grants.gov Grant Accounting X X 24 Employee profiles (names, departments, labor rates, etc.) Resources CityWorks X X 25 Employee profiles (names, departments, labor rates, etc.) Human Resources Faster X X 26 Integrate the Human Resource module with the system verifying social security numbers or passport ids for I-9 compliance. Human Resources E-Verify X
27 ACA reporting Human Resources Department of Health and Human Services X X 28 EEOC Reporting Human Resources U.S. Equal Employment Opportunity Commission X X 29 Quarterly wage reporting for all employees and new employee information Human Resources / Payroll Oklahoma Employment Security Commission (OESC) X X 30 Import / sewer modelling information for rate making InfoWorks WS / CS Utility Billing X 31 Complete job costs, including materials cost and usage Inventory Management CityWorks X X 32 Meter inventory Inventory Management Utility Billing X X 33 Reorders based on preventative maintenance schedules Inventory Management Faster X X 34 Import credit card transactions from IPS Parking Meters to the General Ledger IPS Parking Meters General Ledger X 35 Import of electronic payment files from IVR Software Selectron IVR software (or recommended IVR) Cash Receipting (apply payments to all applicable module) X X
36 Integrate with an integrated voice response system to allow customers to be able to inquire on account and bill information via phone. Selectron IVR software (or other recommended IVR) Utility Billing, Business License, Misc. Billing/AR, Permitting, Inspections & Code Enforcement X X 37 Save, index, and retrieve files from ERP modules to/from Laserfiche Laserfiche / ERP (all modules) ERP (all modules) / Laserfiche X 38 In order to make Legistar documents accessible from Grant/Project Management & Contract Management module (such as resolutions, minutes, project summaries, etc.) that are related to grants/projects and contracts. Legistar Grant/Project Management & Contract Management X 39 Import/export employee demographic and benefit election information to/from the benefit providers and to/from human resource module. Meritain Health / Human Resources Resources / Meritain Health X 40 Export/Import risk management/claim information from Microniche (or replacement claim management software) to the Human Resource module Microniche Resource X X
41 Pictures taken in the field Mobile devices Work Orders / Utility Billing / Customer Management System X 42 Rain & Temperature monthly reports for water usage and revenue data Oklahoma MesoNet Utility Billing X 43 Payments made through Online Bill Pay Online Bill Pay Cash Receipting / General Ledger / Utility Billing X X 44 Import cash receipts from Parks and Recreation software to ERP cash receipts (in summary) Parks and Recreation (if proposed) ERP cash receipts (in summary) X 45 Import GL entries from Parks and Recreation to General Ledger and Recreation (if proposed) General Ledger X 46 Export of Payroll Direct Deposit data Payroll Bank of Oklahoma X X 47 Send Positive Pay files to bank Payroll Bank of Oklahoma X X 48 Police pension transfers Payroll Oklahoma Police Pension X X 49 Fire Pension transfers Payroll Oklahoma Fire Pension X X 50 Retirement Transfers Payroll Fidelity Investments X X 51 Import a file from Procurement Card software to ERP Accounts Payable. P-Card system Accounts Payable X X 52 Integration from SCADA to Asset Management for triggering preventative SCADA Asset Management (if proposed) X