E-clinic & Data Warehouse Development

1.Introduction

1.1. CHAI Overview 

The Clinton Health Access Initiative, Inc. (CHAI) is a global health organization committed to our mission of saving lives and reducing the burden of disease in low-and middle-income countries. We work at the invitation of governments to support them and the private sector to create and sustain high-quality health systems.  

CHAI was founded in 2002 in response to the HIV/AIDS epidemic with the goal of dramatically reducing the price of life-saving drugs and increasing access to these medicines in the countries with the highest burden of the disease. Over the following two decades, CHAI has expanded its focus. Today, along with HIV, we work in conjunction with our partners to prevent and treat infectious diseases such as COVID-19, malaria, tuberculosis, and hepatitis. Our work has also expanded into cancer, diabetes, hypertension, and other non-communicable diseases, and we work to accelerate the rollout of lifesaving vaccines, reduce maternal and child mortality, combat chronic malnutrition, and increase access to assistive technology. We are investing in horizontal approaches to strengthen health systems through programs in human resources for health, digital health, and health financing. With each new and innovative program, our strategy is grounded in maximizing sustainable impact at scale, ensuring that governments lead the solutions, that programs are designed to scale nationally, and learnings are shared globally.  

At CHAI, our people are our greatest asset, and none of this work would be possible without their talent, time, dedication and passion for our mission and values. We are a highly diverse team of enthusiastic individuals across 40 countries with a broad range of skillsets and life experiences. CHAI is deeply grounded in the countries we work in, with majority of our staff based in program countries. Learn more about our exciting work: http://www.clintonhealthaccess.org 

1.2. Background and Situation 

In 2022 MoH has launched SatuSehat, is a national digital health information exchange system that will integrates patient data from various health facilities (SIMPUS, SIMRS, etc), making it accessible to patients and providers through the SATUSEHAT Platform and the SATUSEHAT Mobile app (ASIK), in more advanced to reduce multi silos platform in the MoH (SIHA, SIHEPI, SIGIZIKESGA, SITB, etc), The SatuSehat faces challenges in collecting reliable data from outreach services using the ASIK, with health workers reporting frequent input errors and the DHO is unable to access the data to monitor coverages. 

Stock out incidents still occur frequently in PHCs because currently there is no system to monitor stock status. Moreover, based on monthly stock report 2024, in Bogor, 5 of 33 PHCs and in Bekasi, 16 of 23 PHCs experienced stock-outs of essential medicines for three consecutive months. 

Additionally, more than four different software applications are used to collect similar maternal, newborn, and child health (MNCH) data. These systems operate independently and lack integration, creating data silos, duplicated workloads, and fragmented records. Moreover, in many districts and health centers, some service data is still recorded manually on paper-based forms, causing delays in reporting and reducing the accuracy and completeness of information. 

Due to this fragmentation and limited digital capacity at the district level: 

  • Health managers are often unable to access complete and timely data 
  • Decision-making is hindered by missing or inconsistent information 
  • Service quality monitoring and planning are inefficient and reactive 

There is an urgent need for a unified, interoperable software system that can: 

  • Support structured and streamlined data entry at the point of care 
  • Synchronize data automatically across platforms 
  • Monitor stock status to avoid stock out 
  • Align with national standards (SATUSEHAT) 
  • Provide meaningful dashboards for local analysis and action 

2. Scope

2.1. Develop E-Clinic 

  • Develop e-clinic for users to enter and update individual-level records for ANC, PNC, INC, and Immunization services and the data send to SATUSEHAT and DHO Data Warehouse. 
  • The system should be able to make automatic assessments for making easy in identifying those high-risk patients and prompt to referral option 
  • The system should have feature registration, medical records, lab, logistic/pharmacy, payment, and integrated with P-CARE BPJS including referral mechanisms.

2.2. Database server/Data Warehouse 

  • Develop database server that will put in District Health Office (DHO) server to receive ANC, PNC, INC and Immunization data from all Electronic Medical Records in the district area including from e-clinic. 
  • WA OTP to patient for approval access patient medical records.

2.3. Monthly Report for Logistic (LPLPO) 

  • Provide structured monthly LPLPO forms for reporting medicine usage and requests, including opening balance, receipts, usage, ending balance, stock requested.  
  • The system should have feature to upload LPLPO in excel format. 
  • The system should be able to validate stock (distribution from DHO vs reception in PHC including validate stock min and max) 

