Project¶
General Overview¶
Names¶
Name |
Definition |
Type |
---|---|---|
Impact Bond Name - (Value) |
Full name of the Social Impact Bond. What counts as an Impact Bond project? It is a contractual relationship that includes two core factors: • Payment for social or environmental outcomes achieved • Up-front repayable finance provided by a third party, the repayment of which is (at least partially) conditional on achieving specified outcomes. Each impact bond project that begins work under a new contract, with a new target cohort, a distinct geography, and/or with a later start date is counted separately. |
Text |
Name |
Definition |
Type |
---|---|---|
Alternative Names - (Value) |
Additional or informal names should be specified in this variable. If the project has more than one alternative name, they should be separated by commas. |
Text |
Stage of Development¶
Name |
Definition |
Type |
---|---|---|
Stage of Development - (Value) |
Stage of development of the project at the moment of data collection. Codelist options are:
|
Codelist |
Stage of Development - (Source ID’s) |
Stage of development of the project at the moment of data collection. |
Text |
Jurisdiction¶
Name |
Definition |
Type |
---|---|---|
Jurisdiction - Jurisdiction - (Value) |
Project jurisdiction describes a project’s origins, using the place it is governed or organised from, under law, as a proxy. Codelist options are: A 2 character country code from ISO 3166. Eg: GB, US |
Codelist |
Jurisdiction - (Source ID’s) |
Text |
|
Jurisdiction - (Notes) |
Text |
Dates¶
Name |
Definition |
Type |
---|---|---|
Dates - Date outcomes contract signed - (Value) |
Date on which the outcomes contract was signed. If signed by parties on different dates, select the latest date of signature. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Dates - Date contracts between all parties signed - (Value) |
The date on which the full set of required contracts between impact bonds parties received sign off. That is the date – whichever is the later – on which parties signed the outcomes contract; service delivery contract; investment contract or any other contract signalling the agreement to the impact bond arrangement such that full contracting arrangements are signed. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Dates - Anticipated completion date - (Value) |
Expected date when final outcomes payments will be made. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Dates - Actual completion date - (Value) |
Actual date when final outcomes payments were made. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Dates - Start date of service provision - (Value) |
Date when service provision started/will start. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Dates - Anticipated end date of service provision - (Value) |
Expected date when service provision will end. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Dates - Actual end date of service provision - (Value) |
Actual date when service provision ended/will end. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Dates - (Source ID’s) |
Text |
|
Dates - (Notes) |
Text |
Overall project finance¶
Name |
Definition |
Type |
---|---|---|
Overall project finance - Total investment commitment - Currency - (Value) |
Currency in which financial data is reported for this project. |
Text |
Overall project finance - Total investment commitment - Amount - Min - (Value) |
When it is not possible to share the exact amount of total investment, projects can present a range with minimun and maximum values. |
Number |
Overall project finance - Total investment commitment - Amount - Exact - (Value) |
Total investment amount committed by investors (capital raised), as contractually agreed. Note that this should not include any recycled outcome payments. |
Number |
Overall project finance - Total investment commitment - Amount - Max - (Value) |
When it is not possible to share the exact amount of total investment, projects can present a range with minimun and maximum values. |
Number |
Overall project finance - Total investment commitment - Amount USD - Min - (Value) |
Minimum investment amount in US dollars. |
Number |
Overall project finance - Total investment commitment - Amount USD - Exact - (Value) |
Exact investment amount in US dollars. |
Number |
Overall project finance - Total investment commitment - Amount USD - Max - (Value) |
Maximum investment amount in US dollars. |
Number |
Overall project finance - Maximum potential outcome payment - Currency - (Value) |
Total maximum payments for outcomes from outcome funders. This should be equal to “contract cap”. |
Text |
Overall project finance - Maximum potential outcome payment - Amount - (Value) |
Total maximum payments for outcomes from outcome funders. This should be equal to “contract cap”. |
Number |
Overall project finance - Maximum potential outcome payment - Amount USD - (Value) |
Total maximum payments for outcomes from outcome funders. This should be equal to “contract cap”. |
Number |
Overall project finance - Maximum potential loss - (Value) |
Percentage of principal that investors stand to lose in a worst-case scenario. Please provide for each investor, if different. |
Text |
Overall project finance - Maximum potential return type - (Value) |
This variable identifies whether the return is average annual return or IRR (Internal rate of return). |
Text |
Overall project finance - Maximum potential return - (Value) |
Percentage return that investors expect to gain in best case scenario. Return can be understood as the profit on an investment. This is typically the ratio of the income from the investment over the cost of the investment. Please provide for each investor, if different. |
Text |
Overall project finance - Configuration of the Contracting Parties - (Value) |
A description of the bilateral or multilateral relationship between contracting parties. It identifies which party/parties hold the contract with the outcome funder (or which actor has majority control of a contract-holding Special Purpose Vehicle). |
Text |
Overall project finance - Investor repayment - (Value) |
To be completed at the end of the project. Extent to which investment and return was paid to investor. |
Text |
Overall project finance - Total outcome payments made - Currency - (Value) |
Currency in which outcome payments data is reported for this project. |
Text |
Overall project finance - Total outcome payments made - Amount - (Value) |
Total actual payments for outcomes disbursed by outcome payers. |
Number |
Overall project finance - Total outcome payments made - Amount USD - (Value) |
Total actual payments for outcomes disbursed by outcome payers in USD. This will be calculated by GO Lab staff. |
Number |
Overall project finance - (Source ID’s) |
Text |
|
Overall project finance - (Notes) |
Text |
Purpose and classifications¶
Name |
Definition |
Type |
---|---|---|
Purpose and classifications - Social challenge - (Value) |
Broad definition of the social challenges that the project addresses. |
Text |
Purpose and classifications - Intervention - (Value) |
Description of the intervention supported by the Impact Bond. |
Text |
Purpose and classifications - Policy sector - (Value) |
Main policy sector in which the project is based. Codelist options are:
|
Codelist |
Purpose and classifications - Primary SDG goal - (Value) |
Primary Sustainable Development Goal (SDG) in which the project is based. To be selected from the 17 SDGs defined in the United Nations 2030 Agenda (2015) https://sdgs.un.org/2030agenda. [This is at the project level. This is also captured at the outcome level] |
Text |
Purpose and classifications - Secondary SDG goals - (Value) |
Secondary Sustainable Development Goal (SDG) in which the project is based. Primary SDG Goal must not be included in this variable. [This is at the project level. This is also captured at the outcome level] |
Text |
Purpose and classifications - Primary SDG target - (Value) |
This variable identifies what primary SGD target the project is addressing. See United Nations 2030 Agenda (2015) https://sdgs.un.org/2030agenda. [This is at the project level. This is also captured at the outcome level] |
Text |
Purpose and classifications - Secondary SDG targets - (Value) |
This variable identifies what secondary SGD target the project is addressing. Primary SDG target must not be included in this variable. See United Nations 2030 Agenda (2015) https://sdgs.un.org/2030agenda. [This is at the project level. This is also captured at the outcome level] |
Text |
Purpose and classifications - (Source ID’s) |
Text |
|
Purpose and classifications - (Notes) |
Text |
Service and beneficiaries¶
Name |
Definition |
Type |
---|---|---|
Service and beneficiaries - Target population - (Value) |
Description of the population targeted by the project and any eligibility requirement for the cohort of people who are to be offered support. |
Text |
Service and beneficiaries - Targeted number of unique service users or beneficiaries (total) - (Value) |
Intended number of individuals in the target population who will be engaged in the service/intervention and/or whose social outcomes will be evaluated for outcome contract payment calculation. |
Number |
Service and beneficiaries - Unit type of targeted service users or beneficiaries - (Value) |
Description of the unit of measurement that is used to account for targeted service users or beneficiaries. Codelist options are:
|
Codelist |
Service and beneficiaries - Unit description of targeted service user or beneficiaries - (Value) |
This field will only be completed if the answer to the last variable was “other”. This variable identifies what type of unit of measurement is used to account for targeted service users or beneficiaries. |
Text |
Service and beneficiaries - Actual number of unique service users or beneficiaries engaged (total) - (Value) |
Effective number of service users after the project was completed. The actual number of service users may differ from the targeted number, as forecasted at the beginnings of the project. |
Number |
Service and beneficiaries - Unit type of actual service users or beneficiaries engaged - (Value) |
Description of the unit of measurement that is used to account for targeted service users or beneficiaries. Codelist options are:
|
Codelist |
Service and beneficiaries - Unit description of actual service user or beneficiaries engaged - (Value) |
This field will only be completed if the answer to the last variable was “other”. This variable identifies what type of unit of measurement is used to account for actual number of service users or beneficiaries. |
Text |
Service and beneficiaries - (Source ID’s) |
Text |
|
Service and beneficiaries - (Notes) |
Text |
Changes to project due to COVID-19¶
Name |
Definition |
Type |
---|---|---|
Changes to project due to COVID-19 - (Value) |
Codelist options are:
|
Codelist |
Changes to project due to COVID-19 - (Source ID’s) |
Text |
Outcome Funds¶
Name |
Definition |
Type |
---|---|---|
Id |
Text |
|
Sources |
Text |
|
Notes |
Text |
When viewing data, other variables from the fund data model may be included to provide more information. See the Fund data dictionary for more information on what these variables mean.
Delivery Locations¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Service Provision ID - (Value) |
Text |
|
Location - Name - (Value) |
Name of the city or region where services are provided. |
Text |
Location - Postcode - (Value) |
Postal code of the location where services are provided. |
Text |
Location - Country - (Value) |
Country where services are provided. Codelist options are: A 2 character country code from ISO 3166. Eg: GB, US |
Codelist |
Lat/Lng - Lat - (Value) |
Latitude and longitude coordinates. GO Lab will add or double check this variable. This variable feeds into the map(s) on the GO Lab website. |
Number |
Lat/Lng - Lng - (Value) |
Latitude and longitude coordinates. GO Lab will add or double check this variable. This variable feeds into the map(s) on the GO Lab website. |
Number |
Adminstrative geography - Name - (Value) |
Text |
|
Adminstrative geography - Code Type - (Value) |
Text |
|
Adminstrative geography - Code - (Value) |
Text |
|
Sources |
Text |
|
Notes |
Text |
Sources¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Id |
A within-project original, flexible identifiers to be referenced in another sheet. This can be set by the GO Lab analyst. |
Text |
Name - (Value) |
Name of the person or institution who shared information about this project. |
Text |
Type - (Value) |
Type of source of information. |
Text |
Publishing Organisations - (Value) |
Organisation that published the evaluation, report, document or website that is cited as a source. |
Text |
URL - (Value) |
URL of the document about this project. |
Text |
Archive URL - (Value) |
A preserved copy of an online source that can be accessed if the original page is moved, changes, or disappears. |
Text |
Internal URL - (Value) |
Text |
|
Publication Date - (Value) |
Date when the information about this project was published. |
Text |
Accessed Date - (Value) |
Date when the information about this project was accessed. |
Text |
Notes |
Text |
Organisations¶
When viewing data, variables from the organisation data model may be included to provide more information. See the Organisation data dictionary for more information on what these variables mean.
The organisations listed are those referenced in other parts of the project, such as Service Provisions.
Service Provisions¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Id |
A within-project original, flexible identifiers to be referenced in another sheet. This can be set by the analyst. |
Text |
Organisation ID - (Value) |
INDIGO identifier of the organisation that provides services for this impact bond project. See INDIGO Identifiers section. |
Text |
Organisation Role Category - (Value) |
Category of service provider. Codelist options are:
|
Codelist |
Intervention - (Value) |
Description of the intervention or the activities that service providers are funded to address the social challenge. |
Text |
Planned Service - Start - (Value) |
Expected date when service delivery starts. |
Text |
Planned Service - End - (Value) |
Expected date when service delivery ends. |
Text |
Actual Service - Start - (Value) |
Actual date when service delivery starts. |
Text |
Actual Service - End - (Value) |
Actual date when service delivery ends. |
Text |
Alterations to service - Description - (Value) |
This variable specifies whether there has been a modification in the service delivery. Where there are multiple alterations, this field should describe all alterations that have taken place. |
Text |
Alterations to service - Reason - (Value) |
This variable presents the motivation for that modification, if applicable. Where there are multiple alterations, this field should describe the reason for all alterations that have taken place. |
Text |
Sources |
Text |
|
Notes |
Text |
Outcome Payment Commitments¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Organisation ID - (Value) |
INDIGO identifier of the organisation that pays for social outcomes in this impact bond project. See INDIGO Identifiers section. |
Text |
Organisation Role Category - (Value) |
Category of outcome payer Codelist options are:
|
Codelist |
Maximum potential Outcome payment - Currency - (Value) |
Total maximum payments for outcomes from each outcome payer. Currency. |
Text |
Maximum potential Outcome payment - Amount - (Value) |
Total maximum payments for outcomes from each outcome payer. |
Number |
Maximum potential Outcome payment - Amount USD - (Value) |
Total maximum payments for outcomes from each outcome payer. In USD. |
Number |
Result type - (Value) |
This variable specifies whether a result is interim or over all (final). Codelist options are:
|
Codelist |
Period - Start - (Value) |
This variable provides the start date of the performance period. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Period - End - (Value) |
This variable provides the end date of the performance period. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Total outcome payments made - Currency - (Value) |
Currency in which outcome payments are reported for this project. |
Text |
Total outcome payments made - Amount - (Value) |
Total actual payments for outcomes disbursed by outcome payers in relevant local currency. |
Number |
Total outcome payments made - Amount USD - (Value) |
Total actual payments for outcomes disbursed by outcome payers in USD. |
Number |
Alterations to payment commitment - Description - (Value) |
Detail of the modifications to payment commitments occured during the life of the impact bond project. |
Text |
Alterations to payment commitment - Reason - (Value) |
Brief explanation of the reasons behind the modifications to payment commitments occured during the life of the impact bond project. |
Text |
Sources |
Text |
|
Notes |
Text |
Investments¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Id |
A within-project original, flexible identifiers to be referenced in another sheet. This can be set by the GO Lab analyst. |
Text |
Organisation ID - (Value) |
INDIGO identifier for the organisation that invested upfront capital for this project. See INDIGO Identifiers section. |
Text |
Organisation Role Category - (Value) |
Codelist options are:
|
Codelist |
Investment Commitment - Currency - (Value) |
Currency in which investments are reported for this project. |
Text |
Investment Commitment - Amount - Min - (Value) |
When it is not possible to share exact amounts, projects can share a range with minimum and maximum amount of investment committed by each investor. |
Number |
Investment Commitment - Amount - Exact - (Value) |
Exact amount of committed investment from each investor. |
Number |
Investment Commitment - Amount - Max - (Value) |
When it is not possible to share exact amounts, projects can share a range with minimum and maximum amount of investment committed by each investor. |
Number |
Investment Commitment - Amount USD - Min - (Value) |
Minimum amount of investment committed by each investor in USD (when it is not possible to have exact amount in USD). |
Number |
Investment Commitment - Amount USD - Exact - (Value) |
Exact amount of investment committed by each investor in USD. |
Number |
Investment Commitment - Amount USD - Max - (Value) |
Maximum amount of investment committed by each investor in USD (when it is not possible to have exact amount in USD). |
Number |
Maximum Potential loss - (Value) |
Percentage of principal that investors stand to lose in a worst-case scenario. |
Text |
Maximum Potential Return Type - (Value) |
This variable specifies whether the maximum potential return type is measured as average annual return or IRR. Codelist options are:
|
Codelist |
Maximum Potential Return - (Value) |
Percentage return that investors stand to gain in best case scenario. |
Number |
Investor Repayment - (Value) |
Extent to which investment and return was paid to investor. Codelist options are:
|
Codelist |
Investment Type - (Value) |
This variable identifies whether this investment qualifies as debt, equity or a combination of both. Codelist options are:
|
Codelist |
Sources |
Text |
|
Notes |
Text |
Intermediary services¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Organisation ID - (Value) |
INDIGO identifier for the organisation that provides intermediary services for this project. See INDIGO Identifiers section. |
Text |
Organisation Role Category - (Value) |
The role(s) or key functions performed by each of the named intermediaries. Codelist options are:
|
Codelist |
Other Role Description - (Value) |
If an organization is providing a role that is not listed above, it can be listed in this field. |
Text |
Sources |
Text |
|
Notes |
Text |
Outcome Metrics¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Id |
A within-project original, flexible identifiers to be referenced in another sheet. This can be set by any analyst. The outcome is what changes for an individual as the result of a service or intervention. |
Text |
Outcome Definition - (Value) |
An outcome target or metric is the specific value attached to the measure of outcomes for the purposes of determining whether satisfactory performance has been achieved. In an impact bond, these targets will usually determine whether a payment is made to the provider or investor. This variable provides a detailed description of the metric(s) used to determine payments from the outcome payers. It should provide a clear definition of the conditions under which an outcome is agreed to have been ‘achieved’ or ‘not achieved’. |
Text |
Target Population - (Value) |
Description of the targeted population of beneficiaries or service users. |
Text |
Targeted number of service users Or beneficiaries (total) - (Value) |
Targeted number of beneficiaries/service users for each outcome metric |
Number |
Unit type of targeted Service users or beneficiaries - (Value) |
Description of the unit of measurement that is used to account for targeted service users or beneficiaries. Codelist options are:
|
Codelist |
Unit description of Service user or beneficiaries - (Value) |
This field will only be completed if the answer to the last variable was “other”. This variable identifies what type of unit of measurement is used to account for targeted service users or beneficiaries. |
Text |
Outcome metric target - (Value) |
Targeted levels of outcome metrics to be achieved (e.g. the proportion of people supported who are expected to achieve a given outcome) |
Text |
Other target for Meeting outcome metric target - (Value) |
This variable identifies information about other/secondary targets that need to be met in order to achieve the outcome. |
Text |
Outcome validation Method - (Value) |
The approach taken to assessing whether the specified outcomes have been achieved and the basis on which ‘outcome payments’ will be made. This could take the form of validated administrative data (for example in a rate card for youth engagement where young people achieve education outcomes, the production of these qualifications may be used as the basis of outcome payments) or a formal and independent impact evaluation (for example under a Randomised Control Trial or quasi-experimental study outcome payments are only made when the performance of the treatment group is significantly improved when compared to the control group). To be selected from: Randomised Control Trial; Quasi-experimental study; Historical comparison (e.g. comparison to historical benchmark); Pre-Post analysis (measurement of outcomes for target individual or cohort before and after intervention); Simple ex-post verification; Not available. |
Text |
Data source for Outcome validation - (Value) |
The sources of information for outcome validation could be existing administrative data or new data collected. |
Text |
Policy sector - (Value) |
Main policy sector in which the project is based. |
Text |
Primary SDG goal - (Value) |
Primary Sustainable Development Goal (SDG) in which the project is based. To be selected from the 17 SDGs defined in the United Nations 2030 Agenda (2015) https://sdgs.un.org/2030agenda. |
Text |
Secondary SDG goals - (Value) |
Secondary Sustainable Development Goal (SDG) in which the project is based. Primary SDG Goal must not be included in this variable. |
Text |
Primary SDG target - (Value) |
This variable identifies what primary SGD target the project is addressing. See United Nations 2030 Agenda (2015) https://sdgs.un.org/2030agenda. |
Text |
Secondary SDG targets - (Value) |
This variable identifies what secondary SGD target the project is addressing. Primary SDG target must not be included in this variable. See United Nations 2030 Agenda (2015) https://sdgs.un.org/2030agenda. |
Text |
Sources |
Text |
|
Notes |
Text |
Outcome Pricing¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Outcome Metric Id - (Value) |
A within-project original, flexible identifier to be referenced in another sheet. This can be set by the GO Lab analyst. This ID should be equal to the ID that was stated in the “Results” and “Outcome metrics” sections. |
Text |
Currency - (Value) |
Currency in which outcome pricing data is reported for this project. |
Text |
Price Per Unit - Amount - (Value) |
Price per unit, often a participant, for whom outcomes are achieved. Price here is the cost to the outcome payer. This is to be populated only if there is a single outcome which is measured at the unit /individual level. Use the currency stated in the above field. |
Number |
Price Per Unit - Amount USD - (Value) |
Price per unit, often a participant, for whom outcomes are achieved in USD. Price here is the cost to the outcome payer. |
Number |
Maximum Price if all targets achieved - Amount - (Value) |
Maximum price if all targets related to that outcome are achieved. |
Text |
Contracted increases to outcome pricing - (Value) |
If certain price increases have been contracted (e.g. inflation adjustments), an description of these terms should be provided. |
Text |
Price Description - (Value) |
Text |
|
Sources |
Text |
|
Notes |
Text |
Results¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Outcome Metric Id - (Value) |
A within-project original, flexible identifiers to be referenced in another sheet. This can be set by a GO Lab analyst. |
Text |
Result level - (Value) |
This variable specifies whether a result was captured at the outcome level or project level. Codelist options are:
|
Codelist |
Result type - (Value) |
This variable specifies whether a result is interim or final. Codelist options are:
|
Codelist |
Period - Start - (Value) |
This variable provides the start date of the performance period. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Period - End - (Value) |
This variable provides the end date of the performance period. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Outcomes achieved - (Value) |
A description of the outcomes that were achieved, according to the specifications of the contract. |
Text |
Number engaged In impact bond - (Value) |
Number of users or beneficiaries who engaged in the impact bond project. |
Number |
Number with Positive social outcomes - (Value) |
Number of users or beneficiaries who engaged in the impact bond project and achieved positive outcomes. |
Number |
Other Description of result - (Value) |
A broader description of the results of the impact bond, if applicable. |
Text |
Outcomes validator(s) - (Value) |
Name(s) of organization(s) responsible for validating the achievement of outcomes or otherwise assessing the metrics underpinning outcome payments. One outcome can have two or more validators. |
Text |
Evaluation Documents - (Value) |
An evaluation is an objective assessment of a programme to determine whether and to what degree the intervention in an impact bond project has had an impact on the measured outcome variables over time. This variable provides a link to any published evaluations, if applicable. |
Text |
Sources |
Text |
|
Notes |
Text |
Outcome Payments¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Outcome Metric Id - (Value) |
A within-project original, flexible identifier to be referenced in another sheet. This can be set by a GO Lab analyst. |
Text |
Period - Start - (Value) |
Start date of claim period. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Period - End - (Value) |
End date of claim period. |
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD |
Payer Organisation ID - (Value) |
INDIGO ID of organisation that is paying for outcomes. |
Text |
Recipient Organisation ID - (Value) |
INDIGO ID of organisation that is receiving payment for outcomes. |
Text |
Type - (Value) |
Codelist options are:
|
Codelist |
Payments - Currency - (Value) |
Currency in which outcome payments are reported for this project. |
Text |
Payments - Amount - (Value) |
Amount of outcome payments received in this period in relevant currency. |
Number |
Payments - Amount USD - (Value) |
Amount of outcome payments received in this period in USD. |
Number |
Sources |
Text |
|
Notes |
Text |
Open Contracting¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
OCID |
OCID identifier that links this impact bond project with data on the contracting process. |
Text |
Sources |
Text |
|
Notes |
Text |
360Giving¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Grant ID |
360Giving identifier that links this impact bond project with data on received grants. |
Text |
Sources |
Text |
|
Notes |
Text |
Documents¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Title - (Value) |
Title of related document or case study. |
Text |
URL - (Value) |
URL of related document or case study. |
Text |
Notes |
Text |
Scenarios¶
This is a list. One project can have multiple items of data. One item of data is defined as:
Name |
Definition |
Type |
---|---|---|
Scenario Id |
Text |
|
Name - (Value) |
Text |
|
Overall project finance - Maximum potential outcome payment - Currency - (Value) |
Text |
|
Overall project finance - Maximum potential outcome payment - Amount - (Value) |
Number |
|
Overall project finance - Maximum potential outcome payment - Amount USD - (Value) |
Number |
|
Sources |
Text |
|
Notes |
Text |
Social Investment Prototype¶
The Social Investment Prototype offers additional tabs to describe technical assistance and the financial aspects of projects in greater detail, including individual transactions.
On the General Overview tab:
Name
Definition
Type
Social Investment Prototype - (Value)
Codelist options are:
Codelist
Investment Details¶
Expected and latest internal rates of return can be recorded on the investment details tab (This may be in the general overview tab).
Name
Definition
Type
Investment Details - Total Funds Invested - Latest - Currency - (Value)
The currency of the investment data provided.
Text
Investment Details - Total Funds Invested - Latest - Amount - (Value)
The total invested amount to date.
Number
Investment Details - Total Funds Invested - Latest - Amount USD - (Value)
To be calculated by GO Lab staff using the year in the above date and World Bank data available online at https://data.worldbank.org/indicator/PA.NUS.FCRF [Note that this variable does not capture and may misrepresent fluctuations over different years. This is an issue being tackled in the prototyping process.]
Number
Investment Details - Total Funds Invested - Latest - Date - (Value)
The date.
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD
Investment Details - Internal Rate of Return - Target - (Value)
The targeted rate of return of an investment on the project after all costs have been considered, to determine profitability (net IRR)
Text
Investment Details - Internal Rate of Return - Latest - (Value)
The latest actual rate of return of an investment on the project after all costs have been considered, to determine profitability. Reported as date below. If actual IRR is not being reported seek to indicate if Actual IRR exceeds Target IRR (yes/no)
Text
Investment Details - Internal Rate of Return - Date - (Value)
Date
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD
Investment Details - (Source ID’s)
Text
Investment Details - (Notes)
Text
Transactions¶
The transactions tab is designed as a ledger of money in and money out of a project.
A transaction is modelled with a sending organisation and a receiving organisation, a date and an amount. These fields are required.
The value of a transaction (Amount) must be positive.
A transaction can be linked to the project as a whole (the default) or to a:
Outcome payment (using the Outcome Metric ID column to link to the relevant row on the Outcome Metrics tab);
Investment (using the Investment ID column to link to the relevant row on the Investment tab); or,
Grant (using the Grant ID column to link to the relevant row on the Grants tab).
Only one of these IDs should appear per row, i.e. transactions should be disaggregated where possible. This is particularly important if the data is to be used in further analysis or visualisations.
The transaction type field is used to identify the purpose of the transaction.
The formatting rules on dates and currency values should be followed.
This is a list. One project can have multiple items of data. One item of data is defined as:
Name
Definition
Type
Investment Id - (Value)
A within-project original, flexible identifier to be referenced in another sheet.
Text
Outcome Metric Id - (Value)
A within-project original, flexible identifier to be referenced in another sheet.
Text
Grant Id - (Value)
Text
Date - (Value)
Date when the transaction occurred.
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD
Sending Organisation ID - (Value)
INDIGO ID of the organisation that makes the transaction.
Text
Receiving Organisation ID - (Value)
INDIGO ID of the organisation that receives the transaction.
Text
Transaction Type - (Value)
This variable specifies whether the transaction is a debt or repayment of debt, equity, payment for an outcome or other type of transaction.
Codelist options are:
Codelist
Money - Currency - (Value)
Currency in which transaction data is reported.
Text
Money - Amount - (Value)
Total amount of the transaction in relevant currency.
Number
Money - Amount USD - (Value)
Total amount of the transaction in USD.
Number
Sources
Text
Notes
Text
Technical Assistance¶
Technical Assistance is modelled as a period of engagement between a funding organisation and a recipient organisation with a defined start and end date.
This period of engagement can be broken down on the Technical Assistance Details tab into a series of component activities (as well as high-level information that covers the whole engagement where appropriate).
An activity is linked to an engagement by using the relevant id from the Technical Assistance tab. Multiple activities can be linked to a single engagement.
Data should not be provided if no technical assistance from a given category has been given, i.e., zero values are not necessary but assumed in the absence of data.
Each activity can be assigned a cost and a cost type and a time cost in days.
Where no cost is available, or where a cost is inappropriate, a row can be added with the relevant category selected and the value and cost type fields left blank. This will allow activities to be analysed as simple counts.
Activities can be further classified by the delivery approach.
On the Technical Assistance tab, there is a list. One project can have multiple items of data. One item of data is defined as:
Name
Definition
Type
Id
A within-project original, flexible identifiers to be referenced in another sheet. This can be set by any analyst. The outcome is what changes for an individual as the result of a service or intervention.
Text
Title - (Value)
A summary name for this element of TA. Note that each project may have multiple elements of TA. TA may be broken into different elements as necessary to allow the category, cost and/or other variables to be completed.
Text
Description - (Value)
Description of this element of TA.
Text
Period Start - (Value)
Date when this specific element of TA starts
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD
Period End - (Value)
Date when this specific element of TA finishes.
Enter a date in format YYYY, YYYY-MM or YYYY-MM-DD
Funding Organisation Id - (Value)
Id of the organization that pays for technical assistance.
Text
Recipient Organisation Id - (Value)
Id of the organization that receives technical assistance.
Text
Currency - (Value)
Currency in which costs of TA are described.
Text
Sources
Text
Notes
Text
On the Technical Assistance Details tab, there is a list. One project can have multiple items of data. One item of data is defined as:
Name
Definition
Type
Technical Assistance Id - (Value)
A within-project original, flexible identifier to be referenced in another sheet.
Text
Title - (Value)
A summary name for this element of TA.
Text
Description - (Value)
A description of this element of TA.
Text
Category - (Value)
This variable has a long list of options. TA should be broken into elements and one item from the list be selected for each element.
Codelist options are:
Codelist
Approach - (Value)
This variable captures different approaches in which a social investor can deliver TA.
Codelist options are:
Codelist
Cost Type - (Value)
Codelist options are:
Codelist
Cost of Activities - Amount - (Value)
Cost of Technical Assistance activities in relevant currency.
Number
Cost of Activities - Amount USD - (Value)
Cost of Technical Assistance activities in USD.
Number
Number of Days - (Value)
Cost of Technical Assistance activities in days of work.
Number
Sources
Text
Notes
Text