Title
2018-091 Request for Proposal, FileMaker Database Services (B)
**This item was presented to the UAB on September 13, 2018.**
Explanation
In the mid-1980’s, GRU staff began using a product called FileMaker, a highly scalable Relational Database Management System software, to support several of GRU’s operational functions. At that time, a small number of trained departmental staff provided development and support for GRU’s FileMaker applications. Over the last 20 years, FileMaker has become a valuable tool for tracking and reporting data and is now used daily in most operational areas of the utility. Use of FileMaker has expanded today to over 100 active users in Water/Wastewater Treatment Operations, Water/Wastewater Engineering, Energy Supply, New Services, Real Estate, and soon GRUCom.
FileMaker databases at GRU include:
· W/WW Systems databases to document important information
o Lift station attributes
o Fire flow testing data
o Tracking new development projects (used by W/WW Engineering, New Services and Real Estate)
o Calculation of Additional Developer Fees and Estimates (used by W/WW Engineering and New Services)
o Environmental incident tracking/reporting
o Capital budget tracking
o Purchase Order tracking, receipting, internal approvals and reporting
o W/WW Construction Daily Reports
· Environmental Programs for FDEP Environmental Compliance
o Database to implement GRU’s Commercial Fats, Oil and Grease program
o Online Grease Hauling database for external grease haulers to input pumping data for compliance
o Database to implement GRU’s Residential and Commercial Cross Connection Control database
o Online Cross Connection Control database for external testers to input compliance data
o Industrial Pretreatment database - tracking and reporting
Industrial Pretreatment Calculations for annual reporting
o Industrial Pretreatment Calculations for Local Limit development
o Operation and Maintenance Performance Reports for MWTP and WRFs
· Water/...
Click here for full text