2.4. Interoperability 

  • The software is structured to be fully compatible with the SATUSEHAT Platform and supports data push using FHIR APIs, following technical guidelines issued by the Ministry of Health. Detailed specifications for integration can be found at: https://satusehat.kemkes.go.id/platform/docs/id/interoperability/. 
  • The system shall support automated data exchange with other relevant systems through scheduled synchronization, ensuring seamless interoperability without requiring manual import/export. The API or method to synchronize will be provided by software vendors. 
  • System data flow click here: https://bit.ly/45Ttoii

2.5. User Roles and Access

  • Admin: Responsible for configuring system settings, managing user accounts and roles, updating data entry forms (e.g., service and stock reporting forms), and overseeing overall data integrity and compliance with national standards and interoperability requirements.
  • Data Entry Clerk: Responsible for entering and updating service delivery data (ANC, PNC, INC, Immunization) and monthly stock reports (LPLPO) into the system in a timely and accurate manner.
  • Supervisor: /approve submissions, generate reports
  • Viewer: View dashboards and reports only

2.6. Dashboard and Reporting

  • Display near real-time data on service delivery (e.g., ANC coverage, immunization rates), based on the most recent data synchronization with the data warehouse system, acknowledging that dashboards may reflect data with slight delays depending on sync schedules.
  • Visualize LPLPO trends: stock-outs, distribution delays, medicine usage
  • Export graphs and reports in PDF, Excel formats
  • Export reports to excel according to provincial format
  • Filters by time period, location, service type
  • Generate monthly MNCH report (focus on MNCH & Immunization indicators) https://clintonhealth.box.com/s/tygbk65vaoyib82o1uxgd1mxl0sdbk1t

3. Non-Functional Requirements 

3.1. Performance 

  • Support at least 200 concurrent users 
  • Sync time: < 10 seconds per record in normal conditions 

3.2. Security 

  • Role-based authentication 
  • Data encryption at rest and in transit 
  • Regular backups and audit trails 

3.3. Maintenance 

  • Provide maintenance for 3 years 

3.4. Usability 

  • Simple user interface for low-tech users 
  • Multi-language support (Indonesian, English) 

4. System Architecture 

  • Frontend: Web and mobile interfaces designed for ease of use by health workers including using face recognition or fingerprint. 
  • Backend: Modular and scalable server-side components supporting business logic, data processing, and secure API communication 
  • Database: Structured data storage supporting health records, stock reports, and system configurations with regular backup mechanisms 
  • APIs: Standards-compliant APIs (including FHIR and RESTful services) to ensure secure and structured data exchange 
  • Hosting: Deployable in both cloud-based or on-premises environments, depending on national infrastructure and policy requirements 
  • Integration: Supports interoperability with existing health systems such as DHIS2, OpenMRS, and other EMRs through API gateways and scheduled data exchange processes 

5. Deployment and Handover Requirements 

To ensure sustainable adoption and effective use of the system at the district level, the following handover and support requirements must be met: 

5.1. System Deployment to District Offices 

  • The system must be packaged and configured in a way that it can be deployed locally at district health offices, either on their own infrastructure or via cloud access with district-specific accounts. 
  • Deployment should support offline functionality to accommodate districts with unstable internet connectivity. 

5.2. Ownership 

  • The system must be designed for transfer of ownership to the district health office, including all configurations, source code, user permissions, and data. 
  • All products of this contract (property rights) belong to CHAI and District Health Office. 

5.3. Handover Package 

Handover package must include: 

  • System installation manuals 
  • System operation/ maintain manuals 
  • System administration manuals 
  • User manuals (document/ video) 
  • Technical & integration documentation 

6. Vendor Specification 

  • Vendor has experienced in the development of EMR (Clincic/PHC/Hospital) and is connected to SATUSEHAT with at least 7 resources (patient visit, ICD10, observation, procedure, prescription, medication dispense, service request) 
  • Vendors must be registered with SATUSEHAT 

7. Timeline 

We expect the project will be launched in April 2026 

8. Review & Selection Process 

Please submit your proposal, portfolio and CV/track record by 7 September 2025 via email to indonesiaoffice@clintonhealthaccess.org with “Data Warehouse Software Development” as the subject line. In your proposal, please explain why you are the ideal candidate for this project. The proposal should include a detailed budget & Timeline. Only shortlisted candidates will be notified and contacted for an interview. Applications that are received after the deadline or incomplete will not be considered.  

If you have any questions, please email to indonesiaoffice@clintonhealthaccess.org. 

0420840
Visit Today : 2152
This Month : 65034
Hits Today : 2852
Total Hits : 1398768
Who's Online : 14
Visit Us On FacebookVisit Us On TwitterVisit Us On YoutubeVisit Us On Instagram