OH2022 - Dashboard

Status	IN PROGRESS
Impact	MEDIUM
Driver	Alessandro Domanico
Approver	Claudio Rosazza
Contributors	Alessandro Domanico miz
Informed	Ilario Gavioli Alberto Mandelli
Due date	30 Jun 2022
Resources	https://docs.google.com/document/d/1scNMAkKK9gLFbswDtkJr0bUiv2IPr7g9dakElBInvEs/edit?usp=sharing document https://github.com/informatici/openhospital-ui

\uD83D\uDCDA Relevant data

The goal is to implement an extension of Open Hospital UI with an anonymous data analysis system for monitoring purposes to obtain appropriate metrics on services provided, status of the drug warehouse, epidemiological cases, cases of non-communicable diseases, malnutrition, gestational problems, childbirth and premature deaths.

To design of a new page into Open Hospital UI, with a structure to be customizable by the user and easy to extend in the code.

The page should be optional after the login, only for enabled users.

\uD83D\uDCD8 Background

At the moment Open Hospital software (in both its GUI and UI - under development) is missing a landing page after the login in which an administrator, a medical director or any enabled users, can have a grasp of main indicators such as:

📱 Use cases

Possible insights to be shown (API already available):

Nr. of OPD today, yesterday, 1 week, 14 days divided by Age and Sex
Nr. of current Admissions divided by Ward, Age and Sex
Nr. of discharges today, yesterday, 1 week, 14 days divided by Age and Sex
Average length of stay (admission duration) divided by wards
Bed Occupancy Rate (BOR = number of admission / number of beds) divided by wards and period (today, last week, this month, last month, this year)
List of drugs under critical level order descending
List of most consumed drugs today, yesterday, 1 week, 14 days order descending
Forecast of drugs consumption (most consumed drugs last year, same period)
List of most frequent diagnosis today, last 3 days, this week, divided by city and address with possibly showing them on a map
Nr. of children under malnutrition control
Nr. of patients under chronic control
Nr. of patients under ANC, delivery and PNC today
Nr. of deliveries today, yesterday, this week, last week, this month, last month, this year divided by outcome
Total bills collections and total bills unpaid today and everyday back this week divided by OPD and IPD
Total bills collections and total bills unpaid this month, last month divided by OPD and IPD

👨‍🏫 Required features

Responsive UX
Customizable layout

\uD83C\uDF08 Options considered

Option 1

Option 2

Option 3

Description

Replicate Open Hospital structure
(Spring + React + Material UI)

Start by existing frameworks
(e.g. Django / Flask / Express / etc…)

Customize existing softwares
(e.g. SuiteCRM / Odoo / YetiForce / etc…)

Pros and cons

Same as Open Hospital, in the future the two projects could be easily merged

Homogeneity, same community can contribute to the project

Building a project from scratch can be overwhelming

Many feature already built-in

Fast development

Different languages (like Python) would require a community widening

Special features may need the framework itself customization

Some features granted by the software itself

Security and state of the art updates granted by the software’s community itself

Focusing on the final results without caring too much about the structure

Customizations need to master how the software works internally

Strong binding to an existing software can be a risky strategy

Estimated cost

SMALL / MEDIUM / LARGE

\uD83D\uDCDA Relevant data

\uD83D\uDCD8 Background

📱 Use cases

👨‍🏫 Required features

\uD83C\uDF08 Options considered

✅ Action items

\uD83C\uDF1F Outcome