Proactive Disclosure - Grants and Contributions - Proactive Disclosure - Grants and Contributions

Data Dictionary

ID
ref_number
Type
text
Label
Reference Number
Description

The Reference number is populated by departments. It is a unique reference number given to each entry. Having a unique identifier for each item will allow departments to locate a specific item in the registry should they need to modify or delete.


Controlled format; This field is populated in the following format DDD-YYYY-YYYY-QX-XXXXX
1. DDD represents the department number – See annex A for list of department numbers
2. YYYY-YYYY represents the fiscal year
3. QX represents the fiscal quarter
4. XXXXX represents the unique number assigned by the department for each entry.


For example, entries in the 2018-2019 Q1 fiscal year should be assigned numbers as follows: 001-2018-2019-Q1-00001, 001-2018-2019-Q1-00002, 001-2018-2019-Q1-00003, etc.'

Obligation
Primary key
ID
amendment_number
Type
int
Label
Amendment Number
Description

This field is populated by departments and identifies that an amendment is occurring to original information. Use 0 for original records.

Obligation
Primary key
ID
amendment_date
Type
date
Label
Amendment Date
Description

This field is populated by departments and indicates the date on which an amendment (or amendments) took place. If the amendment number is not zero, this field is required.

ID
agreement_type
Type
text
Label
Agreement Type
Description

This field is populated by departments and indicates whether the agreement signed is a grant, contribution or other transfer payment.

Obligation
Required
Choices
Code Description
C Contribution
G Grant
O Other transfer payment
ID
recipient_type
Type
text
Label
Recipient Type
Description

The recipient type helps identify who is receiving the money.

Choices
Code Description
A Aboriginal recipients
F For-profit organizations
G Government
I International (non-government)
N Not-for-profit organizations and charities
O Other
P Individual or sole proprietorships
S Academia
ID
recipient_business_number
Type
text
Label
Recipient Business Number
Description

The Business Number is a nine digit number issued by the Canada Revenue Agency since 1994. Per the Directive on the Business Number, it has been identified as the standard identifier for all transactions between businesses and the Government of Canada, including transactions linked to grant and/or contribution funding.


The business number should be populated for an organization or charity.


Real-time validation of business identity information linked to the Business Number, including legal name and operating name, for sole proprietorship, partnerships and incorporations, is available to departments through the Business Number Web Validation Service. For more details contact ic.bnadoptionne.ic@canada.ca.


To validate a Business Number associated with a charity, departments can access the List of Charities basic search on the Canada.ca website. Enter the Charity name and click the Search button. Then click the Charity name of the search result to find additional information about the charity (e.g., Charity Program number, charity status, effective date of status, designation, etc.) Legal name and operating name cannot be validated using this basic search.


A business number is issued when an organization is registered federally, provincially or municipally. It does not change and will allow for consistent identification even if the legal name, the operation name or the organization changes over the life cycle of the grant or contribution.

ID
recipient_legal_name
Type
text
Label
Recipient Legal Name (English|French)
Description

The recipient legal name is meant to complement the existing “Recipient business number” field. It is the legal name of the recipient. This information should be taken from the agreement.


Only translated if the legal name is provided in both official languages by the recipient. Provide in the following format: name English|name French.

Obligation
Required
ID
recipient_operating_name
Type
text
Label
Recipient Operating Name (English|French)
Description

The “Recipient operating name” is an optional field used when an organization operates under a name that differs from its legal name or business number. When a researcher receives funding through a university, this information would be populated here. This field is not intended to capture the ultimate recipient of a grant or contribution; instead, the name of the person receiving funding from the Government of Canada should be entered.


Only translated if the name is provided in both official languages by the recipient. Provide in the following format: Legal name English|Legal name French.

ID
research_organization_name
Type
text
Label
Research Organization (English|French)
Description

The “Research organization” is an optional field for including information about the organization that the recipient represents. This field will be used mainly to highlight academic organizations that researchers have partnered with.


Only translated if the organization name is provided in both official languages by the recipient in the following format: name English|name French.

ID
recipient_country
Type
text
Label
Recipient Country
Description

The “Recipient country” is a mandatory field. It is the country in which the recipient resides.

