Environmental Health Software

The vendor is required to provide environmental health software system should which can offer support for all operation and data management of the public health division with easy integration to other systems.
- The ideal solution is web-based with offline operation capability for and modules that can accommodate all the environmental health needs in these areas:
•    Food plan review and licensing (including issuance, investigation, documentation of random and scheduled visitations and food born illness reporting)
•    Pools licensing, investigation and reporting
•    Body art licensing, investigation and reporting
•    Wells investigation and reporting
•    Childcare facilities licensing, investigation and reporting
•    Other businesses and facilities under a variety of county ordinance regulations.
- The software solution should have module to accommodate all types of inspection, licensing needed by the public health division.
- The contractor should be able to implement the software solution and provide training and support of the staff in an on-going basis.
- The provided software solution should satisfy all infrastructure, system integration, security and reporting requirements of the county.
- Permitting and licensing, track application, renewals, fees, and compliance. 
- Reporting and analytics, generate regulatory reports, dashboards, and trend analyses, and be able to export data to excel, pdf, and other reporting formats. 
- Inspection and case management, schedule, assign, track. compliance status and corrective actions. 
- Manage licenses and applications.
1. Security requirements:
•    Capable of 2 factor user authentication
•    Compatible with county security requirements.
•    Including data redundancy and backup plans and capability.
2. system integration requirements:
•    ability to integrate with SharePoint and microsoft office
•    ability to integrate with state of systems.
•    ability to integrate or transit data to other systems such as GIS system 
•    licensing and permit system and BSEED batching and clearance
3. Reporting requirements
•    Ability to run custom reports able to be filtered by a wide range of fields on aggregated and
•    Disaggregated client information and program operations that are able to be exported in various formats (excel, pdf, word, database) such as:
•    Inspections due, inspections completed.
•    Follow up inspections and violations not corrected.
•    Violation frequency reports by inspector
•    Address, email, and establishments listings
•    Payment and license reports
•    P/pf/c/serious violations reports
•    Risk factors report
•    Accreditation reports
•    Inspector work activity reports including risk category for establishment. 
4. System requirement:
•    Act compliant cloud infrastructure with offline capability to house PII and phi information.
•    Ability to accommodate up to 6000 regulated entities.
•    Ability to have support up to 100 internal users (this system should support role specific permissions (e.g., system administrators, managers, investigators, clerks, view only users).
•    The offline capability should include subsequent data integration which avoids errors and data duplicates.
•    Ability for clients to review and edit applications before submitting.
•    Ability to upload relatively large files, including photos and design docs and maps.
•    Ability for e-signature.
•    Compatible with all major internet browsers such as chrome, Firefox, edge, and safari, etc. 
•    Capability for a public facing web-portal for customers, to apply, submit, track and send and receive notifications.
5. Inspection management:
•    Create and manage inspection schedules based on risk factors and permit types. 
•    Ability to configure and document inspectors time for each inspection and potential scheduling and work assignment by managers is preferred. 
•    Pre-configured inspection checklists for different restaurant types and food service operations. 
•    Capture photos and videos as evidence. 
•    Ability to record observations, violations, and corrective actions during inspections, append pictures, media and weblinks to the reports. 
•    Ability to communicate directly with the customer on their account and show the history of communication. 
•    Ability to generate reports on subgroups of customers with specific compliance and violations.
•    Ability to post payments, fees, fines and collect payments from customers from their own account and generate associated reports. 
•    Generate comprehensive inspection reports with automatic scoring and risk assessment. 
6. Data management: 
•    Possibility to host the database on microsoft azure. 
•    Ability to audit all inspection trails and version control. 
•    Advanced search and filtering capabilities for historical data analysis. 
•    Import and export data through APIs and standard formats. 
7. Communication and collaboration: 
•    Ease of communication between to internal channels between inspectors, supervisors, and external to restaurant owners via text message, email or note to their account inbox. 
•    Online portal for restaurant owners to view progress reports, inspection results, corrective action plans, and other relevant documents. 
•    Public dashboard to share aggregate food safety data with the community.

- Contract Period/Term: 3 years
- Questions/Inquires Deadline: July 22, 2025