FM_UB_ATT_9_Conversions_v1.xlsx

This is a data conversion specification document for the City of Fort Myers, Florida's Utility Billing System implementation project. The document outlines the scope of data to be migrated from the City's existing systems to the new Oracle Utilities Billing System. The conversion encompasses multiple functional areas including customer information (30,631 records), account data (31,042 records), water and sewer rates (35 fee distributions, 170 fee definitions, and 45 fee rates), property location information (40,624 records), and utility meter inventory (32,331 records). Additional data migration includes service requests totaling 412,795 records (3,041 pending/working and 409,754 completed), billing information with 370,177 receipts and 394,533 bills as of August 5, 2025, routing data for seven residential routes serving 3,907 weekly pickups and 220 commercial pickups, and solid waste container inventory consisting of approximately 7,840 active containers. The document uses a vendor response matrix format to track agreement status and pricing inclusion for each data category.

The conversion specifications indicate estimated consulting hours and client hours required for implementation, though specific hour quantities are not detailed in the visible portions of the document. The pricing structure requires vendors to specify whether each data conversion function is included in their overall implementation price. The document does not specify response dates, due dates, award dates, or contract term information in the provided excerpt, nor does it address set-asides, incumbent vendor status, or funding sources. This conversion effort represents a substantial data migration initiative requiring coordination between City resources and the selected implementation vendor.