Obligation
Required
Choices
Code Description
AD Andorra
AE United Arab Emirates
AF Afghanistan
AG Antigua and Barbuda
AI Anguilla
AL Albania
AM Armenia
AO Angola
AQ Antarctica
AR Argentina
AS American Samoa
AT Austria
AU Australia
AW Aruba
AX Åland Islands
AZ Azerbaijan
BA Bosnia and Herzegovina
BB Barbados
BD Bangladesh
BE Belgium
BF Burkina Faso
BG Bulgaria
BH Bahrain
BI Burundi
BJ Benin
BL Saint Barthélemy
BM Bermuda
BN Brunei Darussalam
BO Bolivia (Plurinational State of)
BQ Bonaire, Sint Eustatius and Saba
BR Brazil
BS Bahamas
BT Bhutan
BV Bouvet Island
BW Botswana
BY Belarus
BZ Belize
CA Canada
CC Cocos (Keeling) Islands
CD Democratic Republic of the Congo
CF Central African Republic
CG Congo
CH Switzerland
CI Côte d'Ivoire
CK Cook Islands
CL Chile
CM Cameroon
CN China
CO Colombia
CR Costa Rica
CU Cuba
CV Cabo Verde
CW Curaçao
CX Christmas Island
CY Cyprus
CZ Czechia
DE Germany
DJ Djibouti
DK Denmark
DM Dominica
DO Dominican Republic
DZ Algeria
EC Ecuador
EE Estonia
EG Egypt
EH Western Sahara
ER Eritrea
ES Spain
ET Ethiopia
FI Finland
FJ Fiji
FK Falkland Islands (Malvinas)
FM Micronesia (Federated States of)
FO Faroe Islands
FR France
GA Gabon
GB United Kingdom of Great Britain and Northern Ireland
GD Grenada
GE Georgia
GF French Guiana
GG Guernsey
GH Ghana
GI Gibraltar
GL Greenland
GM Gambia
GN Guinea
GP Guadeloupe
GQ Equatorial Guinea
GR Greece
GS South Georgia and the South Sandwich Islands
GT Guatemala
GU Guam
GW Guinea-Bissau
GY Guyana
HK China, Hong Kong Special Administrative Region
HM Heard Island and McDonald Islands
HN Honduras
HR Croatia
HT Haiti
HU Hungary
ID Indonesia
IE Ireland
IL Israel
IM Isle of Man
IN India
IO British Indian Ocean Territory
IQ Iraq
IR Iran (Islamic Republic of)
IS Iceland
IT Italy
JE Jersey
JM Jamaica
JO Jordan
JP Japan
KE Kenya
KG Kyrgyzstan
KH Cambodia
KI Kiribati
KM Comoros
KN Saint Kitts and Nevis
KP Democratic People's Republic of Korea
KR Republic of Korea
KW Kuwait
KY Cayman Islands
KZ Kazakhstan
LA Lao People's Democratic Republic
LB Lebanon
LC Saint Lucia
LI Liechtenstein
LK Sri Lanka
LR Liberia
LS Lesotho
LT Lithuania
LU Luxembourg
LV Latvia
LY Libya
MA Morocco
MC Monaco
MD Republic of Moldova
ME Montenegro
MF Saint Martin (French Part)
MG Madagascar
MH Marshall Islands
MK The former Yugoslav Republic of Macedonia
ML Mali
MM Myanmar
MN Mongolia
MO China, Macao Special Administrative Region
MP Northern Mariana Islands
MQ Martinique
MR Mauritania
MS Montserrat
MT Malta
MU Mauritius
MV Maldives
MW Malawi
MX Mexico
MY Malaysia
MZ Mozambique
NA Namibia
NC New Caledonia
NE Niger
NF Norfolk Island
NG Nigeria
NI Nicaragua
NL Netherlands
NO Norway
NP Nepal
NR Nauru
NU Niue
NZ New Zealand
OM Oman
PA Panama
PE Peru
PF French Polynesia
PG Papua New Guinea
PH Philippines
PK Pakistan
PL Poland
PM Saint Pierre and Miquelon
PN Pitcairn
PR Puerto Rico
PS State of Palestine
PT Portugal
PW Palau
PY Paraguay
QA Qatar
RE Réunion
RO Romania
RS Serbia
RU Russian Federation
RW Rwanda
SA Saudi Arabia
SB Solomon Islands
SC Seychelles
SD Sudan
SE Sweden
SG Singapore
SH Saint Helena
SI Slovenia
SJ Svalbard and Jan Mayen Islands
SK Slovakia
SL Sierra Leone
SM San Marino
SN Senegal
SO Somalia
SR Suriname
SS South Sudan
ST Sao Tome and Principe
SV El Salvador
SX Sint Maarten (Dutch part)
SY Syrian Arab Republic
SZ Eswatini
TC Turks and Caicos Islands
TD Chad
TF French Southern Territories
TG Togo
TH Thailand
TJ Tajikistan
TK Tokelau
TL Timor-Leste
TM Turkmenistan
TN Tunisia
TO Tonga
TR Turkey
TT Trinidad and Tobago
TV Tuvalu
TW Taiwan
TZ United Republic of Tanzania
UA Ukraine
UG Uganda
UM United States Minor Outlying Islands
US United States of America
UY Uruguay
UZ Uzbekistan
VA Holy See
VC Saint Vincent and the Grenadines
VE Venezuela (Bolivarian Republic of)
VG British Virgin Islands
VI United States Virgin Islands
VN Viet Nam
VU Vanuatu
WF Wallis and Futuna Islands
WS Samoa
XK Kosovo
YE Yemen
YT Mayotte
ZA South Africa
ZM Zambia
ZW Zimbabwe
ID
recipient_province
Type
text
Label
Recipient Province or Territory
Description

