dhis2-users team mailing list archive

["Friedman, Roger (CDC/CCID/NCHHSTP) (CTR)" <rdf4@xxxxxxx>]

All of this is extremely unclear, it would be nice if there were a data model on the site somewhere.

But more importantly, what are group sets and compulsory group sets, what is their purpose?  The most I can find is the user manual sec. 4.2.2.11-14.  

 

I have created my OrgUnit table with a series of SQL statements like the following:

INSERT INTO Source (SourceID) VALUES (3);

INSERT INTO OrganisationUnit (OrganisationUnitID,UUID,Name,ParentID,ShortName,Type,GeoCode,LastUpdated)

  VALUES(3,uuid(),"Ghana",NULL,"Ghana","Country","GHA",'2010-03-03 18:23:49');

INSERT INTO Source (SourceID) VALUES (14);

INSERT INTO OrganisationUnit (OrganisationUnitID,UUID,Name,ParentID,ShortName,Type,GeoCode,LastUpdated)

  VALUES(14,uuid(),"Ashanti",3,"Ashanti","Region","GHA001",'2010-03-03 18:23:49');

INSERT INTO Source (SourceID) VALUES (90);

INSERT INTO OrganisationUnit (OrganisationUnitID,UUID,Name,ParentID,ShortName,Type,GeoCode,LastUpdated)

  VALUES(90,uuid(),"Kumasi",14,"Kumasi","District","GHA001014",'2010-03-03 18:23:49');

INSERT INTO Source (SourceID) VALUES (226);

INSERT INTO OrganisationUnit (OrganisationUnitID,UUID,Name,ParentID,ShortName,Type,GeoCode,LastUpdated)

  VALUES(226,uuid(),"Adum",90,"Adum","Sub-District","GHA001014010",'2010-03-03 18:23:49');

INSERT INTO Source (SourceID) VALUES (327);

INSERT INTO OrganisationUnit (OrganisationUnitID,UUID,Name,ParentID,ShortName,Type,GeoCode,LastUpdated)

  VALUES(327,uuid(),"Rabito Clinic",226,"Rabito Clinic","Clinic","GHA001014010",'2010-03-03 18:23:49');

 

So I could easily have Type as a compulsory group, as suggested in the documentation.  But what table do I have to modify to reflect this?  And does this mean that if I add other (compulsory) groups, the structure of the OrgUnit table will change?  

 

Into what table and how do I insert hierarchy names (region, district)?  What do I do about incomplete or unbalanced hierarchies -- district hospitals may be considered as belonging to the district rather than the sub-district in which they are located, there is an intermediate structure called a metropolitan government which exists only in large urban areas. 

 

Are there other tasks that need to be done to get OrgUnits completely in?  Any tricks or gotchas (like Source and ShortName)?

 

Thanks, Roger

 

From: dhis2-users-bounces+rdf4=cdc.gov@xxxxxxxxxxxxxxxxxxx [mailto:dhis2-users-bounces+rdf4=cdc.gov@xxxxxxxxxxxxxxxxxxx] On Behalf Of Lars Helge Øverland
Sent: Thursday, March 04, 2010 8:17 AM
To: Ignac Mare
Cc: DHIS 2.0 Users
Subject: Re: [Dhis2-users] Orgunit

 

 

On Sat, Feb 27, 2010 at 3:55 PM, Ignac Mare <ignac.mare@xxxxxxxxx> wrote:

On adding orgunits there is a block that says type what exactly can any one help

 

Hi,

 

the system requires one to add newly created organisation units to groups for all compulsory group sets. The system comes with three group sets pre-configured. You will need to create a few groups for each group set, and then choose one of these when creating a new organisation unit.

 

regards, Lars

 

 

 

 

 

 

	-- 
	I Mare
	Information Management
	Limpopo Emergency Medical Services
	Cell: 083 635 0605
	Fax: 086 614 2028
	Skype ignac.mare
	
	
	_______________________________________________
	Mailing list: https://launchpad.net/~dhis2-users
	Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
	Unsubscribe : https://launchpad.net/~dhis2-users
	More help   : https://help.launchpad.net/ListHelp