Documentation Category: Data Warehouse

Data dictionaries

The following is a list of data dictionaries. Click on the link to open. C&T Data dictionary HTS DWAPI Data Dictionary PrEP DWAPI Data Dictionary MNCH DWAPI Data Dictionary

DWAPI – Master Patient Index (MPI) Tables

Master Patient Index: Data is transferred to CBS Central Database tables i) Master Patient Indices   Column/Variable Name DataType Required Description Examples Id uniqueidentifier Mandatory PatientPk INT Mandatory EMR

DWAPI- HIV Care & Treatment tables

HIV Care and Treatment services: Data is transferred to DWAPI Central Database tables i) Patient Extract Column/Variable Name DataType Required Description Examples PatientPK INT Mandatory EMR Internal System generated

DWAPI – HTS Tables

DWAPI tables are cartegorized as per the dockets. The following set of tables shall be for the HIV Testing and Prevention Docket. HIV Testing services: Data is transferred to

Achieving deduplication

To achieving deduplication in the data warehouse patient matching starts at the facility level in the EMR and is strengthened in DWAPI as illustrated below; Patient matching in DWAPI

SPOT

SPOT (Single point of truth) is the DWAPI upload verification site for DWH. Successful uploads are listed with the following variables; MFL       : The health facility MFL Code Facility 

DWAPI Tables

DWAPI Architecture

NDWH APIs consists of the following Endpoints running as separate services for the respective Docket: 1)Care and Treatment This API Service exposes the following REST endpoints that accepts messages

DWH Databases

[vc_row row_content_display=”in_grid” row_content_display_align=”left” row_type=”row” stretch_row_type=”yes”][vc_column width=”5/6″][vc_column_text]The DWH contains four databases; HTS Central- This contains tables for HIV testing Services data Dwapi Central-This contains tables for Care and Treatment data

DWH Data sources and integrations

Data sources The DWH data is sent through the Data Warehouse API (Dwapi) and the data originates from the disparate EMRs that are in the Ministry of Health (MoH)