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 2024-2025-Q1 2024-2025-Q1 2024-2025-Q2 2024-2025-Q2 2024-2025-Q3 2024-2025-Q3 2024-2025-Q4 2024-2025-Q4
Additional Information
Data last updated | December 7, 2024 |
---|---|
Metadata last updated | December 7, 2024 |
Created | December 1, 2016 |
Format | CSV |
Title | Contracts over $10,000 |
Resource Type | Dataset |
Size | 542.0 MB(542,048,763 bytes) |
Language | English French |
Validation status | Valid data |
Validation timestamp | December 7, 2024, 06:42 (UTC) |