dhis2-devs team mailing list archive

[John Ojo <jnojo@xxxxxxxxx>]

Hi All,

I am designing a database for an organization that works with multiple local NGOs (14 NGOs in all) as the Implementing Partners (IPs) for the said organization.

There are 40 districts in all. For the sake of this description, I will name the districts as district_1, district_2, district_3, and so on. and the IPs as IP1, IP2, IP3, and so on.
Each of the IPs works in multiple districts; for example IP1 and IP2 each works in all the 40 districts. 

Each IP specializes in one program area. For example, IP1 does only HIV/AIDS while IP2 focuses on Gender & Human Rights.
The organization needs to be able to know the results of each IP from each district every month.

I am therefore planning to set up the organisation unit names in the DHIS 2 database as follows:
For IP1 and IP2, I'm considering the following orgUnit names:

District_1
  IP1_d1
  IP2_d1
 
District_2
  IP1_d2 
  IP2_d2
 


District_3
  IP1_d3 
  IP2_d3
.

.
.

District_40
  IP1_d40 
  IP2_d40


I would appreciate suggestions on how to handle this piece, especially if there's a better way than this approach and would also like to hear from anyone who had had to deal with this type of situation and how they handled the orgUnit names.

Thank you so much.


John

John Ojo MD, FMCPH

Accra, Ghana.

Mobile: +233 234691626+233 234691626
Skype:  Johnojo
Email: jnojo@xxxxxxxxx