The "Recipient province or territory" is a mandatory field that identifies where, within Canada, the recipient resides.

Choices
Code Description
AB Alberta
BC British Columbia
MB Manitoba
NB New Brunswick
NL Newfoundland & Labrador
NS Nova Scotia
NT Northwest Territories
NU Nunavut
ON Ontario
PE Prince Edward Island
QC Quebec
SK Saskatchewan
YT Yukon
ID
recipient_city
Type
text
Label
Recipient City (English|French)
Description

The "Recipient city" is a mandatory field that identifies which city the recipient operates in. This field can be populated with Canadian or foreign cities.


Official city names should be provided, including both official languages (where applicable in the following format: name English|name French


Free text, but a controlled list from Canada Revenue Agency’s qualified donees list of municipalities can be consulted: Canada Revenue Agency website (http://www.cra-arc.gc.ca/chrts-gvng/qlfd-dns/mncplts-eng.html).

Obligation
Required
ID
recipient_postal_code
Type
text
Label
Recipient Postal Code
Description

The "Recipient postal code" is a mandatory field that serves to identify the specific area in which the recipient operates. In cases where this field cannot be populated this field may be left blank.


Text format locked to "X#X #X#"; The Canada Post tool for looking up a postal code can be found on the Canada Post website.

ID
federal_riding_name_en
Type
text
Label
Federal Riding Name (English)
Description

The federal riding name is the name of the riding in which the recipient resides.

ID
federal_riding_name_fr
Type
text
Label
Federal Riding Name (French)
Description

The federal riding name is the name of the riding in which the recipient resides.

ID
federal_riding_number
Type
text
Label
Federal Riding Number
Description

The federal riding number is based on the riding in which the recipient resides. Departments can consult the Elections Canada website in order to retrieve the federal riding number. http://www.elections.ca/content.aspx?section=res&dir=cir/list&document=index338&lang=e

ID
prog_name_en
Type
text
Label
Program Name (English)
Description

The program name is the name of the program, according to the terms and conditions (Ts&Cs), under which a recipient is funded.

ID
prog_name_fr
Type
text
Label
Program Name (French)
Description

The program name is the name of the program, according to the terms and conditions (Ts&Cs), under which a recipient is funded.

ID
prog_purpose_en
Type
text
Label
Program Purpose (English)
Description

The program purpose is the program’s purpose according to the Ts&Cs.

ID
prog_purpose_fr
Type
text
Label
Program Purpose (French)
Description

The program purpose is the program’s purpose according to the Ts&Cs.

ID
agreement_title_en
Type
text
Label
Agreement Title (English)
Description

The agreement title is the title of the project or agreement that the recipient is undertaking. In cases where there is no title, the agreement number will be duplicated here.

ID
agreement_title_fr
Type
text
Label
Agreement Title (French)
Description

The agreement title is the title of the project or agreement that the recipient is undertaking. In cases where there is no title, the agreement number will be duplicated here.

ID
agreement_number
Type
text
Label
Agreement Number
Description

The agreement number should be the number on the agreement and/or in the departmental Gs&Cs system.

ID
agreement_value
Type
money
Label
Agreement Value in CAD
Description

The agreement value is the dollar amount stated in the grant or contribution agreement. This field should be populated with a monetary value in Canadian dollars.

Obligation
Required
ID
foreign_currency_type
Type
text
Label
Foreign Currency Type
Description

The foreign currency type should be selected if a recipient is paid in a currency other than Canadian dollars. Select the type of foreign currency in this field (for example, US dollar (USD), Australian dollar (AUD), British pound (GBP)). This field is mandatory if the agreement is awarded in foreign currency.'


Foreign currency type is populated using the ISO 4217 alphabetic codes for foreign currency. This list can be found on the XE website. Entry is selected from a drop-down list.

Choices
Code Description
ALL Lek
AMD Armenian Dram
ANG Netherlands Antillean Guilder
AOA Kwanza
ARS Argentine Peso
AUD Australian Dollar
AWG Aruban Florin
AZN Azerbaijanian Manat
BAM Convertible Mark
BBD Barbados Dollar
BDT Taka
BGN Bulgarian Lev
BHD Bahraini Dinar
BIF Burundi Franc
BND Brunei Dollar
BOB Boliviano
BOV Mvdol
BRL Brazilian Real
BSD Bahamian Dollar
BTN Ngultrum
BWP Pula
BYR Belarussian Ruble
BZD Belize Dollar
CAD Canadian Dollar
CDF Congolese Franc
CHF Swiss Franc
CLF Unidad de Fomento
CLP Chilean Peso
CNY Yuan Renminbi
COP Colombian Peso
CRC Costa Rican Colon
CUC Peso Convertible
CVE Cabo Verde Escudo
CZK Czech Koruna
DJF Djibouti Franc
DKK Danish Krone
DOP Dominican Peso
DZD Algerian Dinar
EGP Egyptian Pound
ERN Nakfa
ETB Ethiopian Birr
EUR Euro
FJD Fiji Dollar
GBP Pound Sterling
GEL Lari
GIP Gibraltar Pound
GMD Dalasi
GNF Guinea Franc
GTQ Quetzal
GYD Guyana Dollar
HKD Hong Kong Dollar
HNL Lempira
HRK Kuna
HTG Gourde
HUF Forint
IDR Rupiah
ILS New Israeli Sheqel
INR Indian Rupee
IQD Iraqi Dinar
IRR Iranian Rial
ISK Iceland Krona
JMD Jamaican Dollar
JOD Jordanian Dinar
JPY Yen
KES Kenyan Shilling
KGS Som
KHR Riel
KMF Comoro Franc
KRW Won
KWD Kuwaiti Dinar
KYD Cayman Islands Dollar
KZT Tenge
LAK Kip
LBP Lebanese Pound
LRD Liberian Dollar
LSL Loti
LYD Libyan Dinar
MGA Malagasy Ariary
MKD Denar
MOP Pataca
MUR Mauritius Rupee
MVR Rufiyaa
MWK Kwacha
MYR Malaysian Ringgit
NOK Norwegian Krone
NZD New Zealand Dollar
SVC El Salvador Colon
USD US Dollar
XAF CFA Franc BEAC
XCD East Caribbean Dollar
XDR SDR (Special Drawing Right)
XOF CFA Franc BCEAO
XPF CFP Franc
ZAR Rand
ID
foreign_currency_value
Type
money
Label
Foreign Currency Value
Description

The foreign currency value is the amount as signed in the grant or contribution agreement with the recipient. This field should be populated with a monetary value in the foreign currency. This field is mandatory if the agreement is awarded in a foreign currency.

ID
agreement_start_date
Type
date
Label
Agreement Start Date
Description

The agreement start date is the assumed start of the agreement, or when the project is supposed to begin, as captured in the initial agreement.

Obligation
Required
ID
agreement_end_date
Type
date
Label
Projected Agreement End Date
Description

The projected agreement end date is the assumed end of the agreement, or when the project is supposed to end, as captured in the initial agreement.

ID
coverage
Type
text
Label
Coverage (English|French; ...)
Description

Coverage provides information about what will benefit from the project or agreement. Departments should populate this with any information they have available.

ID
description_en
Type
text
Label
Description (English)
Description

The description explains why the recipient received funding. It should provide a brief yet accurate description of what the recipient is undertaking.

Obligation
Required
ID
description_fr
Type
text
Label
Description (French)
Description

The description explains why the recipient received funding. It should provide a brief yet accurate description of what the recipient is undertaking.

Obligation
Required
ID
naics_identifier
Type
text
Label
NAICS Identifier
Description

The North American Industry Classification System (NAICS) is an industry classification system developed by the statistical agencies of Canada, Mexico and the United States.

ID
expected_results_en
Type
text
Label
Expected Results or Intended Outcome (English)
Description

The expected results or intended outcome is the assumed result of project completion. It should be populated in accordance with the project that the recipient is undertaking or the program under which it is funded. This field will attempt to explain why the project is being undertaken, and what the final results should be.

ID
expected_results_fr
Type
text
Label
Expected Results or Intended Outcome (French)
Description

The expected results or intended outcome is the assumed result of project completion. It should be populated in accordance with the project that the recipient is undertaking or the program under which it is funded. This field will attempt to explain why the project is being undertaken, and what the final results should be.

ID
additional_information_en
Type
text
Label
Additional Information (English)
Description

Additional information is information that departments are required to enter under the guidance instructions for exceptions but that is not captured in any of the aforementioned fields. It may contain information on:
•additional funding departments
•funding through a third party
•ministerial announcements
•research fields
•joint funding
•collaborators and partners
•keywords
•belated reporting
•novation agreements
•terminations
•repayability

ID
additional_information_fr
Type
text
Label
Additional Information (French)
Description

Additional information is information that departments are required to enter under the guidance instructions for exceptions but that is not captured in any of the aforementioned fields. It may contain information on:
•additional funding departments
•funding through a third party
•ministerial announcements
•research fields
•joint funding
•collaborators and partners
•keywords
•belated reporting
•novation agreements
•terminations
•repayability

Additional Information

Created February 20, 2017
Format CSV