Hierarchy options

Support - Assistance technique
1

Are the hierarchy options limited to 5? This is what we need:

national
regional
provincial
district (or more popularly known as inter-local health zones or ILHZs)
municipal
facility
village

Also, there are peculiarities with politics in the Philippines where we also visualize data by political congressional districts (a collection of municipalities at the same level as ILHzs but a completely different set of municipalities).

help!

···

–
Alvin B. Marcelo, MD, FPCS www.alvinmarcelo.com
Voicemail: +1-301-534-0795) GPG 0x99CBC54C

Click here for the Master of Science in Health Informatics

2

In Kenya the existing hierarchy are:-

National
Province

County
district
facility
Community unit

···

On Sun, Oct 9, 2011 at 7:03 PM, Alvin Marcelo alvin.marcelo@gmail.com wrote:

Click here for the Master of Science in Health Informatics

Are the hierarchy options limited to 5? This is what we need:

national
regional
provincial
district (or more popularly known as inter-local health zones or ILHZs)

municipal
facility
village

Also, there are peculiarities with politics in the Philippines where we also visualize data by political congressional districts (a collection of municipalities at the same level as ILHzs but a completely different set of municipalities).

help!

–
Alvin B. Marcelo, MD, FPCS www.alvinmarcelo.com
Voicemail: +1-301-534-0795) GPG 0x99CBC54C

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Samuel Cheburet
Ministry Of Health
P.O. Box 20781
Nairobi, Kenya
Mobile- 0721624338

Don’t Compromise The Quality! Don’t Risk It! apply Available Standards to Achieve Your/organizational Goal.

3

Hi Alvin,

there are no restrictions on the number of organisation unit levels. I
take it you are referring to the organisation unit level management
screen (1) - this is automatically generated based on the organisation
unit tree. If you add more organisation units and extend the number of
levels here, (1) will be updated automatically.

regards, Lars

(1) DHIS2 App Hub

4

Hi Alvin,

Also, there are peculiarities with politics in the Philippines where we also
visualize data by political congressional districts (a collection of
municipalities at the same level as ILHzs but a completely different set of
municipalities).

This is indeed a more interesting question.

I would be tempted to say to setup an entirely separate instance of
DHIS2, which you fed data to, and then reaggregated from village level
to political congressional districts. Alternatively, you could attempt
to use organisational unit group sets to try and do this, but you
would not be able to visualize the data inside DHIS2. You could do the
aggregation with the help of the orgunit group sets but would need to
pull into into some GIS program into order to produce the maps.

Would be interested to hear what others feel would be a reasonable
approach to this issue of a parallel geographical hierarchy, as it is
not the first time it has come up.

Regards,
Jason

5

Hi Alvin,

Also, there are peculiarities with politics in the Philippines where we also
visualize data by political congressional districts (a collection of
municipalities at the same level as ILHzs but a completely different set of
municipalities).

This is indeed a more interesting question.

Yes, and not uncommon. I think Botswana had health districts and election districts, not corresponding to each other. In Sierra Leone they have districts, divided into chiefdoms. Then they have something of a more political role, called local councils, which is a collection of chiefdoms not necessarily corresponding to a full district. For instance, the biggest cities have their own local councils, while some smaller districts only have one local council for the whole district. The local council has been implemented as an orgunit group, so it's possible to sort and filter facility data by these local councils. As Jason points out, you would need to work a bit to see this data. In Sierra Leone we use pivot tables, from where we can make charts etc. by local council.

Johan

···

On 10.10.2011 20:40, Jason Pickering wrote:

I would be tempted to say to setup an entirely separate instance of
DHIS2, which you fed data to, and then reaggregated from village level
to political congressional districts. Alternatively, you could attempt
to use organisational unit group sets to try and do this, but you
would not be able to visualize the data inside DHIS2. You could do the
aggregation with the help of the orgunit group sets but would need to
pull into into some GIS program into order to produce the maps.

