dhis2-users team mailing list archive

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

Hi Lars,

Thanks for your thoughtful suggestions.  I'll check to see how many partners there are to see how feasible this option is.  There are many advantages to using the aggregate data modules, so I hope it works.

Randy

From: Lars Helge Øverland [mailto:larshelge@xxxxxxxxx]
Sent: Thursday, March 28, 2013 7:51 PM
To: Wilson,Randy
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] Any suggestions for partner reporting in DHIS-2?

Hi Randy,

on this issue there are lots of opinions - my recommendation would be to stick to the aggregate part of the system and leave out the individual records module. This is routine data captured at a fixed interval so capturing it as events might become messy over time.

My suggestion on how to solve this would be to use categories - you could:

- set up a category and category combination called "Partners".
- category options for each partner like "FHI" and "ACCESS".
- create data elements for each service and assign them to the partner category combination.
- create one data set per partner (e.g. "HIV counselling FHI").
- for each data set you create a custom form, and insert the data element + category option combinations for input fields accordingly.
- you create user roles for each partner.
- you assign the partner data sets to the corresponding partner user roles.
- you assign users for each partner to the corresponding user roles.
- you assign data sets (for partners) to facilities according to where the partners operate.

The partners can then select their data set when entering data, without having to worry about "who they are". There are no extra org units to maintain and the partners cannot mix up data sets when entering data.

One drawback is that you have to create those extra custom forms, but since you have a "very simple list of services" this might be affordable.

regards,

Lars





On Tue, Mar 26, 2013 at 1:02 PM, Wilson,Randy <rwilson@xxxxxxx<mailto:rwilson@xxxxxxx>> wrote:
Hi all,

Our HIV team works with civil society organizations and local partners to track a very simple list of services provided to persons living with HIV/Aids.

The data elements themselves are all numeric so it would be easy to do in a regular data set, except that partners don't fit well in the reporting hierarchy which goes from Province -> district -> sub-district -> sector -> health facility.

Data entered are total numbers per district per partner.

For example, a partner (FHI) might work in several districts, so there would be more than one FHI report for a given period.

District

Partner

Period

Dataelement

Datavalue

Rwamagana

FHI

Feb-13

# of PLWHA mutuelle payments made

12

Gicumbi

FHI

Feb-13

# of PLWHA mutuelle payments made

30

Huye

ACCESS

Feb-13

# of PLWHA mutuelle payments made

44

Gicumbi

ACCESS

Feb-13

# of PLWHA mutuelle payments made

23


I've thought of creating a separate partner's table and entering a partner numeric code as one of the fields that could called up in a special report, but referential integrity rules won't let me enter more than one data value record per period per district.

We can create the report using the Single Event Without Registration feature in Individual Records, using an Option set to maintain the list of partners, but unfortunately we can't seem to use any of this data in the dashboard, data visualizer, maps or standard reports.

If Single Event Without Registration is the only way to enter the data, would it not be possible to expose the dataelements for use with the standard reporting tools?

I remember Jason had to develop this sort of relationship for some work he did in Zambia but I'm not sure if it is documented somewhere.

Thanks,

Randy


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp