We have an example of an organisation where the percentage of funding going to each country has changed over the lifetime of the project. How would the organisation handle this in the data? How could you retain a historical reference in the data to the original set of countries so that you can see how the country focus has changed over time?

Any help appreciated - this is a live problem that we are trying to find a solution to!

Comments (5)

Wendy Rogers
Wendy Rogers

Would specifying the country at transaction rather than activity level help here SJohns ? That way any countries that become recipients at a later stage would only appear in the transaction at a later date in the project lifecycle?

SJohns
SJohns

Hi Wendy, this may be an option for some organisations. The additional challenge with the organisation I am working with is that it is subject to both MFA and DFID requirements, and these funders ask for countries to be recorded at activity level. The Standard doesn’t allow countries to be recorded at both activity and transaction level in the same activity. Any solution for this one?

Herman van Loon
Herman van Loon

I would suggest publishing the most recent country and region percentages available. It is up to the consumer of the IATI data to build an historical record of country and region percentages, if they are interested in these changes.

The alternative would be to extend the standard with a start and end date for the country and region percentages. This would introduce a lot of additional complexity though and I doubt the benefits would outweigh the costs.

Yohanna  Loucheur
Yohanna Loucheur

I agree with Herman. For what it’s worth, it’s the approach we take - update countries/regions (and sectors) in our system and IATI files as the project evolves. This can create discrepancies in our data, for instance between what was reported to the DAC at the beginning of the project and what’s in our current IATI files 2 or 3 years later, but that comes with the territory - IATI is meant to provide timely, up-to-date data, not a statistical record.

It’s an interesting question nevertheless. SJohns , are the organizations having problems in their reporting because of the changes, ie is anyone actually asking for the changes to be recorded?

I wonder is an easier solution would be to add an attribute to the country/region percentages indicating if they are modified. Data users for whom this is important could seek details from the publisher?

SJohns
SJohns

Thanks for the feedback - I think this is the approach I’ll suggest to the organisation I am working with. There’s no user need (in this instance) to show changes over time so it makes sense to follow this approach.


Please log in or sign up to comment.