160 likes | 295 Views
Building an Integrated Data Warehouse: Kenya’s Master Health Facility List. Samuel Cheburet HIS, Kenya. Ministry of Public Health and Sanitation. Ministry of Medical Services. What is the MFL?. Master Facility List
E N D
Building an Integrated Data Warehouse: Kenya’s Master Health Facility List Samuel Cheburet HIS, Kenya Ministry of Public Health and Sanitation Ministry of Medical Services
What is the MFL? • Master Facility List • The official list of all the health facilities operating in Kenya, maintained by the District Health Management Team.
Need for the MFL - 1 • Over 70 existing databases holding facility level data 2. Databases with different facility codes
Need for the MFL - 2 Use 3 - Resource Saving – District Level 3. Duplication of efforts to maintain facility lists There MUST be a more efficient way…. ! A single list, from which all the other lists are extracted The DMOH, DPHN and Others keeps a list of facility in charges and their contacts The DHRIO makes the monthly reports, FTP and AOP – All based on Facility Lists The DMOH and DHRIO keeps a list of Partner contacts and the facilities they support in the district The DPHN and KEPI have lists of “KEPI Facilities” The administrative officer keeps the list of permanent assets and the facilities where the assets are found EVERY BODY has facility contacts The Divisional Nurse & DPHN keeps a list of “Facilities by Division” Many officers keep Facility email contacts The DHRIO and DPHN keeps a list of “Facilities and their target populations” The Storeman also keeps the “KEMSA facility list” The RH Coordinator keeps a list of “Facilities Offering RH” The DPHN and DPHO Keep a list of staff and their training that includes a facility list The DPHN / DPHO Lists the community units/CHEWs/CHWs and these are linked to facilities The DHRIO,DPHN and Stores all have lists of “Facilities by Level and Type” The DASCO/DTLC keeps a list of “VCT/PITC/ART/TB sites”(and usually these are all separate lists) The Clinical officer/DPHN/DPHO and Personnel Maintain a list of staff and this list has a list of “Facilities where staff work”
Need for the MFL - 3 • Lack of standardized definitions of and listing of availability of services offered
What constitutes the MFL? • List of facilities • Geo-codes for all facilities • Definitions of services • Contact information • Public access portal www.ehealth.or.ke • Password protected portal for system update www.ehealth.or.ke/facilitylogin
Process and progress in developing MFL-WA Stakeholder Meeting January 2009 To agree on scope and process of MFL HIS and MFL-TWG Meetings in 2009 Definitions Process Merged KEMRI GeoCodes July 09 6766 Feb 2010 Work with Divisions, Departments, Partners Dec 09 – March 2010 6696 Dec 09 6388 June 09 5730 Feb 09 4543 Jan 09 HIS and MFL-GIS TWG October 2009 Checklist, New Services, “Yellow Book” Sub-Location Exercise to get GeoCodes to 93% Jan 2010 Public Website Mar 10 Login Website May 10 Purchase GPS units for each DHRIO, and GPS Manual Training May 2010
How MFL promotes integration National Data Repository. MFL-WA
How MFL addresses HIS Sustainability • Database update done at district level. • Capacity building at district, provincial and national levels • Public access portal create demand for updated facility data. • Linkage to other databases support continuous reconciliation of existing facilities. • Practical solution to need keeping of duplicate lists, thus creating efficiency. • Creates data demand through integration – National Health data bank
How MFL promotes ownership • District driven • Support structures are at all levels. • Public Portal allows everyone to use database. • Tool for integration thus supporting data sharing and programs do not have to ‘give up’ their data. • Integration promotes data utilization – ‘I got this from the MFL’
Next Steps • Software Upgrade and Debugging. • Training HIS national staff on the system administration and Help desk. • Working on linkage with other databases. • Working with the regulatory bodies and councils on the regulatory module. • Working with other stakeholders in validation and collection of geo-codes. • Planning for a national launch
What’s the future with MFL? National MOH and Authorized Partners INTERNET Provincial and District Health Management Teams