dhis2-devs team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

Hi Ola,

I am sitting here with Knut, and I am going to support him on this
one. :) The actual "real" relationship should be as Knut states. There
are many Pickens Counties in the USA, but only one in Georgia (my home
town).

The prefix method has been implemented in Zambia, but I would regard
this as very messy as well, particularly since it does not actually
reflect the actual name of the orgunit. I would really regard this
more of a kludge than anything else. In the reports that I have
created in Zambia, we have trimmed out the two characters, as they
make the reports messy.



> Orgunit hierarchy is not referenced from the data values so the
> proposed change would easily cause problems when dealing with the data.
>

What does this mean? Every value is referenced to an orgunitid ?

In my opinion, we should try and model the actual physical world.
Generally, there are never duplicates of an orgunit within a
particular parent. There are Oslo's in both Norway and Peru, but they
are unique within their own hierarchy. The constraint should be that
for any given parentid, the names of orgunits should be unique. I am
not sure why this will result in a messy database, but at the present,
the database and its constraints simply do not reflect reality.

Regards,
Jason