Proactive Publication - Contracts - Contracts over $10,000

Data Dictionary

ID
reference_number
Type
text
Label
Reference Number
Description

It is a unique identifier given to each line item in the spreadsheet. Having a unique identifier for each item will allow users to locate a specific item should they need to modify or delete.

Obligation
Primary key
ID
procurement_id
Type
text
Label
Procurement Identification Number
Description

It is recommended that the procurement identification number be the contract number. Alternatively, the procurement identification number may be the commitment number or requisition number if this is the standard practice in the department.

ID
vendor_name
Type
text
Label
Vendor Name
Description

It is recommended that the vendor name be the legal name of the contractor, as indicated on the contract. Alternatively, the vendor name may be the name in the financial system if this is the standard practice in the department.

ID
vendor_postal_code
Type
text
Label
Vendor Postal Code
Description

i. It is recommended that this field be populated with the first three digits of the postal code for the vendor identified in the contract.
ii. Alternatively, the vendor postal code may be the first three digits of the postal code identified in the procurement or financial system if this is the standard practice in the department.
iii. This field is to be populated with “NA” if the vendor is located outside of Canada, as the value “NA” for this field indicates not applicable.

ID
buyer_name
Type
text
Label
Buyer Name
Description

i. It is recommended that the field be populated with the name of the buyer, as indicated on the original contract or, alternatively, the individual responsible for the procurement at the department.
ii. For the establishment of a standing offer or supply arrangement agreement, it is recommended that this field be populated with the name of the buyer that issued the original standing offer or supply arrangement agreement.
iii. For a call-up contract against a standing offer or supply arrangement, this field should be the name of the buyer identified in the original call-up contract.
iv. For a contract with task authorizations, this field may be populated with the name of the buyer indicated in the original contract or in the individual task authorization.
v. For amendments, it is recommended that this field be populated with the value “NA,” as the value “NA” for this field indicates not applicable.
vi. For contracts awarded by PSPC or Shared Services Canada (SSC) on behalf of the client department, it is recommended that this field be populated with the name of the PSPC or SSC contracting authority. If this is not available, indicate the values, “PSPC-SPAC” or “SSC-SPC” as applicable.

ID
contract_date
Type
date
Label
Contract Date
Description

i. It is recommended that the contract date be the date the contract is awarded by the government. Alternatively, the contract date may be the hard commitment date (the date that the financial commitment is recorded in the departmental financial system) if this is the standard practice in the department.
ii. It is recommended that the contract date for a contract with task authorizations be the date that the contract is awarded (or the hard commitment date) for the contract. When the full value of the contract with task authorizations is likely not to be used, the contract date for each task authorization may be the date that each task authorization is issued (or the hard commitment date).
iii. It is recommended that the contract date for an amended contract or the exercising of an option be the date that the contract is awarded (or the hard commitment date).
iv. It is recommended that the contract date for a confirming order be the date of the verbal contract for goods, services or an amendment. If the date of the verbal contract cannot be determined, the contract date may be the date that the confirming order is issued.

Obligation
Required
ID
economic_object_code
Type
text
Label
Economic Object Code
Description

i. It is recommended that this field be populated with the contract’s numeric economic object code. Economic object codes are listed in the government-wide chart of accounts. The use of accurate economic object codes is important for maintaining the integrity of the Public Accounts of Canada. Departments are to ensure that all expenditures are coded appropriately in accordance with the Directive on Accounting Standards: GC 5000 Recording Financial Transactions in the Accounts of Canada.
ii. For standing offers and supply arrangement agreements, this field may be populated with the data value “NA” as the value “NA” for this field means not applicable.
iii. When a contract involves more than one economic object, it is recommended that the economic object associated with the largest dollar value be used. A department may use a different approach if this is the standard practice in the department.

ID
description_en
Type
text
Label
Description of Work English
Description