Would be interested to hear what others feel would be a reasonable
approach to this issue of a parallel geographical hierarchy, as it is
not the first time it has come up.

Regards,
Jason

_______________________________________________
Mailing list: DHIS 2 Users in Launchpad
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : DHIS 2 Users in Launchpad
More help : https://help.launchpad.net/ListHelp

6

Jason is right that we cannot do analysis on org unit group sets
directly in DHIS at the moment. However, you can do so with excel
pivot tables and the mydatamart tool, and org unit group set analysis
is on the road map for version 2.6.

Lars

7

And when we have a datamart with data values aggregated by orgunit groups that represent a geographical area (e.g. local council in the case of Sierra Leone), the next step (and more challenging I assume) will be to display these values on “orgunit group polygons” on the map somehow… If we want to go there at all…

Ola

···

2011/10/11 Lars Helge Øverland larshelge@gmail.com

Jason is right that we cannot do analysis on org unit group sets

directly in DHIS at the moment. However, you can do so with excel

pivot tables and the mydatamart tool, and org unit group set analysis

is on the road map for version 2.6.

http://dhis2.org/downloads#mydatamart

http://dhis2.org/roadmap

Lars

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

8

Here is my strategy:

since the smallest org units are the municipalities (shared by the larger inter-local health zones and congressional districts) – can I simply extract the org units, process them with a separate application and display them as one of the graphs in DHIS2? This may require some programming of the dashboard…

···

2011/10/11 Ola Hodne Titlestad olati@ifi.uio.no

2011/10/11 Lars Helge Øverland larshelge@gmail.com

Jason is right that we cannot do analysis on org unit group sets

directly in DHIS at the moment. However, you can do so with excel

pivot tables and the mydatamart tool, and org unit group set analysis

is on the road map for version 2.6.

And when we have a datamart with data values aggregated by orgunit groups that represent a geographical area (e.g. local council in the case of Sierra Leone), the next step (and more challenging I assume) will be to display these values on “orgunit group polygons” on the map somehow… If we want to go there at all…

Ola

http://dhis2.org/downloads#mydatamart

http://dhis2.org/roadmap

Lars

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Alvin B. Marcelo, MD, FPCS www.alvinmarcelo.com
Voicemail: +1-301-534-0795) GPG 0x99CBC54C
Click here for the Master of Science in Health Informatics

9

Dear DHIS Users,

Is Data completeness report options working properly? this is an important feature!

But in Data completeness, when you select the option that says "
Based on number of registered data values " and you select all other option and press get report. The result does not correspond the fields. For example : Target does not correspont to the Actual column. which shows differences between Actual column and Target column(even this keeps happening after filling these fields. where Target > Actual).

Data Completeness Report

