Integration of IATI Data into DAD-Rwanda: Challenges and Benefits
The Ministry of Finance and Economic Planning in Rwanda collaborated with Synergy International Systems to implement a data transfer web service from the IATI registry to DAD-Rwanda. The project involved customization of data merging workflows and deployment of an operational pilot module. The Data Import Service facilitates data migration between IATI and DAD, enhancing aid transparency and comparability at both global and country levels. Despite constraints in the IATI standard, the project aims to reduce manual data entry burdens and improve data quality for development partners in Rwanda.
Download Presentation
Please find below an Image/Link to download the presentation.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.
You are allowed to download the files provided on this website for personal or commercial use, subject to the condition that they are used lawfully. All files are the property of their respective owners.
The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author.
E N D
Presentation Transcript
DAD-Rwanda, IATI INTEGRATION Accra, Ghana. IATI Regional Workshop March ,2015 Marie-Ange INGABIRE External Finance Unit (EFU) Ministry of Finance and Economic Planning RWANDA
Main Topics Components of the IATI pilot: Data Import Service Data Import Service challenges and proposed solutions IATI Projects mapping and merging with DAD projects Integrating the DAD with the SmartIFMIS - challenges
Overview The Ministry of Finance and Economic Planning of the Government of Rwanda and Synergy International Systems signed a contract at the beginning of September, 2014 for: Implementation of Data Transfer Web Service (from IATI registry to DAD) and Data Conversion Interface (from IATI standard to DAD Rwanda template) Customization of Data Merging Workflow (between IATI Project Profile and live DAD Rwanda Project) Operational Pilot Module was deployed in the DAD-Rwanda in January 2015
Data Import Service The Data Import service is a flexible and robust data migration tool that allows data to be pulled from IATI to DAD. It provides a mechanism for identifying the data stored in IATI Repository and mapping them with the data in DAD Rwanda for data comparison and analysis.
Data Import Service : Expected Benefits Reduced burden of manual entry of the same data by development partners at the country level Improved comparability between global and country level data on aid for Rwanda Integration of the local system with the global aid transparency standard and being ahead of developments in this field 5
Data Import Service : Constraints of IATI Standard impacting the data import and expected benefits Required fields in DAD-Rwanda sometimes are not provided by the IATI donor publishers ex: the activity total budget, the start and end dates, etc. Some required values in the DAD are missing in IATI: ex: last-updated-date/time is set as an optional attribute, but it is used for identifying whether the activity (project) is updated in the IATI Repository or not since the last data import date. If this attribute is missing, then it makes it difficult to identify the last updated activities/projects. Lots of attributes from the IATI standard allows flexibility of specifying options/values and available IATI codelists are sometimes ignored by publishers. Ex : invalid date format AT THE END: From the IATI conversion log only 34 activities were successfully imported, the rest 2336 activities reported in IATI for Rwanda, failed the conversion. 6
Data Import Service : Proposed solutions To improve the % of successfully imported projects from IATI to the DAD system: Publishers should implement the version 2.01of the IATI schema and improve the quality and timeliness of the data We have lowered our conversion/ mapping requirements : changing some errors to warnings (e.g. transaction date, budget planned dates, etc.) We have changed the logic of processing the missing or invalid fields of sectors and locations To continuously work on improvement of data mapping rules IATI Classifiers Mapping to DAD Classifiers Classifiers Currency Implementation Status Sectors Organisations Organisation Type Organisation Role Transaction Type Modality-Aid Type Assistance Type Countries Locations CG Mapping of "Transaction Type" Classifier IATI code C D E IF IR LR R QP QS IATI name Commitment Disbursement Expenditure Incoming Funds Interest Repayment Loan Repayment Reimbursement Purchase of Equity Sale of Equity Credit Guarantee DB name Commitment Disbursement Expenditure Disbursement Disbursement Disbursement Disbursement Expenditure Disbursement Commitment 7
Mapping and Merging IATI Projects with DAD Projects After the Data Import service starts the data merging process. The data merging process is executed in the following steps: Step 1: Identifying and Linking Projects to be Transferred Step 2: Verifying Projects Step 3: Mapping Project Fields Step 4: Validating Projects
DAD in Budget and Planning -SmartIFMIS-DAD integration(in testing phase ) Ensure DAD as the only GoR s repository of ODA information; Ensure a reduction of multiple data requests from GoR to DPs; Ensure DAD capture relevant and usable information on external aid to support national planning, budgeting, execution and monitoring process; Enhance transparency and accountability of ODA (ODA Report) Establish linkages and complementarities with SmartIFMIS (Finance Management Integration System for Budgeting, Planning and Accounting for Rwanda s Domestic and External Revenues) 11
Integration of DAD with SmartFMIS 3 year projections Budget Module Development Assistance Database (DAD) MTEF Module Actual Disbursement GoR s Smart FMIS Revenue Module Direct Payment Cash Books Direct Execution GL Project Module: Integration of GoR s Chart of Account 12
SmartFMS-DAD integration - Challenges The integration was done through mapping process without changing the systems structure. DAD to fully integrate the GoR s Chart of Accounts classifications at the stage of data reporting. Projects Sectors Modalities Other challenges in fast-tracking the integration project: high turnover of staff working on the integration. developments teams located in different continents and working on multiple priorities. Way forward: In-country mission from Synergy team to finalize outstanding issues with DAD/SmartIFMIS integration 13
Thank you 14
