Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Regards
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Prosper,
HISP-SA is working on a few related issues:
Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators.
Validity periods for indicators
Validity periods for validation rules.
See relevant blueprints
I’m not sure if your issue is different - can you specify what you mean by “previous rates” in this context?
regards
calle
On 1 April 2015 at 10:46, Prosper BT ptb3000@gmail.com wrote:
Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Regards
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Sorry Calle,
Wrote the mail in a rush and complicated the problem statement.
New Orgunits are always added to DHIS2, and for a district which had say 20 facilities in Jan 2014 and all completed for a given data set (20/20 - 100% reporting rate by completeness)
Jan 2015, a new Orgunit was been added with that dataset, when users run their previous reporting rate summary - before its addition, it will reflect 20/21 including the new facility which was not open by then.
So most user want the previous reporting rates to remain 20/20 not now 20/21
Regards
On Wed, Apr 1, 2015 at 12:02 PM, Calle Hedberg calle.hedberg@gmail.com wrote:
Prosper,
HISP-SA is working on a few related issues:
- Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators.
- Validity periods for indicators
- Validity periods for validation rules.
See relevant blueprints
I’m not sure if your issue is different - can you specify what you mean by “previous rates” in this context?
regards
calle
–
On 1 April 2015 at 10:46, Prosper BT ptb3000@gmail.com wrote:
Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Regards
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
This is really a quite intricate problem, if it is going to be done right. The easy “fix” would be to ignore whether a facility contrinbutes to completeness rates if the opening and closed dates are not valid. In practice however, it is more complicated than that, because a facility may only report a data set for a few months, or be open only parts of the year (I have seen this in two countries now, where certain facilities are always closed during certain months, i.e. the Himalayan winter and tropical rainy season). So, how would we account for this? The opening and closed dates really have no meaning in this case, because it is only open sometimes, and thus, is not expected to submit a repo
So, although it might fix the problem of adding new facilities and closing existing ones, I am not really so sure it would really solve the actual problem.
Regards,
Jason
On Wed, Apr 1, 2015 at 11:02 AM, Calle Hedberg calle.hedberg@gmail.com wrote:
Prosper,
HISP-SA is working on a few related issues:
- Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators.
- Validity periods for indicators
- Validity periods for validation rules.
See relevant blueprints
I’m not sure if your issue is different - can you specify what you mean by “previous rates” in this context?
regards
calle
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
On 1 April 2015 at 10:46, Prosper BT ptb3000@gmail.com wrote:
Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Regards
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
Thanks Jason,
I know its complicated and very difficult to implement but in traditional national system focusing on reporting rates, it has come to point where districts would rather not add an Orgunit and if closed would want it deleted out of the systems or dataset removed.
May be Analytics should consider Opening data and closing date, so that new Orgunit are given a current opening date
Regards
On Wed, Apr 1, 2015 at 12:12 PM, Jason Pickering jason.p.pickering@gmail.com wrote:
This is really a quite intricate problem, if it is going to be done right. The easy “fix” would be to ignore whether a facility contrinbutes to completeness rates if the opening and closed dates are not valid. In practice however, it is more complicated than that, because a facility may only report a data set for a few months, or be open only parts of the year (I have seen this in two countries now, where certain facilities are always closed during certain months, i.e. the Himalayan winter and tropical rainy season). So, how would we account for this? The opening and closed dates really have no meaning in this case, because it is only open sometimes, and thus, is not expected to submit a repo
So, although it might fix the problem of adding new facilities and closing existing ones, I am not really so sure it would really solve the actual problem.
Regards,
Jason
–
On Wed, Apr 1, 2015 at 11:02 AM, Calle Hedberg calle.hedberg@gmail.com wrote:
Prosper,
HISP-SA is working on a few related issues:
- Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators.
- Validity periods for indicators
- Validity periods for validation rules.
See relevant blueprints
I’m not sure if your issue is different - can you specify what you mean by “previous rates” in this context?
regards
calle
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On 1 April 2015 at 10:46, Prosper BT ptb3000@gmail.com wrote:
Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Regards
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Yeah, I do not know really how complicated it would be to implement in DHIS2, but I do know we have performed this type of analysis in other places outside of DHIS2 with SQL and scripts. Basically, it would involve getting all of the opening and closed dates of the facilities, and then the completed data set registrations and performing a period by period type of analysis on the reporting rates, to provide a dynamic denominator (i.e. number of facilities which are supposed to report). However, in practice, what we saw was that the opening/closed dates were often not really that accurate, often leading to percentages over 100%, since the facility was supposedly closed, but still submitted a report.
I think if it is that big of a problem (sounds bad), you should to consider to implement a custom report which would take this into account, but maybe the developers could comment on how difficult this would be to implement.
Perhaps the bigger problem however is the focus on reporting compelteness, as opposed to what is actually in the data? :-/
Regards,
Jason
On Wed, Apr 1, 2015 at 11:25 AM, Prosper BT ptb3000@gmail.com wrote:
Thanks Jason,
I know its complicated and very difficult to implement but in traditional national system focusing on reporting rates, it has come to point where districts would rather not add an Orgunit and if closed would want it deleted out of the systems or dataset removed.
May be Analytics should consider Opening data and closing date, so that new Orgunit are given a current opening date
Regards
–
On Wed, Apr 1, 2015 at 12:12 PM, Jason Pickering jason.p.pickering@gmail.com wrote:
This is really a quite intricate problem, if it is going to be done right. The easy “fix” would be to ignore whether a facility contrinbutes to completeness rates if the opening and closed dates are not valid. In practice however, it is more complicated than that, because a facility may only report a data set for a few months, or be open only parts of the year (I have seen this in two countries now, where certain facilities are always closed during certain months, i.e. the Himalayan winter and tropical rainy season). So, how would we account for this? The opening and closed dates really have no meaning in this case, because it is only open sometimes, and thus, is not expected to submit a repo
So, although it might fix the problem of adding new facilities and closing existing ones, I am not really so sure it would really solve the actual problem.
Regards,
Jason
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
On Wed, Apr 1, 2015 at 11:02 AM, Calle Hedberg calle.hedberg@gmail.com wrote:
Prosper,
HISP-SA is working on a few related issues:
- Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators.
- Validity periods for indicators
- Validity periods for validation rules.
See relevant blueprints
I’m not sure if your issue is different - can you specify what you mean by “previous rates” in this context?
regards
calle
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On 1 April 2015 at 10:46, Prosper BT ptb3000@gmail.com wrote:
Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Regards
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
Hi,
The system should ONLY consider absolute (real) opening and closing dates, and should not accept any report for a reporting unit outside of this (what we generally call its “validity period”).
reporting units with irregular activities must be handled “manually” - there are basically two options:
You exclude certain types of typically irregular operations from your completeness analysis. Typical cases would be irregular mobile units.
You capture a null activity report for irregular ops when they are inactive (e.g. enter a zero for the headcount data element or similar). That null report will thus be part of your completeness rate.
Regards
Calle
On 1 April 2015 at 11:34, Jason Pickering jason.p.pickering@gmail.com wrote:
Yeah, I do not know really how complicated it would be to implement in DHIS2, but I do know we have performed this type of analysis in other places outside of DHIS2 with SQL and scripts. Basically, it would involve getting all of the opening and closed dates of the facilities, and then the completed data set registrations and performing a period by period type of analysis on the reporting rates, to provide a dynamic denominator (i.e. number of facilities which are supposed to report). However, in practice, what we saw was that the opening/closed dates were often not really that accurate, often leading to percentages over 100%, since the facility was supposedly closed, but still submitted a report.
I think if it is that big of a problem (sounds bad), you should to consider to implement a custom report which would take this into account, but maybe the developers could comment on how difficult this would be to implement.
Perhaps the bigger problem however is the focus on reporting compelteness, as opposed to what is actually in the data? :-/
Regards,
Jason
–
On Wed, Apr 1, 2015 at 11:25 AM, Prosper BT ptb3000@gmail.com wrote:
Thanks Jason,
I know its complicated and very difficult to implement but in traditional national system focusing on reporting rates, it has come to point where districts would rather not add an Orgunit and if closed would want it deleted out of the systems or dataset removed.
May be Analytics should consider Opening data and closing date, so that new Orgunit are given a current opening date
Regards
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On Wed, Apr 1, 2015 at 12:12 PM, Jason Pickering jason.p.pickering@gmail.com wrote:
This is really a quite intricate problem, if it is going to be done right. The easy “fix” would be to ignore whether a facility contrinbutes to completeness rates if the opening and closed dates are not valid. In practice however, it is more complicated than that, because a facility may only report a data set for a few months, or be open only parts of the year (I have seen this in two countries now, where certain facilities are always closed during certain months, i.e. the Himalayan winter and tropical rainy season). So, how would we account for this? The opening and closed dates really have no meaning in this case, because it is only open sometimes, and thus, is not expected to submit a repo
So, although it might fix the problem of adding new facilities and closing existing ones, I am not really so sure it would really solve the actual problem.
Regards,
Jason
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
On Wed, Apr 1, 2015 at 11:02 AM, Calle Hedberg calle.hedberg@gmail.com wrote:
Prosper,
HISP-SA is working on a few related issues:
- Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators.
- Validity periods for indicators
- Validity periods for validation rules.
See relevant blueprints
I’m not sure if your issue is different - can you specify what you mean by “previous rates” in this context?
regards
calle
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
On 1 April 2015 at 10:46, Prosper BT ptb3000@gmail.com wrote:
Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Regards
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Thanks Prosper for resuscitating this perennial issue.
The problem is real especially where you have a high turnover of health facilities ( mostly private health facilities) – and to complicated the problem, its is not only limited to “opening” and “closing” but also when health facilities move from one parent to another.
Calle, the idea of using a “null activity report” may work but the challenge is that most reporting rate calculations are based on complete dataset registrations which are removed from actual data value count. Using the option of “compulsory data elements” basis of completeness . However there are been many field challenges in defining these compulsory data elements.
Any great ideas to navigate this challenge will be great!
………………………………………
Regards,
Dapo Adejumo
+2348033683677
Skype : dapojorge
From: Dhis2-devs [mailto:dhis2-devs-bounces+dapo_adejumo=yahoo.com@lists.launchpad.net] On Behalf Of Calle Hedberg
Sent: 1 April, 2015 10:57 AM
To: Jason Pickering
Cc: Prosper BT; DHIS developers
Subject: Re: [Dhis2-devs] Added Orgunits/added datasets distorting old reporting rates
Hi,
The system should ONLY consider absolute (real) opening and closing dates, and should not accept any report for a reporting unit outside of this (what we generally call its “validity period”).
reporting units with irregular activities must be handled “manually” - there are basically two options:
You exclude certain types of typically irregular operations from your completeness analysis. Typical cases would be irregular mobile units.
You capture a null activity report for irregular ops when they are inactive (e.g. enter a zero for the headcount data element or similar). That null report will thus be part of your completeness rate.
Regards
Calle
On 1 April 2015 at 11:34, Jason Pickering jason.p.pickering@gmail.com wrote:
Yeah, I do not know really how complicated it would be to implement in DHIS2, but I do know we have performed this type of analysis in other places outside of DHIS2 with SQL and scripts. Basically, it would involve getting all of the opening and closed dates of the facilities, and then the completed data set registrations and performing a period by period type of analysis on the reporting rates, to provide a dynamic denominator (i.e. number of facilities which are supposed to report). However, in practice, what we saw was that the opening/closed dates were often not really that accurate, often leading to percentages over 100%, since the facility was supposedly closed, but still submitted a report.
I think if it is that big of a problem (sounds bad), you should to consider to implement a custom report which would take this into account, but maybe the developers could comment on how difficult this would be to implement.
Perhaps the bigger problem however is the focus on reporting compelteness, as opposed to what is actually in the data? :-/
Regards,
Jason
On Wed, Apr 1, 2015 at 11:25 AM, Prosper BT ptb3000@gmail.com wrote:
Thanks Jason,
I know its complicated and very difficult to implement but in traditional national system focusing on reporting rates, it has come to point where districts would rather not add an Orgunit and if closed would want it deleted out of the systems or dataset removed.
May be Analytics should consider Opening data and closing date, so that new Orgunit are given a current opening date
Regards
On Wed, Apr 1, 2015 at 12:12 PM, Jason Pickering jason.p.pickering@gmail.com wrote:
This is really a quite intricate problem, if it is going to be done right. The easy “fix” would be to ignore whether a facility contrinbutes to completeness rates if the opening and closed dates are not valid. In practice however, it is more complicated than that, because a facility may only report a data set for a few months, or be open only parts of the year (I have seen this in two countries now, where certain facilities are always closed during certain months, i.e. the Himalayan winter and tropical rainy season). So, how would we account for this? The opening and closed dates really have no meaning in this case, because it is only open sometimes, and thus, is not expected to submit a repo
So, although it might fix the problem of adding new facilities and closing existing ones, I am not really so sure it would really solve the actual problem.
Regards,
Jason
On Wed, Apr 1, 2015 at 11:02 AM, Calle Hedberg calle.hedberg@gmail.com wrote:
Prosper,
HISP-SA is working on a few related issues:
- Validity periods (open/closeddates) for orgunits used to ensure no data entry for closed OUs, no validation rule violations for closed OUs, closed OUs not included in OrgUnitGroup counts used in indicators.
- Validity periods for indicators
- Validity periods for validation rules.
See relevant blueprints
I’m not sure if your issue is different - can you specify what you mean by “previous rates” in this context?
regards
calle
On 1 April 2015 at 10:46, Prosper BT ptb3000@gmail.com wrote:
Hi Team,
Am not sure is am behind the decision of taking care of the challenge most districts are experiencing.
What has been the decision so far.
Once a dataset is added to a facility, it affects the previous rates regardless of the opening data.
Whats is the status of this issues
Regards
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
–
Prosper Behumbiize, MPH
Phone: +256 414 320076
Cell: +256 772 139037
+256 752 751776
–
Jason P. Pickering
email: jason.p.pickering@gmail.com
tel:+46764147049
–
Calle Hedberg
46D Alma Road, 7700 Rosebank, SOUTH AFRICA
Tel/fax (home): +27-21-685-6472
Cell: +27-82-853-5352
Iridium SatPhone: +8816-315-19274
Email: calle.hedberg@gmail.com
Skype: calle_hedberg