EMR System Support

Job ID : 2021-3403

# of Openings : 1

Category : Information Technology

Position Location: City : Harare

Region : Population Services International

Position Location: Country : Zimbabwe

POPULATION SERVICES INTERNATIONAL (PSI)

REQUEST FOR PROPOSALS

Click here for full RFP

REQUEST FOR PROPOSAL (RFP) NO. : RFQ-2021-CSLT-4498-38

TO PROVIDE : EMR System Support

ISSUE DATE : 07/15/2021

LAST DATE FOR RECEIPT OF

CLARIFICATION QUESTIONS BY PSI : 07/22/2021

RFP CLOSING DATE : 08/05/2021

PROPOSALS MAY BE DELIVERED BY EMAIL To: Amber Sheets (asheets@psi.org)

PSI Zimbabwe has implemented Bahmni EMR in 18 clinics across the country. Bahmni EMR is the primary data system for ART, Cervical Cancer Screening, Family Planning, HTS, TB Screening, NCD and PrEP patient clinical data. The Bahmni/DHIS2 integration service pushes deidentified client level data from the EMR to DHIS2 for extended analytics. The PSI Zimbabwe Bahmni implementation repository can be found on GitHub here: https://github.com/psi-zimb

PSI/Z seeks support on the following activities to attain full functionality of the EMR:

Bahmni/DHIS2 Synchronization - Resolve Bahmni/DHIS2 synchronization errors. Documentation of all synchronization errors. Synchronization service should log errors and continue and not abort as is the case currently. Provide capacity to PSI team to modify the sync process.

PWA performance - Resolve PWA bugs

. Improve overall performance of PWA

. Allow PWA download of specific clients in addition to location-based synchronization strategy.

Upgrade of the current Bahmni product

- from 0.91 to 0.92 or 0.93 to enable the team to deploy future clinics or redeployment in the event of server failure. The upgrade should entail the infra setup for 5 clinics with PSI shadowing for capability building, regression testing: Upgrade of Bahmni Mart to the latest version and resolution for critical observations/ issues from regression testing. The deployment steps must be automated and documented to all for rapid deployment without online dependencies.

Tags data elements family planning information systems information technology

Capability building and Documentation for PSI/Z team - Provide capacity to PSI team on how data is saved from forms to the DB; Flattening of data - SQL queries that are used to flatten data from Open MRS to analytics DB; How to add variables to preview; Sync process and error handling and creating and editing custom display and edit controls.

Metadata Changes - Addition and removal of Observation form concepts as outlined in the metadata changes document. Removal of all duplicated concepts in forms Addition of new STI program with Auto enrolment. Making all clinical observation forms mandatory. Provide capacity for team to modify metadata (Attributes; Concepts; Form conditions; Custom display and Edit controls).

Unbundling of all Observation forms for Health areas with Multiple visits. Make Assessment and Plan; PREP continuation and FP Continuation forms standalone that send data elements with event dates to DHIS2.

Active system/ services monitoring through Nagios - Provide real-time monitoring of server performance. Auto deletion of server archive files.

Production support activities - Resolve support tickets raised in Jira/Helpdesk.

Deliverables

Category

Deliverables

Sub tasks

DHIS2/Reporting

Unbundle all Obs forms for Health areas with Multiple visits. Make Assessment and Plan; PREP continuation and FP Continuation forms standalone that send data elements with event dates to DHIS2.

Create Mapping SQLs to sync PrEP Screening form data to Instance, Enrolment and Event record tables to new stage created for PrEP Screening form. Modify existing PrEP SQLs to remove fields to stop syncing prep Screening data to PrEP stage.

Modify Mapping SQLs to change the triggers for syncing PrEP initial and continuation forms data to DHIS2.

Modify SQLs to change the triggers for syncing ART Initial compulsory form 1 of 1 and Assessment & plan form data to DHIS2 for ART program.

Modify SQLs to change the triggers for syncing HIV Self testing form or Provider HIV test counselling form data to DHIS2 HTS program.

Sync event dates for the Assessment and Plan; PrEP continuation and FP Continuation forms.

Metadata Changes

Addition of new concepts as highlighted in Metadata changes document.

Addition of new concepts. Creation of general screening custom display control. Move highlighted concepts from various health area forms. Update all SQLs to sync the new concepts to DHIS2.

Removal of all duplicated concepts in forms

Disable duplicate concepts without data loss Write migration scripts to delete the duplicate concept.

Update the downstream for the duplicate concepts.

Make all clinical obs forms mandatory

Programs

Addition of new STI program with Auto enrollment.

Add STI Program concept (Program, Program State, Program outcomes). Configure a new queue for STI program and display the clients enrolled in that program. Auto-enroll the client into STI program based on the visit.

Display Control

Forms display control - Edit restrictions

Restrict users from editing a form after the defined time period or a deadline.

0.91 to 0.92 Upgrade

Rebase with product version 0.92

Identify the merge conflicts from product.

Resolve the merge conflicts.

CI/CD setup for generation of 0.92 artefacts

Infra setup

Set up Dev/QA Test environments with Bahmni 0.92

Regression Testing

Test the All modules in Bahmni 0.92 instance

Upgrade Mart to latest version

Rebase with master.

Testing PSI custom Mart config.

Resolution for critical observations/issues from regression testing

Nagios setup

Release activities

Upgrade Production environments s to 0.92 and perform basic sanity check.

DHIS2 Integration Service

Resolve DHIS2 synchronization bugs

Improve exception logging - process must log all errors and allow system continue synchronization. Resolve all synchronization errors not currently documented. Reduce payload size from 10,000 to 50 (as recommended by DHM) Test End to End synchronization in production environments.

Support

Resolve support Tickets

Production environment support and documentation. PWA sync page not loading. Auto archiving to replace manual purge of Archive files. Bahmni Mart installation errors.

Capability Building

Provide capability building to PSI Information Systems team

1. OpenMRS database - OpenMRS database structure - CRUD operations in OpenMRS database 2. Flattening of data - SQL queries that are used to flatten data from OpenMRS to analytics DB - Adding variables to Preview - Adding concepts to sync from Bahmni to DHIS2 3. DHIS2 sync process and error handling - Bahmni-DHIS2 sync process, TEIs, Enrolments and Events - Bahmni-DHIS2 sync process sync error log with instructions 4. Custom Display controls - Adding forms on the custom display menu 5. Form logic - Adding cross form logic on the forms

Backup-Automatic failover of Master/Slave server

Implement automatic failover of primary/ secondary servers

Infrastructure Improvements

Implement automated archive deletion

Reduce effort of roll-out to new clinics

Prepare a base model to initiate new clinics setup using an image.

Documentation

Technical documentation

Provide detailed implementation documentation for all Task order deliverables.