Proactive Publication - Contracts - Aggregated Total - Contracts $10K and under

Data Dictionary

ID
year
Type
year
Label
Calendar Year Reporting Period
Description

It is recommended for this field to be populated in the standard format described below. For example, if the template is being reported for the 2017 calendar year, the entry will be populated as 2017.

Obligation
Primary key
ID
contract_goods_number_of
Type
int
Label
Number of Goods Contracts $10K and under
Description

It is recommended for this field to be populated with the total number of goods contracts entered into with a value of $10,000 and under. This includes goods contracts entered into and subsequently amended in the same calendar year to an amended contract value of $10,000 and under.

Obligation
Required
ID
contracts_goods_original_value
Type
money
Label
Goods Contracts $10K and under - Original Value
Description

It is recommended for this field to be populated with the value of all goods contracts with a value of $10,000 and under, at the time of contract entry. This value should be in Canadian currency and include all applicable taxes.

Obligation
Required
ID
contracts_goods_amendment_value
Type
money
Label
Goods Contracts Amendments from -$10K to $10K - Net Amendment Value
Description

It is recommended for this field to be populated with the value of all net amendments to goods contracts (that is, all positive and negative amendments) with a value from -$10,000 to $10,000. This value should be in Canadian currency and include all applicable taxes. 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.

Obligation
Required
ID
contract_service_number_of
Type
int
Label
Number of Service Contracts $10K and under
Description

It is recommended for this field to be populated with the total number of services contracts entered into with a value of $10,000 and under. This includes services contracts entered into and subsequently amended in the same calendar year to an amended contract value of $10,000 and under.

Obligation
Required
ID
contracts_service_original_value
Type
money
Label
Service Contracts $10K and under - Original Value
Description

It is recommended for this field to be populated with the value of all service contracts with a value $10,000 and under, at the time of contract entry. This value should be in Canadian currency and include all applicable taxes.

Obligation
Required
ID
contracts_service_amendment_value
Type
money
Label
Service Contracts from -$10K to $10K - Net Amendment Value
Description

It is recommended for this field to be populated with the value of all net amendments to service contracts (that is, all positive and negative amendments) with a value from -$10,000 to $10,000. This value should be in Canadian currency and include all applicable taxes. 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.

Obligation
Required
ID
contract_construction_number_of
Type
int
Label
Number of Construction Contracts $10K and under
Description

It is recommended for this field to be populated with the total number of construction contracts entered into with a value of $10,000 and under. This includes construction contracts entered into and subsequently amended in the same calendar year to an amended contract value of $10,000 and under.

Obligation
Required
ID
contracts_construction_original_value
Type
money
Label
Construction Contracts $10K and under - Original Value
Description

It is recommended for this field to be populated with the value of all construction contracts with a value $10,000 and under, at the time of contract entry. This value should be in Canadian currency and include all applicable taxes.

Obligation
Required
ID
contracts_construction_amendment_value
Type
money
Label
Construction Contracts Amendments from -$10K to $10K - Net Amendment Value
Description

It is recommended for this field to be populated with the value of all net amendments to construction contracts (that is, all positive and negative amendments) with a value from -$10,000 to $10,000. This value should be in Canadian currency and include all applicable taxes. 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.

Obligation
Required
ID
acquisition_card_transactions_number_of
Type
int
Label
Number of Acquisition Card Transactions for all Dollar Values
Description

It is recommended for this field to be populated with the total number of all acquisition card transactions for all dollar values.

Obligation
Required
ID
acquisition_card_transactions_total_value
Type
money
Label
Acquisition Card Transactions for all Dollar Values – Total Value
Description

It is recommended for this field to be populated with the sum of all dollar values for all acquisition card transactions. This value should be in Canadian currency and include all applicable taxes.

Obligation
Required

Additional Information

Created March 7, 2018
Format CSV