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.
- Obligation
- Mandatory if amendment number set
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- ID
- prog_purpose_en
- Type
- text
- Label
- Program Purpose (English)
- Description
The program purpose is the program’s purpose according to the Ts&Cs.
- Obligation
- Optional
- ID
- prog_purpose_fr
- Type
- text
- Label
- Program Purpose (French)
- Description
The program purpose is the program’s purpose according to the Ts&Cs.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional (Mandatory when funding provided in foreign currency)
- 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.
- Obligation
- Mandatory if foreign currency type is selected
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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.
- Obligation
- Optional
- 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- Obligation
- Optional
- 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- Obligation
- Optional
Additional Information
Created | February 20, 2017 |
---|---|
Format | CSV |