On 10 August 2011 09:10, Jason Pickering <[email protected]> wrote: > In fact, it is possible to assign an orgunit to two separate members > of an orgunit group set. If you create a group set "Services" you can > add the facility to multiple groups, but only through the Organisation > unit group management function, and not through the UI for the > organisation unit itself.
Ah. That explains where these dodgy groupsets are coming from .... > > In this case, the "Services" groupset is not longer exclusive, meaning > that you might have a facility which belongs to both "DOTS" and "CS", > both of which belong to the "Services" group set. > > The problem comes about in how DHIS2 generates the resource tables. > DHIS2 only takes one entry, and not both, so even though I may have > assigned a given orgunit to both "DOTS" and "CS", in the resource > tables, only "DOTS" appears under the "services" column. > > This query will return a list of all groups a given orgunit belongs to > > SELECT a.organisationunitid, a.name,c.* from organisationunit a > INNER JOIN orgunitgroupmembers b on a.organisationunitid = > b.organisationunitid > INNER JOIN orgunitgroup c on b.orgunitgroupid = c.orgunitgroupid > > If you assign an orgunit to multiple groups, there will be multiple > rows in this view, which would need to be carefully handled when > performing analyses in PivotTables, asit will lead duplication unless > the orgunit group column is separated into multiple columns or > seperate views are created for each orgunit group prior to feeding the > data to a PivotTable. > > Regards, > Jason > > > On Wed, Aug 10, 2011 at 9:35 AM, samuel cheburet > <[email protected]> wrote: >> Thanks everyone for health discussion >> Dhis require upgrading to have service while registering new health facility >> using conventional naming. Regards >> >> regards >> >> On Wednesday, August 10, 2011, Shinichi Suzuki <[email protected]> wrote: >>> Hello Chet, >>> >>> I think Mr. Wanjala answered properly. >>> >>> Group capability in DHIS2 is not use for Service of Facility. >>> >>> I know one facility has several services. >>> >>> These services comes up as a dataset to be entered. >>> >>> So, we assign these datasets along with services of the facilities, >>> properly. >>> >>> Then we could get completeness report by dataset by organisation unit. >>> >>> Regards, >>> >>> Suzuki >>> >>> >>> >>> From: [email protected] >>> [mailto:dhis2-devs-bounces+shin461 <dhis2-devs-bounces%2Bshin461>[email protected]] >>> On Behalf Of Chet Chaulagai >>> Sent: Tuesday, August 09, 2011 11:56 PM >>> To: Brajesh Murari >>> Cc: [email protected] >>> Subject: Re: [Dhis2-devs] OrgUit groups and group sets >>> >>> >>> >>> Hi Brajesh, >>> Thank you very much for your clarification. As you said a health facility >>> can be a member of only one group, this is the main limitation of this >>> database. If I want to know the distribution of CS facilities or reporting >>> coverage of CS facility, I would like to have all facilities offering CS >>> services be grouped together. People interested in DOTS would like to do the >>> same. The problem comes when one facility is providing the both services. >>> You can place this facility either on DOTS or on CS category, not in both >>> categories. This is the issue we need to address. >>> Regards, >>> Chet >>> >>> On Tue, Aug 9, 2011 at 1:50 AM, Brajesh Murari <[email protected]> >>> wrote: >>> >>> Hi Chet, >>> >>> >>> >>> In DHIS2, user have extensive space to make several kind of orgunit groups >>> or more general we can say health facility groups by considering at least >>> one common attribute belongs to all facilities in that group, and criteria >>> for selection could be anything like type of services offered (Cesarean >>> Section Delivery, ORT, DOTS etc ) or geographical location or administrative >>> regions etc. More precisely we can say, a group set in DHIS2 is always >>> exclusive, which means that an orgunit (health facility) cannot be member of >>> more than one such group in a group set. If you try otherwise you will get >>> notified by the application and the action not allowed. It is possible to >>> define whether a group set is compulsory or not, which will affect the >>> completeness of the data when analyzing data using group sets. Compulsory >>> means that ALL orgunits (health facility) must be member of a group in that >>> group set. >>> >>> >>> >>> Regards, >>> >>> Brajesh >>> >>> >>> >>> On Mon, Aug 8, 2011 at 7:31 PM, wanjala pepela <[email protected]> >>> wrote: >>> >>> I think that a facility can have all of them as service areas with >>> different datasets which are well assigned in DHIS so long as the datasets >>> are put in DHIS. What the districts should do is to assign the different >>> services to their facilities and a facility will have offering CS, ORT, DOTs >>> and linked to also CUs . >>> >>> >>> >>> regards >>> >>> >>> >>> PEPELA WANJALA >> >> -- >> 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. >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> >> > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
