dhis2-users team mailing list archive

["Wilson,Randy" <rwilson@xxxxxxx>]

Hi Riddy,

There are a couple of steps to this process depending upon the data you have available and the approach that you use for calculating the different denominators.


1.       Decide whether you will only store total catchment population for each facility and then use national level percentages to calculate specific service target populations.  For example in Rwanda we multiply total population by 4.1% to estimate the expected pregnancies and 23.6% to estimate the women of reproductive age, etc...  If this approach works for you then you only need to create a single data element "Population" and the rest of the target populations can be calculated as indicators.  You can also use the 'Constants' feature in data administration to define these percentages so that you can change them easily.

2.       Normally the facility target populations don't add up to 100% of the national population, so you will probably want to add official census projected populations at the lowest level that they are available.  Note for your data element you should define 2 aggregation levels for Population.  In our case they are Facility and Sector.  All of the higher levels are automatically aggregated.

3.       If you have the estimated target populations for each facility in a spreadsheet, you can import them into the datavalue table (normally you import one record per year per facility so make sure you get the periodid, dataelementid, and sourceid=organisationunitid fields correct) before appending them.

4.       If you don't have all of the data and you want users to enter the populations, create a dataset called population with a periodicity of Yearly and assign it to all health facilities.  You can even create some indicators for each of your main target groups that are used in your indicator populations (Children <1 year, Expected Pregnancies, Children <5 years, Women of reproductive age 15-49, etc...) and include them in the dataset so that people can see the estimated sub-populations like the example below.  This is useful with the pivot tables, as you can extract data element totals along with desired sub-population when calculating coverage rates.
[cid:image002.jpg@01CEAE4F.5CEC1BF0]


5.       Each year, ask health facility staff to update their populations through the dataset, or insert new records using the projected growth rate (I did both: asked facilities to update them first, then incremented any missing values using previous year's data.)

Good luck,

Randy

From: Dhis2-users [mailto:dhis2-users-bounces+rwilson=msh.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of riddy ndoma
Sent: Tuesday, September 10, 2013 4:37 PM
To: dhis1-users
Subject: [Dhis2-users] How to insert the populations health facility

How to insert the populations health facility ... as many of our indicators as the denominator population health facility

--
Riddy NDOMA
Software Developer
Skype: riddyndoma, G+: riddyndoma, FB: riddy ndoma
Twitter: riddyndoma, LinkedIn: riddy ndoma
Blog: http://riddyndoma.blogspot.com/
Vous servir est mon désire (Serving you is my desire)