DZYUBAN

D-0001 to D-0100

D-0014 · Transport Canada publishes 184 contract amendment rows that depart from the schema

D-0014 · Transport Canada publishes 184 contract amendment rows that depart from the schema

28 September 2026 · Transport Canada

Class E · score 9, High · 400 CAD · Notified

Obligation. The dataset Proactive Publication of Contracts is published with a schema. For the field amendment_value the schema reads: “it is recommended that the contract amendment value be the value of the contract amendment”. Its check on the same field reads: “This field must be populated if Amendment (A) was selected as the Instrument Type”. For the field contract_date it reads: “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)”. The Directive on the Management of Procurement, Appendix C, section C.2.2, requires the published data to be “materially accurate and complete”.

Conduct. The dataset, as downloaded on 2 September 2026, carries 184 amendment rows of Transport Canada that depart from the schema. In 12 rows amendment_value holds the running total of all amendments of the contract, not the amount the amendment added. In 2 rows amendment_value is blank. In 170 rows contract_date holds the date of the amendment, later than the award date carried by the original contract row of the same contract.

TC-2025-2026-Q4-00404, INTERVISTAS CONSULTING INC.: amendment_value reads $115,825.00, the amendment added $15,820.00. TC-2024-2025-Q2-00261, MICROSOFT CANADA INC.: contract_date reads 2024-09-12, the contract was awarded on 2024-07-09.

Why it scores where it does. Reach 3 — national, and every person who uses the dataset. Harm 1 — money and time, no personal injury. Absence of a remedy 3 — no route exists for a member of the public to compel a publisher to correct an open dataset. Persistence 2 — the same departure in 184 rows of the same body. Total 9, High, 400 CAD.

Evidence.

  • The public CSV of the dataset Proactive Publication of Contracts (d8f85d91-7dec-4fd1-8055-483b77225d8b), downloaded on 2 September 2026: 1,313,540 rows, 204,495 of them amendments.
  • The 184 rows by reference_number, each with every row of the same contract in order.
  • Workings of the amendment rows of the register: dzyuban.com/workshop/register-amendments/
  • The notice to the department of 28 September 2026, delivered by email.

Notice. Not escalated. Notified 28 September 2026 by email.