Morning Charlotte,
As part of the WEE research project [https://www.publishwhatyoufund.org/projects/womens-economic-empowerment/] Publish What You Fund looked at combining CRS & IATI data in order to get a comprehensive picture of funds across several countries. In order to do this, we compared the data fields available across each. We found that there are many more fields in the IATI data, therefore the best approach was to start with the CRS fields and find the IATI data which matched. As I am sure you are aware, you can find a description of the CRS fields here: [https://www.oecd.org/dac/financing-sustainable-development/development-…].

The other consideration is how you download your IATI, as not all download tools provide all IATI elements. We used the Country Development Finance tool [https://countrydata.iatistandard.org/methodology/] but there are other tools available which produce different/more fields. You can find an overview of the matching data fields we found in Annex 2 of our data collection methodology [https://www.publishwhatyoufund.org//app/uploads/dlm_uploads/2022/07/WEE…]. We have also written several blogs on our approach here [https://www.publishwhatyoufund.org/2022/08/a-methodology-for-merging-ia…] and here [https://www.publishwhatyoufund.org/2021/11/who-funds-womens-economic-em…].
It has to be noted that since we made our initial download using the CDFT tool in 2022 additional data fields which the CDFT tool outputs have been added, so this Annex is not completely up to date. Most prominently, you can now find the Aid Type field in the data provided by the CDFT.

Hi Charlotte Francke

It's over ten years old, but in the early days of IATI my colleague David wrote some mappings to convert some CRS publications to the IATI format. The code, and sample files, are all still there: https://github.com/caprenter/CRS-to-IATI

This might not be relevant. but it was at least nice to see it still there!

Thanks

Dear Elma Jenkins , dear Steven Flower , many thanks for the helpful hints and links. We hadn't considered the Country Development Finance tool as a source previously but I agree that it might be challenging that not all IATI-elements are downlodable there. We will definitely re-evaluate the WEE project, including the Annex you mention. We were also unaware of the GitHub repository and will look into it! I am quite curious.
Greetings!

Hi Charlotte Francke ,

When we worked on our IATI publication in the ILO we found this table (https://iatistandard.org/en/iati-standard/202/activity-standard/summary…) the most helpful for the overview of all possible data items in IATI.

Best regards,
Evgenia

Many thanks to you as well Evgenia Tyurina ! Yes indeed, what we are looking for is something like this summary table, with a further column showing the equivalent CRS-data field.

Best wishes,
Charlotte

Hi Charlotte,
The UN CEB Secretariat has worked on two initiatives that involved mapping of UN data elements between the UN data standards / UN-CEB minimum data set and the corresponding elements in IATI and OECD-CRS.

First, we mapped and harmonised code lists between the UN data standards (https://unsceb.org/sites/default/files/2022-03/UN_DataStandards_Digital…) and additional elements included in the UN-CEB minimum data set, with those of IATI and OECD-CRS.

Second, we are currently finalising an Excel version of the harmonised code lists, which will be published on the unsceb.org website in the coming weeks. I will share the link once finalised.

All the best. Henriette

Hi Henriette,
many thanks for your post! It sounds very interesting and aligns with the direction we were considering. We would greatly appreciate it if you could share the link here since we are definitely interested in taking a look at the Excel you mention.
All the best from Bonn,
Charlotte

Hi Charlotte,
The 2023 version of the code lists for UN system-wide financial reporting is now available at (scroll to bottom of the page): https://unsceb.org/data-standards-united-nations-system-wide-reporting-…. And, if you have questions: I will be Copenhagen later this week.
All the best.
Henriette

Hi Henriette,
many thanks this is very interesting!
Although I will not be at the MA / Community Exchange, my colleague Melina Löwer from GIZ will be there, as well as our colleagues from BMZ, Katharina von Falkenhayn, Sarah Neumann and Isgard Peter.
Best wishes,
Charlotte