1 | Province | - Unique identifier of the Province.
- Data type: character(2)
- Valid values are listed in Annex I.4 — Valid Values by Field
|
2 | Crop Year | - Unique identifier of the Crop Year.
- Data type: numeric(4) - numeric(2)
- yyyy-yy
|
3 | Plan Name | - A province specific name of the plan. This will be used to match to the claims for federal Contribution to determine holdbacks. The name of the Agricultural Product can be used as the plan name, but it does not have to be. Ex. Satellite Imagery, Barley, Grains & Oilseeds.
- Data type: character(40) (maximum 40 characters)
- Note: for uniqueness, case and white space will be ignored.
|
4 | Provincial Initiative Indicator | - An indicator of whether this Plan/Coverage Level is a provincial initiative.
- Data type: numeric(1)
- Valid element values:
- If this plan is not a provincial initiative, set the indicator to No. If this plan is a provincial initiative, set the indicator to Yes, the Cost Share must be set to High-Cost, and the Federal Production Insurance Premiums must be 0.
|
5 | Provincial Ag Product Code | - The Ag Product Code assigned by the Province to the Agricultural Product covered by this plan.
- Data type: character(20)
- If you are adding a new product with a new product code, enter the new code in this field. For an existing product, enter the existing product code in this field.
|
6 | Provincial Ag Product Description | - The Ag Product text description assigned by the Province to this Agricultural Product.
- Data type: character(50)
- If you are adding a new product with a new product code, enter the new description in this field. For an existing product, enter the current description of the product in this field.
|
7 | Plan SubType | - The unique code that represents a subtype of a plan. Ex: Multi-peril, Single Peril, Unseeded acreage. A subtype is either Yield-based or Non-yield based. (A subtype cannot be both)
- Data type: numeric(4)
- Valid values are listed in Annex I.4 - Valid Values by Field
|
8 | Reporting Date | - The date of the statistics being reported.
- Data type: numeric(4) - numeric(2) - numeric(2)
- yyyy-MM-dd
|
9 | Coverage Level | - The Coverage Level percentage for this plan. There should be a separate row for each Coverage Level offered for this plan/ag. Product.
- Data type: decimal(5,2)
- Valid range is 0.01 to 100.00
|
10 | Contracts | - The number of contracts for this plan/ag product/cov. level.
- Data type: numeric(12)
- Valid range is 0 to 999,999,999,999
|
11 | Exposure | - The number of exposure units insured for this plan/ag product/cov level.
- Data type: decimal(14,2)
- Valid range is 1 to 999,999,999,999.99
|
12 | Exposure Unit | - The unit of measurement for this plan.
- Data type: numeric(4)
- Valid values are listed in Annex I.4 - Valid Values by Field
|
13 | Total Coverage | - The total coverage, in dollars, for this plan/ag product/cov level.
- Data type: decimal(14,2)
- Valid range is 0 to 999,999,999,999.99
- For Yield Based Plans: Total Coverage = Exposure X Average Probable Yield X Unit Value X Coverage Level
- For Non-yield-based Coverage plans: Total Coverage = Exposure X Average Production Value X Coverage Level
|
14 | Federal Contributions for Premiums for Comprehensive Cost Share | - The dollar amount that the Federal Government has paid in Contributions for Premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
15 | Provincial Contributions for Premiums for Comprehensive Cost Share | - The dollar amount that the Provincial Government has paid in Contributions for Premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
16 | Producer Premium for Comprehensive Cost Share | - The dollar amount that the Producer has paid in premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
17 | Federal Contributions for Premiums for High-Cost Share | - The dollar amount that the Federal Government has paid in Contributions for Premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
18 | Provincial Contributions for Premiums for High-Cost Share | - The dollar amount that the Provincial Government has paid in Contributions for Premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
19 | Producer Premium for High-Cost Share | - The dollar amount that the Producer has paid in premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
20 | Federal Contributions for Premiums for Catastrophic Cost Share | - The dollar amount that the Federal Government has paid in Contributions for Premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
21 | Provincial Contributions for Premiums for Catastrophic Cost Share | - The dollar amount that the Provincial Government has paid in Contributions for Premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
22 | Producer Premium for Catastrophic Cost Share | - The dollar amount that the Producer has paid in premiums for this plan and cost share level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
23 | Total Premiums | - The sum of the premiums paid across all cost share levels.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
24 | Claims | - The number of claims for this plan/ag product/cov level.
- Data type: numeric(12)
- Valid range 0 to 999,999,999,999
|
25 | Indemnities | - The dollar value of indemnities for this plan/ag product/cov level.
- Data type: decimal(14,2)
- Valid range: 0 to 999,999,999,999.99
|
26 | Value Basis | - The value basis on which the Yield Production Value or Non-yield Production Value is based.
- Data type: numeric(4)
- Valid element values:
- 1 — $/bushel
- 2 — $/pound
- 3 — $/ton
- 4 — $/metric tonne
- 5 — $/kilogram
- 6 — $/CWT
- 7 — $/quart
- 8 — $/pint
- 9 — $/dozen
- 10 — $/plant
- 11 — $/stem
- 12 — $/bag
- 13 — $/Exposure Unit
|
27 | Yield Basis | - The yield basis on which the average probable yield and average actual yield are based.
- Data type: numeric(4)
- Valid element values:
- For Yield Based Plans:
- 1 — bushel
- 2 — pound
- 3 — ton
- 4 — metric tonne
- 5 — kilogram
- 6 — CWT
- 7 — quart
- 8 — pint
- 9 — dozen
- 10 — plant
- 11 — stem
- 12 — bag
- 13 — Exposure Unit
- For Non-yield-based Coverage plans: Not required.
|
28 | Average Probable Yield | - The average probable yield for this plan.
- Data type: decimal(15,6)
- For Yield Based Plans: Valid range is 0 to 999,999,999.999 999
- For Non-yield-based Coverage plans: Not required.
|
29 | Average Actual Yield | - The average actual yield for this plan.
- Data type: decimal(15,6)
- For Yield Based Plans: Valid range is 0 to 999,999,999.999 999
- For Non-yield-based Coverage plans: Not required.
|
30 | Average Yield Production Value | - The average unit value for this plan.
- Data type: decimal(15,6)
- For Yield Based Plans: Valid range is 0 to 999,999,999.999 999
- For Non-yield-based Coverage plans: Not required.
|
31 | Average Non-yield Production Value | - The average Production Value for this plan.
- Data type: decimal(15,6)
- For Yield Based Plans: Not required. For Non-yield-based Coverage plans: Valid range is 0 to 999,999,999.999 999
|