The Ministry of Health (MoH) currently has multiple processes which serve to collect data from BC Health Authorities (HA) and process it. The data ingestion processes are not standardized and are fragmented across multiple standalone solutions and technologies. This fragmentation raises multiple issues (e.g. confused user base, overlap of data collection, complexity to maintain, overhead cost for maintenance); The Ministry would like to find a solution to rationalize the technical mechanisms currently used for collecting data from the Health Authorities while following the Ministry’s technology roadmap and cloud strategy.
The CGI team, along with leadership from Freshworks, worked on analyzing a number of existing tools and solutions on the market, and the ones in use within other Ministries. The Ministry of Health also raised new needs such as the HCC & MHSU Bed Survey or the modernization of the Addiction Information Management System (AIMS), which were incorporated in the analysis to guide the design of a new standard solution for data ingestion. This analysis was partially shared through a high-level analysis document. That document provided a high level design for a new data ingestion process and a high level roadmap to help the Ministry transition towards this new standardized solution.
The above-mentioned analysis was leveraged to identify the new standard solution for HA data ingestion, which will be based on a customized version of the Common Hosted Electronic Form Services (CHEFS) platform developed for the Natural Resources Sector (NRS).
As requested by the Ministry, the scope of this project will be split between this fiscal year and next fiscal year.
Proposed features:
Must support integration with Keycloak (OIDC Oauth) |
Must support different roles and permissions |
Must support local data storage |
Must provide drag&drop form builder capabilities (self-served) |
Must support self served publications |
May support complex layout editor |
Should support field auto population |
Must support shared form submission |
Must support the ability to upload files in Excel format (.xlsx) |
Must support simple in line validation rules (frontend) |
Must support complex validation rules that require data lookup from external systems |
Must support real time validation results (for both forms and files) |
Must support simple submission workflow |
Must support creation of APIs for data extraction |
Must prevent duplicate form submission |
Must be extensible to add new capabilities in the future |
Must support ordered delivery of files/forms submissions |
Must support partial form submission |
Must support draft submissions (i.e. when a user needs time to fill out a form and should save it) |
Must support deploy anywhere methodology (e.g. containers, cloud) |
Must support activity logging and monitoring |
Should be Open source |
Should support open source data store format |
Should support malware identification |