• Published

    • IATI Publishing: Key Relationships

    Owned by Harshula Jhala
    Last updated: Nov 27, 2023 by Wilmarié Moreland
    2 min read

    This page covers:

    Related pages:

    Analytics and Data Publishing: Overview

    The Analytics and Data Publishing functionality in Amp Impact has two key components:

    1. IATI Publishing: This feature facilitates creating XML files to publish to the International Aid Transparency Initiative (IATI) registry using the IATI Activity and IATI Organisation standards. Amp Impact has specific objects and fields for entering activity and transaction data and flows for generating XML files that can be uploaded to the IATI registry.

    2. PowerBI templates: PowerBi is a Microsoft software for performing advanced analytics on data sets and creating dynamic dashboards. Amp Impact has a PowerBI template that can be used as a starting point for building dashboards to visualize Amp Impact data using PowerBI.

    IATI Publishing: Data Model

    Below is the Analytics and Data Publishing data model subset:

    IATI Publishing: Summary of Key Relationships

    There are three key relationships that are foundational to IATI Publishing:

    • IATI Sector through Project IATI Sector (junction object): This relationship enables organizations to relate specific IATI Sector records from the catalog of IATI Sectors to their Amp Impact Project/s.

    • IATI Policy through Project IATI Policy (junction object): This relationship enables organizations to relate specific IATI Policy records from the catalog of IATI Policies to their Amp Impact Project/s.

    • Transaction Project IATI Sector (junction object): This relationship enables organizations to relate Allocation, Budget, and Disbursement records to Project IATI Sector.

    Here is a summary of these relationships:

    Amp Object Label

    Amp Object API name

    Abbreviation

    Object Description

    Amp Object Label

    Amp Object API name

    Abbreviation

    Object Description

    IATI Sector

    ampi__IATI_Sector__c

    None

    The IATI Sector object holds the catalog of IATI-relevant sectors that can be added to Amp projects. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object.

    IATI Policy

    ampi__IATI_Policy__c

    None

    The IATI Policy object holds a catalog of IATI Policies records that can be linked to projects in Amp Impact. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object.

    Project IATI Sector

    ampi__Project_IATI_Sector__c

    None

    Project IATI Sector is a junction object storing the relationship between a Project and a specific IATI Sector in Amp. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object.

    Project IATI Policy

    ampi__Project_IATI_Policy__c

    None

    Project IATI Policy is a junction objects storing the relationship between catalog IATI Policies and Projects in Amp Impact. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object.

    Transaction Project IATI Sector

    ampi__Transaction_Project_IATI_Sector__c

    None

    Transaction Project IATI Sector is a junction object connecting Allocations, Budgets and Disbursements to Project IATI Sector. It's only used in IATI publishing. Organizations not using IATI publishing will not use this object.