Integrated Environmental Health and Regulatory Compliance Management System

Integrated Environmental Health and Regulatory Compliance Management System that include:
Provide a SaaS (Software-as-a-Service) customized solution to meet all requirements in this RFP (request for proposal)
Support major browsers such as Chrome and Edge
Have a responsive design for tablets, phones, and computer screeens
Requires no installation or any special changes to the browswer or device setting
Have standard password and username log-in functionality, such as password complexity and length requirements, self-serve reset and update, and automatically logging out after a period of inactivity
Have different roles, such as View, Write, Admin, for different users to access different levels of data
Allow Admin users to make changes throughout the system, such as user accounts, reports, facilities, predefined statements, etc.
Have logs of user activities, and allow Admin users to run audit reports
Allow traffic of up to 100 users simultaneously using the service without latency
Integrate with City of Philadelphia Azure Active Directory (Desired)
Have a user-friendly interface with robust search functionality such as partial address, facility name, inspection result, health district, etc.
Allow staff to export searched results as CSV (comma-separated values) or Excel format
Show searched results with different colors or indicators for predefined criteria, such as initial inspection due and reinspection due
Include basic data objects such as Facility, Inspection, Owner, License, User, Violation, Health District, Facility Type, Predefined Statement, etc.
Include necessary and customized forms with tailored data fields for creating, reading, updating, and deleting (CRUD) for the data objects mentioned above
Signature input is needed
Violation sets toggle depending on facility type
Allow staff to securely upload and attach various formats, such as PDF, Word, and common picture formats
Keep record change logs
Lock editing for certain user roles after a certain time
Allow autosaving to avoid data loss due to weak connectivity
Integrate with City of Philadelphia Address Information System (Desired)
Have a flexible GIS (graphic information system), Esri ArcGIS preferred, reporting capability for all facilities in the database
Provide specific and customized ad-hoc and auto-populated reports, such as the License Eligibility Report and the Radar Report
Allow staff to export inspection reports in HTML, PDF, and email with PDF formats
No upper limit on emails per day
Standard protocol for email proxy
Provide basic real-time reporting capabilities
Existing functionality – carry over all functionalities from the current system to the new system (Food Inspection, Environmental Engineering (EE) Inspection, Complaint, Self-configuration capability by internal staff (predefined statement, violation category, email message, dropdown fields, etc.)
Allow limited look-up functionality for the public to search for the most recent inspectional reports
Preventing web scraping
Accommodate dynamic web traffic for report lookup
API (application platforming interface) Access
API library functionality
GET endpoints exposure for most of the data
Allow customized access level
Allow customized endpoints
Encrypted and secure endpoints
Must convert all existing data (2 GB) and files (60 GB) from the current system to the new system without any data loss
No upper limitation on future data and file size growth
Have a daily backup plan without record locking
Allow Admin users to access daily backup files or provide read access to the backend data that allows advanced query
Enable data encryption at rest and in transit
Have a disaster recovery plan
The proposed solution should provide near-real-time data exchange mechanisms with other external systems.
In addition, supporting data architecture must support data sharing with internal PDPH data sets and data sets owned by EHS external partners.
Provide initial system training
Ensure 99.9% uptime
Provide a customer relationship management platform for reporting issues and submitting change requests
Provide timely and effective maintenance, updates, and changes upon request
Allow up to five (5) minor feature changes per contract year without extra charges
Create a centralized internal and public portal for the following program areas (Food Safety Certification Application, Plan Review Permitting/Inspection, Special Event Permitting/Inspection, Body Art Permitting/Inspection, Pool Permitting/Inspection, Tobacco Permitting/Inspection)