It is recommended that this field be populated with the economic object code’s text description as listed in the government-wide chart of accounts ( http://www.tpsgc-pwgsc.gc.ca/recgen/pceaf-gwcoa/index-eng.html ). For standing offers and supply arrangement agreements, this field may be populated with the commodity code’s text description used by the federal government for procurement activities.

ID
description_fr
Type
text
Label
Description of Work French
Description

It is recommended that this field be populated with the economic object code’s text description as listed in the government-wide chart of accounts ( http://www.tpsgc-pwgsc.gc.ca/recgen/pceaf-gwcoa/index-eng.html ). For standing offers and supply arrangement agreements, this field may be populated with the commodity code’s text description used by the federal government for procurement activities.

ID
contract_period_start
Type
date
Label
Contract Period Start Date
Description

i. For a services or construction services contract, it is recommended that the contract period start date be the starting date for the period of time over which the services are provided.
ii. For a standing or supply arrangement, it is recommended that this field be populated with the starting date for the period of time over which a call-up may be entered into.
iii. For a contract with task authorizations, it is recommended that this field be populated with the starting date for the period of time over the entire contract. For a contract with task authorizations where the full value of a contract with task authorizations is likely not to be used, it is recommended for this field be populated with the starting date for each task authorization.

ID
delivery_date
Type
date
Label
Contract Period End Date or Delivery Date
Description

i. For a goods contract, it is recommended that this field be the date when goods are to be delivered, which may be the contract period end date. The department may use the last delivery date if the contract involves multiple items on multiple dates.
ii. For a services or construction services contract, it is recommended that this field be the end date for the period of time over which the services are provided.
iii. For a standing offer or supply arrangement, it is recommended that this field be the end date for the period of time over which a call-up may be entered into.
iv. For a contract with task authorizations, it is recommended that this field be populated with the end date for the period of time over the entire contract. For a contract with task authorizations where the full value of a contract with task authorization is likely not to be used, it is recommended for this field to be populated with the end date for each task authorization.

ID
contract_value
Type
money
Label
Total Contract Value
Description

i. It is recommended that the total contract value be the amount of the hard commitment recorded in the departmental financial system for all contracts and all subsequent amendments regardless of dollar value. It is recommended for this field be in Canadian currency and for it to include all applicable taxes.
ii. For a multi-year contract, it is recommended for this field to be the total amount of the contract for all years.
iii. For a contract amendment, it is recommended for this field to be the amended contract value.
iv. For a contract with task authorizations, the full potential value of the contract may be reported upon contract award unless the full value is not expected to be used. In the latter situation, each task authorization may be reported individually or cumulatively. When a contract includes a fixed deliverable and another deliverable that requires a task authorization, the department may report the contract and task authorizations in any manner that is transparent.
v. The value of this field for the reporting of a standing offer agreement or supply arrangement agreement is $0.

ID
original_value
Type
money
Label
Original Contract Value
Description

i. It is recommended that the original contract value be the amount of the hard commitment recorded in the departmental financial system at the time of contract award for a contract or amended contract. It is recommended for this field be in Canadian currency and for it to include all applicable taxes.
ii. For a multi-year contract, it is recommended for this field to be the amount at the time of contract award for the multi-year contract period.
iii. For a contract option, it is recommended for this field to be excluded from the original contract value and for it to be reported at a later date as an amendment when the contract option is exercised. Alternatively, the full value of a contract, including options, may be reported at the time of contract award.
iv. For a contract with task authorizations, it is recommended that the original contract value be for the full amount of the contract rather than the amount specified within the minimum work guarantee clause. The full potential value of the contract may be reported in the original contract value unless the full value is not expected to be used. In the latter situation, each task authorization may be reported individually or cumulatively. When a contract includes a fixed deliverable and another deliverable that requires a task authorization, the department may report the contract and task authorizations in any manner that is transparent.
v. The value of this field for the reporting of a standing offer agreement or supply arrangement agreement should be $0.

ID
amendment_value
Type
money
Label
Contract Amendment Value
Description

i. For an amendment, it is recommended that the contract amendment value be the value of the contract amendment. Negative amendments should include a minus sign in front of the value. It is recommended for this field to be in Canadian currency and for it to include all applicable taxes.
ii. Multiple amendment(s) to a contract that take place in the same fiscal quarter may be reported either individually or combined. Positive or negative amendments over $10,000 are to be reported quarterly in accordance with Appendix A. Positive or negative amendments of $10,000 and under are to be reported annually via email to PSPC in accordance with Appendix A, and to be reported annually on the Open Government Portal in accordance with Appendix B. An amendment should be reported either quarterly or annually. Reporting an amendment both quarterly and annually would result in double counting of the amendment’s value when calculating the total contracting activity of an organization.
iii. When a contract is entered into and subsequently amended in the same fiscal quarter, the two transactions should be reported separately. Entry into the contract should be reported as a separate entry with the value at contract entry in the original contract value and should not include the value of the contract amendment. The contract amendment should also be reported as a separate entry with the value of the amendment in the contract amendment value and the contract entry value in the original contract value.
iv. For a contract with task authorizations, when the full value is likely not to be used, the value of any subsequent task authorization may be reported as an amendment with its value reported in the contract amendment value.
v. A “0” value should be included if there are no amendments associated with the contract.

ID
comments_en
Type
text
Label
Comments English
Description

i. Standardized comments are recommended to be used (refer to Appendix C). Avoid the use of acronyms within this field.
ii. Departments are encouraged to provide a brief description of each contract.
iii. When a contract involves an economic object code specified in Appendix D, departments are to fulfill the reporting requirements specified in Appendix D.

ID
comments_fr
Type
text
Label
Comments French
Description

i. Standardized comments are recommended to be used (refer to Appendix C). Avoid the use of acronyms within this field.
ii. Departments are encouraged to provide a brief description of each contract.
iii. When a contract involves an economic object code specified in Appendix D, departments are to fulfill the reporting requirements specified in Appendix D.

ID
additional_comments_en
Type
text
Label
Additional Comments English
Description

The additional comments English field may be populated with additional comments when an organization needs additional capacity to fulfill the reporting requirements under the comments English data field.

ID
additional_comments_fr
Type
text
Label
Additional Comments French
Description

The additional comments French field may be populated with additional comments when an organization needs additional capacity to fulfill the reporting requirements under the comments French data field.

ID
agreement_type_code
Type
text
Label
Agreement Type
Description

This data field is archived and replaced by the Appendix A data fields for Trade Agreement, Comprehensive Land Claims Agreement and Procurement Strategy for Indigenous Business.

Choices
Code Description
0 None
A ABSA
C NAFTA / CFTA
D CETA / TCA / CFTA
E CETA / TCA / WTO-AGP / CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA
F CETA / TCA / WTO-AGP / NAFTA / CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA
I CFTA
R LCSA
S NAFTA / CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CKFTA
T NAFTA / CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA
V CFTA / CCFTA / CKFTA
W WTO-AGP / CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA
X WTO-AGP / CFTA / CCFTA / CKFTA
Y WTO-AGP / NAFTA / CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA
Z WTO-AGP / NAFTA
AB CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CKFTA
AC CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA
AD CETA / TCA / WTO-AGP / CFTA / CCFTA / CKFTA
AF CFTA / CHFTA
AG CETA / TCA / CFTA / CHFTA
AH CKFTA
AI CFTA / CKFTA
AJ CFTA / NAFTA / CKFTA
AK CPTPP
AN CFTA / CHFTA / CETA / TCA / CPTPP
AO CFTA / CCFTA / CKFTA / WTO-AGP / CPTPP
AP CFTA / NAFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA / WTO-AGP / CETA / TCA / CPTPP
AQ CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA / WTO-AGP / CETA / TCA / CPTPP
AR CFTA / NAFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA / WTO-AGP / CPTPP
AS CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA / CPFTA / CKFTA / WTO-AGP / CPTPP
AT CFTA / CCFTA / CKFTA
AU CFTA / CCFTA / CKFTA / WTO-AGP / CETA / TCA / CPTPP
AV CFTA / CCFTA
AW CFTA / CCFTA / CPTPP
AX CFTA / CKFTA / WTO-AGP / CETA / TCA
AY CFTA / CKFTA / WTO-AGP / CETA / TCA / CPTPP
AZ CFTA / CKFTA / WTO-AGP / CPTPP
BA ABSA / LCSA
N (discontinued) NAFTA / CCFTA / CCoFTA / CHFTA / CPaFTA
P (discontinued) NAFTA / CFTA / CCFTA / CCoFTA / CHFTA / CPaFTA
U (discontinued) CCFTA
AA (discontinued) CCFTA / CCoFTA / CHFTA / CPaFTA
AE (discontinued) CHFTA
AL (discontinued) CFTA / CPTPP
AM (discontinued) CFTA / CETA / TCA / CPTPP
ID
trade_agreement
Type
text[]
Label
Trade Agreement
Description

i. It is recommended that this field indicate whether the procurement is covered by each of the applicable trade agreements.
ii. It is recommended that this field be populated with one or more of the following alphabetic characters. Report the alphabetic characters only. All text after the alphabetic characters, including the colon, is for information purposes only. For example, a procurement covered by the Canadian Free Trade Agreement and the Comprehensive Economic Free Trade Agreement is reported as CA, EU.

Choices
Code Description
CA Canadian Free Trade Agreement
CL Canada-Chile Free Trade Agreement
CO Canada-Colombia Free Trade Agreement
EU Comprehensive Economic Free Trade Agreement
GP World Trade Organization – Agreement on Government Procurement
HN Canada-Honduras Free Trade Agreement
KR Canada-Korea Free Trade Agreement
NA North American Free Trade Agreement
PA Canada-Panama Free Trade Agreement
PE Canada-Peru Free Trade Agreement
TP Comprehensive and Progressive Agreement for Trans-Pacific Partnership
UA Canada-Ukraine Free Trade Agreement
UK Canada-United Kingdom Trade Continuity Agreement
XX None
ID
land_claims
Type
text[]
Label
Comprehensive Land Claims Agreement
Description

It is recommended that this field indicate whether the procurement is for goods, services or construction services to be delivered to an area that is within one or more of the Comprehensive Land Claims Agreements.

Choices
Code Description
CH Champagne and Aishihik First Nations Final Agreement
CT Carcross/Tagish First Nation Final Agreement
EM Eeyou Marine Region Land Claims Agreement
FN First Nation of Nacho Nyak Dun Final Agreement
GW Gwich'in Comprehensive Land Claim Agreement
IF Inuvialuit Final Agreement
JN James Bay and Northern Quebec Agreement
KD Kwanlin Dun First Nation Final Agreement
KF Kluane First Nation Final Agreement
LI Labrador Inuit Land Claim Agreement
LS Little Salmon/Carmacks First Nation Final Agreement
MF Maa-nulth First Nations Final Agreement
NA Not Applicable
NF Nisga'a Final Agreement
NI Nunavik Inuit Land Claims Agreement
NQ Northeastern Quebec Agreement
NU Nunavut Agreement (Agreement between the Inuit of the Nunavut Settlement Area and Her Majesty the Queen in right of Canada)
SD Sahtu Dene and Metis Comprehensive Land Claim Agreement
SF Selkirk First Nation Final Agreement
TA Tlicho Agreement
TF Tsawwassen First Nation Final Agreement
TH Tr'ondëk Hwëch'in Final Agreement
TK Ta'an Kwach'an Council Final Agreement
TL Tla'amin Final Agreement
TT Teslin Tlingit Council Final Agreement
VG Vuntut Gwitchin First Nation Final Agreement
YA Yale First Nations Final Agreement
ID
commodity_type
Type
text
Label
Commodity Type
Description

It is recommended that the commodity type be populated with the one of the three commodity types (Good, Service or Construction). When a contract involves more than one commodity type, the commodity type associated with the largest dollar value should be used. A department may use a different approach if this is the standard practice in the department.

Choices
Code Description
C Construction
G Good
S Service
ID
commodity_code
Type
text
Label
Commodity Code
Description

i. It is recommended that the commodity code be populated with the generic product descriptions used by the federal government for procurement activities.
ii. When using the Goods and Services Identification Number (GSIN), only those GSINs published by PSPC may be used. The commodity code for goods must use a minimum of four numeric characters. The commodity code for services must use either a minimum of one alphabetic character and three numeric characters or, two alphabetic characters and two numeric characters. The commodity code for construction must use a minimum of “51” and one or two numeric characters.
iii. When a contract involves more than one commodity code, the commodity code associated with the largest dollar value should be used. A department may use a different approach if this is the standard practice in the department.

ID
country_of_vendor
Type
text
Label
Country of Vendor
Description

i. It is recommended that this data field be populated with the country of the vendor’s address identified in the contract.
ii. Alternatively, the country of the vendor may be the country of the vendor’s address identified in the procurement or financial system if this is the standard practice in the department.
iii. The country of vendor must be alphabetic characters listed in the International Organization for Standardization (ISO) 3166 Country Codes.

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
solicitation_procedure
Type
text
Label
Solicitation Procedure
Description

It is recommended that this field be populated with one of the five solicitation procedures listed below:
• AC: Advance Contract Award Notice (ACAN) refers to a contract awarded to a supplier identified under an ACAN process where it was determined that there were no other statements of capabilities that could successfully meet the government’s requirements.
• OB: Competitive – Open Bidding (Government Electronic Tendering System (GETS)) refers to a competitive contract where bids were solicited via GETS.
• TC: Competitive – Traditional refers to a competitive contract where bids were not solicited via GETS, but through another medium, such as soliciting bids directly from suppliers by email or phone.
• ST: Competitive – Selective Tendering refers to a solicitation procedure permitted under Canada’s trade agreements where qualified suppliers are selected from a source list (including single-use or multi-use lists) under the selective tendering procedural rules in Canada’s trade agreements.
• TN: Non-competitive refers to a contract awarded to a supplier without soliciting bids.

Choices
Code Description
AC Advance Contract Award Notice
OB Competitive – Open Bidding (GETS)
ST Competitive – Selective Tendering
TC Competitive – Traditional
TN Non-Competitive
ID
limited_tendering_reason
Type
text[]
Label
Limited Tendering Reason
Description

It is recommended that this field be populated with one or more of the limited tendering reasons listed below.

Choices
Code Description
00 None
05 No response to bid solicitation
20 Goods purchased on a commodity market
21 Purchases made under exceptionally advantageous conditions
22 Winner of an architectural design contest
23 Consulting services regarding matters of a confidential nature (for contracts not covered by CETA, TCA ,WTO-GPA, CPTPP, CKFTA and CUFTA)
30 Work on a property by a contractor according to a warranty or guarantee (for contracts that are only covered by the CFTA)
31 Work on a leased building or related property performed only by the lessor (for contracts that are only covered by the CFTA)
32 Subscriptions to newspapers, magazines, or other periodicals (for contracts that are only covered by the CFTA)
33 Goods regarding matters of a confidential or privileged nature (for contracts that are only covered by the CFTA)
71 Exclusive rights
72 Prototype purchase
74 Additional deliveries (formerly Interchangeable Parts)
81 Extreme urgency
24 Additional construction services (discontinued as of 2022-01-01)
25 New construction services (discontinued as of 2022-01-01)
85 Low dollar-value (discontinued as of 2022-01-01)
86 Prices and/or sources fixed by government regulations (discontinued as of 2022-01-01)
87 Government objectives representing best interests/value (discontinued as of 2022-01-01)
90 Protection of human, animal, or plant Life or health (discontinued as of 2022-01-01)
ID
trade_agreement_exceptions
Type
text[]
Label
Trade Agreement Exceptions and Exclusions
Description

It is recommended that this field to be populated with one or more of the exceptions or exclusions listed below.

Choices
Code Description
00 None
01 Shipbuilding and repair (applies to all agreements except the CFTA)
02 Urban rail and urban transportation equipment systems, components and materials (applies to all agreements except CFTA, CETA, TCA and CPTPP)
03 Contracts respecting FSC 58 (communications, detection and coherent radiation equipment) (applies to all agreements except CFTA, CETA, TCA and CPTPP)
04 Set-asides for small and minority businesses (discontinued as of 2022-01-01)
05 Agricultural products made in furtherance of agricultural support programs or human feeding programs (applies to all agreements except for CFTA)
06 The Depts. of Transport, Communications and Fisheries & Oceans respecting FSC 70, 74, 36 (applies to all agreements except CFTA, CKFTA, WTO-AGP, CUFTA, CETA, TCA and CPTPP)
07 Any measures for Indigenous peoples and businesses, including set asides for Indigenous businesses (applies to all agreements)
08 Set-asides for small businesses other than Indigenous businesses (applies to all agreements except for CETA and TCA)
09 Measures necessary to protect public morals, order or safety (applies to all agreements)
10 Measures necessary to protect human, animal or plant life or health (applies to all agreements)
11 Measures necessary to protect intellectual property (applies to all agreements)
12 Measures relating to goods or services of persons with disabilities, philanthropic institutions or prison labour (applies to all agreements)
13 Services procured in support of military forces located overseas (applies to all agreements)
14 Research and development services (applies to all trade agreements except for CFTA)
ID
indigenous_business
Type
text
Label
Procurement Strategy for Indigenous Business
Description

It is recommended that this field indicate whether the Procurement Strategy for Indigenous Business mandatory or voluntary set-aside applies to the procurement transaction.

Choices
Code Description
MS Mandatory Set-Aside
NA None
VS Voluntary Set-Aside
ID
indigenous_business_excluding_psib
Type
text
Label
Indigenous Business excluding PSIB (formerly PSAB incidental indicator)
Description

i. It is recommended that this field indicate whether a contract was awarded to an Indigenous business.
ii. Any contract awarded to an Indigenous business where the procurement is subject to a mandatory or voluntary set-aside under the Procurement Strategy for Indigenous Business should be reported as “No” under this data field as such contracts are already reported under the Procurement Strategy for Indigenous Business data field.

Choices
Code Description
N No
Y Yes
ID
intellectual_property
Type
text
Label
Intellectual Property Indicator
Description

It is recommended that this field identify whether there are terms and conditions in the contract related to intellectual property and whether those terms would result in Crown or contractor ownership of the rights to the intellectual property.

Choices
Code Description
A2 Crown owned – exception 2
A3 Crown owned – exception 3
A41 Crown owned – exception 4.1
A42 Crown owned – exception 4.2
A43 Crown owned – exception 4.3
A5 Crown owned – exception 5
A8 Crown owned – exemption 8 (note: must have received approval of the Treasury Board via a Treasury Board submission)
B Contractor Owned
C No IP Terms in Contract
A1 Crown owned – exception 1 (discontinued as of 2022-01-01)
A65 Crown owned – exception 6.5 (discontinued as of 2017-01-01)
D Organization Not Subject to IP Policy (discontinued as of 2017-01-01)
NA Not Applicable (discontinued as of 2022-01-01)
ID
potential_commercial_exploitation
Type
text
Label
Potential for Commercial Exploitation
Description

It is recommended that this field identify whether intellectual property generated under the contract has the potential for commercial exploitation.

Choices
Code Description
N No
Y Yes
ID
former_public_servant
Type
text
Label
Former Public Servant in receipt of a PSSA pension
Description

It is recommended that this field identify whether the contractor is a former public servant in receipt of a pension under the Public Service Superannuation Act (PSSA).

Choices
Code Description
N No
Y Yes
ID
contracting_entity
Type
text
Label
Contracting Entity
Description

i. It is recommended that this field identify whether the procurement is a contract awarded by the client department, PSPC, SSC or another departmental entity or a call-up contract against a standing offer agreement or supply arrangement agreement established by PSPC, SSC or the department.
ii. If PSPC awards a contract against a PSPC SOSA on behalf of a client department, it is recommended that the contract be reported as “PWC” for this field.
iii. If SSC awards a contract against a SSC SOSA on behalf of a client department, it is recommended that the contract be reported as “SSCC” for this field.
iv. If a department awards a contract against a PSPC or SSC SOSA, it is recommended that the contract be reported as “PWSOSA” or “SSCSOSA” as applicable.

Choices
Code Description
DC Contract awarded by the department.
DSOSA Call-up or Contract Against a Standing Offer or Supply Arrangement Agreement established by the department
OGDC Contract awarded by another department on behalf of the client department.
PWC Contract or Call-up awarded by PSPC on behalf of the client department.
PWSOSA Call-up or Contract awarded by client department against a Standing Offer or Supply Arrangement Agreement established by Public Services and Procurement Canada
SSCC Contract awarded or Call-up by SSC on behalf of the client department.
SSCSOSA Call-up or Contract awarded by client department against a Standing Offer or Supply Arrangement Agreement established by Shared Services Canada
ID
standing_offer_number
Type
text
Label
Standing Offer or Supply Arrangement Number
Description

It is recommended that this field be populated with the Standing Offer or Supply Arrangement Number applicable to this contract. This field should be left blank if there is no standing offer or supply arrangement established by PSPC or SSC associated with this contract.

ID
instrument_type
Type
text
Label
Instrument Type
Description

i. It is recommended that the instrument type identify whether the transaction being reported is a contract, contract amendment, or a standing offer or supply arrangement agreement.
ii. The instrument type for:
- A contract is “C”;
- An amendment is “A”;
- A standing offer agreement or supply arrangement agreement is “SOSA”;
- Issuing a call-up against a standing offer or supply arrangement is “C”; and
- An amendment to a call-up is “A” for this field.
iii. When a contract is entered into and subsequently amended in the same fiscal quarter, the two transactions should be reported separately. Entry into the contract should be reported as one entry and should be identified as a contract by entering “C” for this field. The contract amendment should be reported as a separate entry and be identified as an amendment by entering “A” for this field.
iv. When a standing offer or supply arrangement agreement is amended, it should continue to be identified as an “SOSA” for this field.

Choices
Code Description
A Amendment
C Contract
SOSA Standing Offer or Supply Arrangement Agreement
ID
ministers_office
Type
text
Label
Minister's Office Contracts
Description

It is recommended that this field indicate whether the transaction is for the Minister’s office. Ministers’ offices contracts are any contracts for goods and services entered into by a minister or their exempt staff. In accordance with the Policies for Ministers’ Offices, such contracts should be charged to either a Minister’s other operating budget or to the Parliamentary Secretary’s Assistant/Advisor operating budget. Please refer to the Policies for Ministers’ Offices for more information on the Minister’s office budgets. This data field should be entered for contracts and amendments awarded effective June 21, 2019, or, alternatively, for the contracts and amendments awarded within the month of this effective date.

Choices
Code Description
N No
Y Yes
ID
number_of_bids
Type
int
Label
Number of Bids
Description

It is recommended that this field be populated with the total number of compliant and non-compliant bids received in the procurement.
i. For a competitive contract, it is recommended for this field to be the number of bids received pursuant to a bid solicitation.
ii. For a call-up contract against a standing offer agreement established under a competitive process, it is recommended that a value of “0” be entered for this field. In this instance, the value of “0” represents not applicable.
iii. For a contract with task authorizations, the number of bids of the contract may be reported if this value is known when the task authorization is issued. If the number of bids is unknown, the department may input a value of 0 to indicate it is not applicable.
iv. If the contract was awarded using an Advance Contract Award Notice (ACAN) and it was determined that there were no statements of capabilities that met the ACAN requirements, it is recommended that a value of “1” be entered for this field.
iv. For non-competitive contract, it is recommended that a value of “1” be entered for this field.
vi. For the establishment of a standing offer or supply arrangement agreement, it is recommended for this field to be the number of standing offer or supply arrangement bids received. If the standing offer was established under a non-competitive or an ACAN procurement process where it was determined that there were no statements of capabilities that meet the ACAN requirements, it is recommended that a value of “1” be entered for this field for subsequent contracts awarded under the standing offer.
vii. For a competitive contract awarded by PSPC, SSC or another department on behalf of the client department, a value of “0” may be entered if the information is not available within the reporting period for which the contract was awarded. Once the information is available, the contract record is to be updated at the next subsequent reporting period, or as soon as practicable.

ID
article_6_exceptions
Type
text
Label
Section 6 Government Contracts Regulations Exceptions
Description

i. The Government Contracts Regulations requires the solicitation of bids unless one of the s.6 exceptions to the Government Contracts Regulations applies to the contract.
ii. It is recommended that this field be populated with one of the s.6 exceptions to solicit bids if bids have not been solicited for the contract.
iii. It is recommended that this field be populated with one of the s.6 exceptions to solicit bids if the contract was awarded using an Advance Contract Award Notice (ACAN) and it was determined that there were no statements of capabilities that met the ACAN requirements.
iv. For contracts whereby bids have been solicited or if the procurement is not a contract subject to the Government Contracts Regulations, the value of “0” should be entered. For this data value, the value of “0” represents not applicable.

Choices
Code Description
0 Not applicable
1 Pressing emergency in which delay would be injurious to the public interest
2 Does not exceed s.6 (b) Government Contracts Regulations prescribed dollar limits.
3 Not in the public interest to solicit bids
4 Only one person is capable of performing the contract
ID
award_criteria
Type
text
Label
Award Criteria
Description

It is recommended that this field be populated with one of the bid evaluation methodologies below if bids have been solicited for the contract:
i. If bids have not been solicited, the value of “0” is to be selected.
ii. For ACANs whereby it was determined that there were no statements of capabilities that met the ACAN requirements, the value of “0” should be entered.
iii. For amendments, select the value of “0” of this field.
iv. For a competitive contract awarded by PSPC, SSC or another department on behalf of the client department, a value of “0” may be entered if the information is not available within the reporting period for which the contract was awarded. Once information is available, the contract record is to be updated at the next subsequent reporting period, or as soon as practicable.

Choices
Code Description
0 Not applicable
1 Lowest Price
2 Lowest Cost-per-Point
3 Highest Combined Rating of Technical Merit and Price
4 Highest Technical Merit within a Stipulated Maximum Budget
5 Variations or combinations of the above methods
ID
socioeconomic_indicator
Type
text
Label
Socio-Economic Indicator
Description

It is recommended for this field to indicate whether the procurement is subject to one or more of the applicable Socio-economic indicators.

Choices
Code Description
FP Federal Contractors Program for Employment Equity
NA None
ID
reporting_period
Type
text
Label
Reporting Period
Description

It is recommended that this field be populated in the standard format described below.
When published on the Open Government portal, this field will contain the fiscal quarter this particular contract entry was reported to the public. For example if a contract is being amended on May 3, 2017, and reported in the first fiscal quarter of 2017-–2018, the entry should be 2017-2018-Q1.

Choices
Code Description
1995-1996-Q1 1995-1996-Q1
1995-1996-Q2 1995-1996-Q2
1995-1996-Q3 1995-1996-Q3
1995-1996-Q4 1995-1996-Q4
1996-1997-Q1 1996-1997-Q1
1996-1997-Q2 1996-1997-Q2
1996-1997-Q3 1996-1997-Q3
1996-1997-Q4 1996-1997-Q4
1997-1998-Q1 1997-1998-Q1
1997-1998-Q2 1997-1998-Q2
1997-1998-Q3 1997-1998-Q3
1997-1998-Q4 1997-1998-Q4
1998-1999-Q1 1998-1999-Q1
1998-1999-Q2 1998-1999-Q2
1998-1999-Q3 1998-1999-Q3
1998-1999-Q4 1998-1999-Q4
1999-2000-Q1 1999-2000-Q1
1999-2000-Q2 1999-2000-Q2
1999-2000-Q3 1999-2000-Q3
1999-2000-Q4 1999-2000-Q4
2000-2001-Q1 2000-2001-Q1
2000-2001-Q2 2000-2001-Q2
2000-2001-Q3 2000-2001-Q3
2000-2001-Q4 2000-2001-Q4
2001-2002-Q1 2001-2002-Q1
2001-2002-Q2 2001-2002-Q2
2001-2002-Q3 2001-2002-Q3
2001-2002-Q4 2001-2002-Q4
2002-2003-Q1 2002-2003-Q1
2002-2003-Q2 2002-2003-Q2
2002-2003-Q3 2002-2003-Q3
2002-2003-Q4 2002-2003-Q4
2003-2004-Q1 2003-2004-Q1
2003-2004-Q2 2003-2004-Q2
2003-2004-Q3 2003-2004-Q3
2003-2004-Q4 2003-2004-Q4
2004-2005-Q1 2004-2005-Q1
2004-2005-Q2 2004-2005-Q2
2004-2005-Q3 2004-2005-Q3
2004-2005-Q4 2004-2005-Q4
2005-2006-Q1 2005-2006-Q1
2005-2006-Q2 2005-2006-Q2
2005-2006-Q3 2005-2006-Q3
2005-2006-Q4 2005-2006-Q4
2006-2007-Q1 2006-2007-Q1
2006-2007-Q2 2006-2007-Q2
2006-2007-Q3 2006-2007-Q3
2006-2007-Q4 2006-2007-Q4
2007-2008-Q1 2007-2008-Q1
2007-2008-Q2 2007-2008-Q2
2007-2008-Q3 2007-2008-Q3
2007-2008-Q4 2007-2008-Q4
2008-2009-Q1 2008-2009-Q1
2008-2009-Q2 2008-2009-Q2
2008-2009-Q3 2008-2009-Q3
2008-2009-Q4 2008-2009-Q4
2009-2010-Q1 2009-2010-Q1
2009-2010-Q2 2009-2010-Q2
2009-2010-Q3 2009-2010-Q3
2009-2010-Q4 2009-2010-Q4
2010-2011-Q1 2010-2011-Q1
2010-2011-Q2 2010-2011-Q2
2010-2011-Q3 2010-2011-Q3
2010-2011-Q4 2010-2011-Q4
2011-2012-Q1 2011-2012-Q1
2011-2012-Q2 2011-2012-Q2
2011-2012-Q3 2011-2012-Q3
2011-2012-Q4 2011-2012-Q4
2012-2013-Q1 2012-2013-Q1
2012-2013-Q2 2012-2013-Q2
2012-2013-Q3 2012-2013-Q3
2012-2013-Q4 2012-2013-Q4
2013-2014-Q1 2013-2014-Q1
2013-2014-Q2 2013-2014-Q2
2013-2014-Q3 2013-2014-Q3
2013-2014-Q4 2013-2014-Q4
2014-2015-Q1 2014-2015-Q1
2014-2015-Q2 2014-2015-Q2
2014-2015-Q3 2014-2015-Q3
2014-2015-Q4 2014-2015-Q4
2015-2016-Q1 2015-2016-Q1
2015-2016-Q2 2015-2016-Q2
2015-2016-Q3 2015-2016-Q3
2015-2016-Q4 2015-2016-Q4
2016-2017-Q1 2016-2017-Q1
2016-2017-Q2 2016-2017-Q2
2016-2017-Q3 2016-2017-Q3
2016-2017-Q4 2016-2017-Q4
2017-2018-Q1 2017-2018-Q1
2017-2018-Q2 2017-2018-Q2
2017-2018-Q3 2017-2018-Q3
2017-2018-Q4 2017-2018-Q4
2018-2019-Q1 2018-2019-Q1
2018-2019-Q2 2018-2019-Q2
2018-2019-Q3 2018-2019-Q3
2018-2019-Q4 2018-2019-Q4
2019-2020-Q1 2019-2020-Q1
2019-2020-Q2 2019-2020-Q2
2019-2020-Q3 2019-2020-Q3
2019-2020-Q4 2019-2020-Q4
2020-2021-Q1 2020-2021-Q1
2020-2021-Q2 2020-2021-Q2
2020-2021-Q3 2020-2021-Q3
2020-2021-Q4 2020-2021-Q4
2021-2022-Q1 2021-2022-Q1
2021-2022-Q2 2021-2022-Q2
2021-2022-Q3 2021-2022-Q3
2021-2022-Q4 2021-2022-Q4
2022-2023-Q1 2022-2023-Q1
2022-2023-Q2 2022-2023-Q2
2022-2023-Q3 2022-2023-Q3
2022-2023-Q4 2022-2023-Q4
2023-2024-Q1 2023-2024-Q1
2023-2024-Q2 2023-2024-Q2
2023-2024-Q3 2023-2024-Q3
2023-2024-Q4 2023-2024-Q4

Additional Information

Created December 1, 2016
Format CSV