-  [GATSIBO](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KAYONZA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KIREHE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NGOMA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NYAGATARE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [RWAMAGANA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)

Data Completeness Report

Gashora CS Family Planning

Name
Actual
Target
Percent
On time
Percent
Gashora CS
6
63
9.5
6
9.5

···

Muhire Andrew

HMIS/Ministry of Health

God is my provider.

10

just to ask, are you using the custom data entry form or default? and how many fields do appear on the form when you are doing data entry?

my point is if you are using the custom data entry forms, and the number of fields appearing on data entry are six (in case the report underneath means actual is all the the fields ) then that might mean there are some data element assigned to that dataset and have not been assign to data entry form. though this will be completely different if you are using default form.

cheers

···

On Dec 15, 2011, at 1:14 PM, Muhire Andrew wrote:

Dear DHIS Users,

Is Data completeness report options working properly? this is an important feature!

But in Data completeness, when you select the option that says " Based on number of registered data values " and you select all other option and press get report. The result does not correspond the fields. For example : Target does not correspont to the Actual column. which shows differences between Actual column and Target column(even this keeps happening after filling these fields. where Target > Actual).

Data Completeness Report

-  [GATSIBO](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KAYONZA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KIREHE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NGOMA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NYAGATARE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [RWAMAGANA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)

Data Completeness Report

Gashora CS Family Planning

Name
Actual
Target
Percent
On time
Percent
Gashora CS
6
63
9.5
6
9.5

Muhire Andrew

HMIS/Ministry of Health

God is my provider.

Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

11

Great!

Thanks Yusuph, surely this may be the cause.let me check my datasets how i assigned data element.

We are using custom forms.

···

Muhire Andrew

  • HMIS/Ministry of Health*

God is my provider.

From: Yusuph Kulindwa yusuphk@gmail.com
To: Muhire Andrew muhireandrew@yahoo.com
Cc:
“dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net
Sent: Thursday, December 15, 2011 1:41 PM
Subject: Re: [Dhis2-users] Data completeness report

just to ask, are you using the custom data entry form or default? and how many fields do appear on the form when you are doing data entry?

my point is if you are using the custom data entry forms, and the number of fields appearing on data entry are six (in case the report underneath means actual is all the the fields ) then that might mean there are some data element assigned to that dataset and have not been assign to data entry form. though this will be completely different if you are using default form.

cheers
On Dec 15, 2011, at 1:14 PM, Muhire Andrew wrote:

Dear DHIS Users,

Is Data completeness report options working properly? this is an important feature!

But in Data completeness, when you select the option that says "
Based on number of registered data values " and you select all other option and press get report. The result does not correspond the fields. For example : Target does not correspont to the Actual column. which shows differences between Actual column and Target column(even this keeps happening after filling these fields. where Target > Actual).

Data Completeness Report

-  [GATSIBO](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KAYONZA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KIREHE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NGOMA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NYAGATARE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [RWAMAGANA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)

Data Completeness Report

Gashora CS Family Planning

Name
Actual
Target
Percent
On time
Percent
Gashora CS
6
63
9.5
6
9.5

Muhire Andrew

HMIS/Ministry of Health

God is my provider.

Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

12

Thanks for sharing’

Always, targets >= than Actual

Every data values is a count which adds up to maximum value 100%

Completeness based on data sets are based on the forms

Completeness based on compulsory data elements are the data entries which must be filled

completeness based on number of registered data values are every cell is account and if possible must be filled for you to get 100%. Therefore if the form is filled and you have not selected complete, then you are likely not see what you’ve filled.

Recommend that national level should concentrate more to check ** Completeness based on data sets based on the forms that will be more accurate than data values.**

Regards

PEPELA WANJALA

MINISTRY OF HEALTH HEADQUARTERS

HEALTH INFORMATION SYSTEM

AFYA HOUSE, HIS LG 37

P.O BOX 30016, NAIROBI, KENYA

TEL: +254 (020) 2717077 EXT 45097

CELL: +254 (0) 722375633 or 0202033363

EMAIL: wanjala2p@yahoo.com

** hmis@health.go.ke**

* *"HealthInformation Management - Making a World of Difference”

···

From: Muhire Andrew muhireandrew@yahoo.com
To: “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net
Sent: Thursday, December 15, 2011 1:14 PM
Subject: [Dhis2-users] Data completeness report

Dear DHIS Users,

Is Data completeness report options working properly? this is an important feature!

But in Data completeness, when you select the option that says "
Based on number of registered data values " and you select all other option and press get report. The result does not correspond the fields. For example : Target does not correspont to the Actual column. which shows differences between Actual column and Target column(even this keeps happening after filling these fields. where Target > Actual).

Data Completeness Report

-  [GATSIBO](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KAYONZA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KIREHE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NGOMA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NYAGATARE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [RWAMAGANA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)

Data Completeness Report

Gashora CS Family Planning

Name
Actual
Target
Percent
On time
Percent
Gashora CS
6
63
9.5
6
9.5

Muhire Andrew

HMIS/Ministry of Health

God is my provider.

Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

13

Thanks Wanjala, You are right.I have even checked. you are right.

···

Muhire Andrew

HMIS/Ministry of Health

God is my provider.

From: wanjala pepela wanjala2p@yahoo.com
To: Muhire Andrew muhireandrew@yahoo.com; “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net
Sent: Thursday, December 15, 2011 2:46 PM
Subject: Re: [Dhis2-users] Data completeness report

Thanks for sharing’

Always, targets >= than Actual

Every data values is a count which adds up to maximum value 100%

Completeness based on data sets are based on the forms

Completeness based on compulsory data elements are the data entries which must be filled

completeness based on number of registered data values are every cell is account and if possible must be filled for you to get 100%. Therefore if the form is filled and you have not selected complete, then you are likely not see what you’ve filled.

Recommend that national level should concentrate more to check ** Completeness based on data sets based on the forms that will be more accurate than data
values.**

Regards

PEPELA WANJALA

MINISTRY OF HEALTH HEADQUARTERS

HEALTH INFORMATION SYSTEM

AFYA HOUSE, HIS LG 37

P.O BOX 30016, NAIROBI, KENYA

TEL: +254 (020) 2717077 EXT 45097

CELL: +254 (0) 722375633 or 0202033363

EMAIL: wanjala2p@yahoo.com

** hmis@health.go.ke**

* *"HealthInformation Management - Making a World of Difference”

From: Muhire Andrew muhireandrew@yahoo.com
To: “dhis2-users@lists.launchpad.net” dhis2-users@lists.launchpad.net
Sent: Thursday, December 15, 2011
1:14 PM
Subject: [Dhis2-users] Data completeness report

Dear DHIS Users,

Is Data completeness report options working properly? this is an important feature!

But in Data completeness, when you select the option that says "
Based on number of registered data values " and you select all other option and press get report. The result does not correspond the fields. For example : Target does not correspont to the Actual column. which shows differences between Actual column and Target column(even this keeps happening after filling these fields. where Target > Actual).

Data Completeness Report

-  [GATSIBO](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KAYONZA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KIREHE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NGOMA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NYAGATARE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [RWAMAGANA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)

Data Completeness Report

Gashora CS Family Planning

Name
Actual
Target
Percent
On time
Percent
Gashora CS
6
63
9.5
6
9.5

Muhire Andrew

HMIS/Ministry of Health

God is my provider.

Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

14

Thanks everyone.
What require to be change in the system is Based on number of registered data values :-

  1. Actual= Total facilities/communities reported/entered into the system
  2. Target = Expected health facilities/communities to report
  3. 1st percentage = % complete reporting
  4. on-time = Total facilities/communities entered on time
  5. 2nd percentage = % timely entered reports
    Regards

When using

···

On Thu, Dec 15, 2011 at 1:14 PM, Muhire Andrew muhireandrew@yahoo.com wrote:

Dear DHIS Users,

Is Data completeness report options working properly? this is an important feature!

But in Data completeness, when you select the option that says " Based on number of registered data values " and you select all other option and press get report. The result does not correspond the fields. For example : Target does not correspont to the Actual column. which shows differences between Actual column and Target column(even this keeps happening after filling these fields. where Target > Actual).

Data Completeness Report

-  [GATSIBO](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KAYONZA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [KIREHE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NGOMA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [NYAGATARE](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)
-  [RWAMAGANA](http://localhost:8088/dhis/dhis-web-reporting/displayViewDataCompletenessForm.action)

Data Completeness Report

Gashora CS Family Planning

Name
Actual
Target
Percent
On time
Percent
Gashora CS
6
63
9.5
6
9.5

*Muhire Andrew

HMIS/Ministry of Health

God is my provider.

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

–
Samuel Cheburet
Ministry Of Health
P.O. Box 20781
Nairobi, Kenya
Mobile- 0721624338
“When you cease to dream you cease to live, Neither you nor the world knows what you can do until you have tried”.

*“Chance favours the prepared mind” -Louis Pasteur