Print all

Annex M: Data sharing agreement — file layout

The Province shall submit the Data Sharing files to Canada by respecting the frequency and the format agreed upon in the Layout Guide described in Section 2.0.

1.0 Canada will inform the Province by February 1^st, 2024 on changes to Section 2.0 for the Province consideration to be implemented in the next Operational Document. Changes can be implemented in the April 1^st, 2024 Operational Document or otherwise agreed by parties, in case where the Province needs more time to implement such changes considered in Section 2.0.

1.1 Layout Guide described in Section 2.0 is not necessarily final as the Province and Canada are still discussing and finalizing certain items, especially those concerning connecting the data from the Province’s old and new IT systems. Items that remain to be finalized are data types and validation rules of the new system, reconciliation of the major measures, and resolving merging issues between files. Canada and the Province will continue discussions to finalize these items for the next Operational Document.
1.2 In the case where Canada identifies differences between data submissions from the Province and Section 2.0 below, the province will not be subject to holdbacks on federal contributions. Canada will engage the Province as required using the established process for data services to confirm and validate the data.
1.3 Additional details on file naming convention, processing rules, submission instructions and formatting instructions for Layout Guide in Section 2.0 can be found in the excel file titled Ontario File Layout.

2.0 Data Submission Layout Guide for AgriInsurance

AgriInsurance — Ontario Layouts Guide

Province abbreviation: ON

File transfer details

Software Platform

Managed Secure File Transfer (MSFT)
All file confirmation and resubmission requests will be communicated through this platform.
Province must notify AAFC if there is a change in the account(s) used for the file transmission.

AAFC account(s)

aafc.actuaries-actuaires.aac@canada.ca
AAFC must notify the province if there is a change in the account(s) used for the file transmission.

Transfer instructions

The file set must be zipped into a single file per transmission.
The zip file name must be FROM_ON_AGRIINS_YYYYMMDD.zip

List of Files

Only the files from the list below will be processed. All other files will not be processed.

Number	Name	Frequency	Encoding
1	ON_####_PRODUCERDATA_UPTO2020_YYYYMMDD.csv	One time submission but could be resent if need be (Crop Years 2018 to 2020) Complete – Could be resent if agreed through the established change management process	ANSI
2	ON_####_PRODUCERDATA_YYYYMMDD.csv	Once or Twice a year for 2021 onwards Summer file: send by August 1st of the current year Winter file: send by April 15th of the next year	ANSI
3	ON_####_CLAIMS_UPTO2020_YYYYMMDD.csv	One time submission but could be resent if need be (Crop Years 2018 to 2020) Complete – Could be resent if agreed through the established change management process	ANSI
4	ON_####_CLAIMS_YYYYMMDD.csv	Send once a year by April 15th of the next year (for 2021 onwards)	ANSI
5	ON_####_PREMIUMRATES_YYYYMMDD.csv	Send once a year by August 1^st of the current year	ANSI
6	ON_HISTORICAL_PRODUCERDATA_YYYYMMDD.csv	One time submission but could be resent if need be (Historical years refer to Crop Years 2003 to 2017) Complete – Could be resent if agreed through the established change management process	ANSI
7	ON_HISTORICAL_CLAIMS_YYYYMMDD.csv	One time submission but could be resent if need be (Historical years refer to Crop Years 2003 to 2017) Complete – Could be resent if agreed through the established change management process	ANSI
8	ON_HISTORICAL_PREMIUMRATES_YYYYMMDD.csv	One time submission but could be resent if need be (Historical years refer to Crop Years 2003 to 2017)	ANSI
9	ON_REFERENCE_PLANTYPES_YYYYMMDD.csv	One time submission but could be resent if need be Complete – Could be resent if agreed through the established change management process	ANSI
10	ON_REFERENCE_CROPCODES_YYYYMMDD.csv	One time submission but could be resent if need be Complete – Could be resent if agreed through the established change management process	ANSI
11	ON_REFERENCE_CLAIMTYPES_YYYYMMDD.csv	One time submission but could be resent if need be Complete – Could be resent if agreed through the established change management process	ANSI

Producer data at the Geotownship level (up to crop year 2020)

ON_####_PRODUCERDATA_UPTO2020_YYYYMMDD.csv
ON_HISTORICAL_PRODUCERDATA_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required	Required Historical
1	Policy Number	Provincial policy or contract number	ENDRS_SERIAL_NO	Alpha (8)	N/A	Yes	Yes
2	Producer ID	Producer unique identifier	CLIENT_ENROL_NO	Alpha (8)	N/A	Yes	Yes
3	Processor ID	Processor unique ID associated with the Commodity	PROC_NO	Alpha (8)	0's will be convereted to NULL	Yes	Yes
4	Crop Year	Year of the AgriInsurance contract	CROP_YR	Number (4)	Crop Year file: Must be from 1970 to current calendar year + 1, and This must also match the #### year in the file name Historical file: This must be from 1970 to maximum historical crop year	Yes	Yes
5	Crop Code	Code associated to a specific crop	CROP_CD	Alpha (3)	Look up the Crop Code in the Crops table	Yes	Yes
6	Crop Description	Description of the crop, this will most of the time be the crop name	crop_name	Alpha (30)	Not to be loaded in National Dataset. This info will be merged in from the Crop Codes table.	Yes	Yes
7	Insured Indicator	Insurance status of the policy	ENDRS_STA_CD	Alpha (3)	Accptable values are: ACT CAN NIL PND	Yes	Yes
8	Business Number	CRA Business Number of the insured producer	BUSINESS_NUMBER	Alpha (9)	N/A	No	No
9	County	County where exposure units are insured	COUNTY	Alpha (15)	N/A	No	No
10	Geotownship	Specific to Ontario, geotownship is similar to county but does not change over time.	GEO_TOWNSHIP	Alpha (19)	N/A	No	No
11	Coverage Type	This is the type of coverage the plan is insured under (for example, Quantity, Hail, Acreage Loss, Spot Loss, etc.)	plan_type	Alpha (33)	Lookup to Plans table	Yes	Yes
12	Unit Price Option	Code associated to the Unit Price Option (for example, High, Low, Variable, Fixed or 100%, 80%, 60%)	PRICE_OPT_TYPE_CD	Alpha (3)	Acceptable values are: FIX FLF	No	No
13	Unit Price	Unit price/Coverage price selected and expressed in Price Unit (for example, dollars per pound)	price	Number (9,4)	Must be greater than or equal to 0	No	No
14	Coverage Level Decimal	Coverage level purchased by the producer (in decimal)	coverage	Number (3,2)	Must be greater than 0 and less than or equal to 1	No	No
15	Liability	Total crop value based on the guaranteed production quantity and the coverage price option chosen for that year (in dollars)	liability	Number (10,2)	Must be greater than 0	No	No
16	Number of Insured Units	Number of exposure units insured	exposure	Number (10,2)	Must be greater than or equal to 0	No	No
17	Exposure Unit Code	Unit that forms the basis of the insurance coverage (ac, ha, trees, etc.)	unit_exposure	Alpha (4)	Acceptable values (case insensitive): ACR COL HIV KG LB TREE VINE %	No	No
18	Probable Yield	Individual probable yield expressed in yield unit (for example, pounds per acre)	Probable_Yield	Number (10,2)	Must be greater than 0	No	No
19	Probable Yield Unit Code	Unit of measure for the probable yield (for example, lbs/ac)	unit_py	Alpha (4)	Acceptable values are: $ $/A BG/A BU/A CW/A KG KG/A LB LB/A LB/H TN/A	No	No
20	Harvested production	Quantity harvested expressed in production unit (for example, pounds)	Harvest_Yield	Number (10,2)	Must be greater than or equal to 0	No	No
21	Production Unit Code	Unit for the production quantity (pounds, kg, etc.)	unit_ay	Alpha (3)	Acceptable values are: $ BAG BU COL CWT KG LB TON	No	No
22	Seeded Date	Actual or last date when the crop was seeded	LAST_SEEDED_DT	Date	Valid date format is: MM/DD/YYYY	No	No
23	Harvested Date	Actual date producer completed harvesting the crop	HARVEST_DT	Date	Valid date format is: MM/DD/YYYY	No	No
24	Reseeding Indicator	Indicates whether or not producer has reseeding benefits	replant	Number (1)	Valid values: 1	No	No
25	Unseeded Acreage Benefit Indicator	Indicates a benefit for acres which cannot be salvaged	USAB	Number (1)	Acceptable values are: 0 1	No	No
26	Nine Percent Rule Indicator	Indicates whether the 9 percent rule is exceeded	Rule9Per	Number (1)	Acceptable values are: 0 1	No	No
27	Risk Splitting	Indicator for risk splitting	RiskSplit	Number (1)	Acceptable values are: 0 or 1	No	No
28	Comprehensive Producer Premiums	Premium paid by the producer (in dollars) at Comprehensive cost share level	Prem_Comp_Prod	Number (10,2)	Must be greater than or equal to 0	No	No
29	Comprehensive Federal Premiums	Premium paid by the federal government (in dollars) at Comprehensive cost share level	Prem_Comp_Fed	Number (10,2)	N/A	No	No
30	Comprehensive Provincial Premiums	Premium paid by the provincial government (in dollars) at Comprehensive cost share level	Prem_Comp_Prov	Number (10,2)	N/A	No	No
31	High Cost Producer Premiums	Premium paid by the producer (in dollars) at High Cost share level	Prem_HC_Prod	Number (10,2)	Must be greater than or equal to 0	No	No
32	High Cost Federal Premiums	Premium paid by the federal government (in dollars) at High Cost share level	Prem_HC_Fed	Number (10,2)	Must be greater than or equal to 0	No	No
33	High Cost Provincial Premiums	Premium paid by the provincial government (in dollars) at High Cost share level	Prem_HC_Prov	Number (10,2)	Must be greater than or equal to 0	No	No
34	Catastrophic Producer Premiums	Premium paid by the producer (in dollars) at Catastrophic cost share level	Prem_Cat_Prod	Number (10,2)	Must be greater than or equal to 0	No	No
35	Catastrophic Federal Premiums	Premium paid by the federal government (in dollars) at Catastrophic cost share level	Prem_Cat_Fed	Number (10,2)	Must be greater than or equal to 0	No	No
36	Catastrophic Provincial Premiums	Premium paid by the provincial government (in dollars) at Catastrophic cost share level	Prem_Cat_Prov	Number (10,2)	Must be greater than or equal to 0	No	No
37	Unseeded Acreage Benefit Premium - Producer	Premium ($) paid by producer for Unseeded Acreage benefit	Prem_USAB_Prod	Number (10,2)	Must be greater than or equal to 0	No	No
38	Unseeded Acreage Benefit Premium - Federal	Premium ($) paid by Federal Government for Unseeded Acreage benefit	Prem_USAB_Fed	Number (10,2)	Must be greater than or equal to 0	No	No
39	Unseeded Acreage Benefit Premium - Province	Premium ($) paid by Province for Unseeded Acreage benefit	Prem_USAB_Prov	Number (10,2)	Must be greater than or equal to 0	No	No
40	Total Premiums	Total premium paid by federal, provincial and producer (in dollars) including all cost share levels	tot_prem	Number (12,2)	Must be greater than 0	No	No
41	Indemnity Amount	Indemnity amount paid during the year to the producer	PAYABLE_CLAIM_AMT	Number (10,2)	Must be greater than or equal to 0	No	No

Producer data at the Geotownship level for Crop Year 2021+

ON_####_PRODUCERDATA_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required
1	Producer ID	Producer unique identifier	Producer ID	Alpha (10)	N/A	Yes
2	Policy Number	Provincial policy or contract number	Policy Number	Alpha (8)	N/A	Yes
3	Processor ID	Processor unique ID associated with the Commodity	Processor ID	Alpha (10)	N/A	No
4	Crop Year	Year of the AgriInsurance contract	Crop Year	Number (4)	Crop Year file: Must be from 2021 to current calendar year + 1, and This must also match the #### year in the file name	Yes
5	Crop Code	Code associated to a specific crop	Crop Code	Alpha (10)	Look up the Crop Code in the Crops table along with Plan Name	Yes
6	Crop Description	Description of the crop, this will most of the time be the crop name	Plan Name	Alpha (50)	N/A	Yes
7	Insured Indicator	Insurance status of the policy	Insured	Alpha (10)	Acceptable values are: Active Cancelled	Yes
8	Business Number	CRA Business Number of the insured producer	Business Number	Alpha (9)	N/A	No
9	County	County where exposure units are insured	County	Alpha (20)	N/A	No
10	Geotownship	Specific to Ontario, geotownship is similar to county but does not change over time.	GEO Township	Alpha (20)	N/A	No
11	Coverage Type	This is the type of coverage the plan is insured under (for example, Quantity, Hail, Acreage Loss, Spot Loss, etc.)	Plan Type	Alpha (40)	Acceptable values are: Acreage Loss Establishment Mortality Production Loss Rainfall Separate Harvest Separate Inbred	Yes
12	Unit Price Option	Code associated to the Unit Price Option (for example, High, Low, Variable, Fixed or 100%, 80%, 60%)	Unit Price Type	Alpha (10)	Acceptable values are: Fixed Float Fresh1 Fresh2 Fresh3 Fresh4 Proc1 Proc2 Proc3	No
13	Unit Price	Unit price/Coverage price selected and expressed in Price Unit (for example, dollars per pound)	Unit Price	Number (9,4)	N/A	No
14	Commodity Status	Indicates whether a commodity is currently being produced and whether it is expected to be insured in the next year.	Commodity Status	Alpha (40)	Acceptable values are: Not Producing - Do Not Renew Not Producing - Renew Producing	Yes
15	Spot Loss / Hail Indicator	Indicator for Spot Loss/Hail Rider Option	Spot Loss / Hail	Number (1)	Acceptable values are: 0 1	Yes
16	Protection Code Description	This is the type of protection for the plan (for example, Multirisk, single peril, protects against hail only, protects agains frost only, etc.)	Peril Option	Alpha (40)	Acceptable values are: Excess Rainfall Frost Only Hail and Frost Only Hail Only Insufficient and Excess Rainfall Insufficient Rainfall Multi Peril	Yes
17	Excess Harvest Period	Time period during which the grower typically begins the first cut for the excess rainfall option	Excess Harvest Period	Alpha (40)	N/A	No
18	Excess Rainfall Threshold	A rainfall threshold amount selected by the customer to determine if a claim will be paid	Excess Rainfall Threshold	Alpha (40)	N/A	No
19	Insufficient Rainfall Coverage Option	Coverage options for the insufficient rainfall coverage	Insufficient Rainfall Weighting	Alpha (40)	N/A	No
20	Coverage Level	Coverage level purchased by the producer (in percentage)	Coverage Level (%)	Number (3)	Must be greater than 0 and less than or equal to 100	No
21	Tree/Vine Loss Coverage Level	Percentage insurance coverage selected by the customer for tree/vine loss	Tree/Vine Loss (%)	Number (5,2)	N/A	No
22	Liability	Total crop value based on the guaranteed production quantity and the coverage price option chosen for that year (in dollars)	Insured Coverage Value	Number (10,2)	N/A	Yes
23	Tree/Vine Loss Guaranteed Value	Guaranteed dollar value of the tree/vine loss coverage	Tree/Vine Loss Guaranteed Value	Number (10,2)	N/A	Yes
24	Number of Insured Units	Number of exposure units insured	Number of Insured Exposure Units	Number (8,2)	N/A	No
25	Exposure Unit Code	Unit that forms the basis of the insurance coverage (ac, ha, trees, etc.)	Exposure Units	Alpha (40)	Acceptable values are: Acres Colonies Hives	No
26	Probable Yield	Individual probable yield expressed in yield unit (for example, pounds per acre)	Probable Yield	Number (10,2)	N/A	No
27	Probable Yield Unit Code	Unit of measure for the probable yield (for example, lbs/ac)	Probable Yield Unit	Alpha (40)	Acceptable values are: 50 lb Bags per Acre Bushels per acre Dollars Dollars per acre Hundred Weight per acre Kilograms per acre Pounds per acre Pounds per hive Tons per acre	No
28	Harvested production	Quantity harvested expressed in production unit (for example, pounds)	Total Harvested Yield	Number (10,2)	Must be greater than or equal to 0	No
29	Production Unit Code	Unit for the production quantity (pounds, kg, etc.)	Yield Unit	Alpha (40)	Acceptable values are: Acres Ames Bags (50 lb) Bushels Colonies Dollars Hundred Weight Imperial Tons Kilograms Pounds	No
30	Seeded Date	Actual or last date when the crop was seeded	Seeding Date	Date	MM/DD/YYYY	No
31	Harvested Date	Actual date producer completed harvesting the crop	Combining Date	Date	MM/DD/YYYY	No
32	Reseeding Indicator	Indicates whether or not producer has reseeding benefits	Benefits Covered (Replant)	Number (1)	Acceptable values are: 0 1	Yes
33	Unseeded Acreage Benefit Indicator	Indicates a benefit for acres which cannot be salvaged	Benefits Covered (Unseeded)	Number (1)	Acceptable values are: 0 1	Yes
34	Nine Percent Rule Indicator	Indicates whether the 9 percent rule is exceeded	9% Rule	Number (1)	Acceptable values are: 0 1	Yes
35	Risk Splitting	Indicator for risk splitting	Risk Splitting	Number (1)	Acceptable values are: 0 1	Yes
36	Surcharge/Discount decimal	Individual surcharge or discount offered to the producer based on his past experience (in decimal)	Surcharge Discount	Number (5,2)	N/A	No
37	Comprehensive Producer Premiums	Premium paid by the producer (in dollars) at Comprehensive cost share level	Producer Premium Comprehensive (Excluding USAB)	Number (10,2)	Must be greater than or equal to 0	No
38	Comprehensive Federal Premiums	Premium paid by the federal government (in dollars) at Comprehensive cost share level	Federal Premium Comprehensive (Excluding USAB)	Number (10,2)	Must be greater than or equal to 0	No
39	Comprehensive Provincial Premiums	Premium paid by the provincial government (in dollars) at Comprehensive cost share level	Provincial Premium Comprehensive (Excluding USAB)	Number (10,2)	Must be greater than or equal to 0	No
40	High Cost Producer Premiums	Premium paid by the producer (in dollars) at High Cost share level	Producer Premium High Cost	Number (10,2)	Must be greater than or equal to 0	No
41	High Cost Federal Premiums	Premium paid by the federal government (in dollars) at High Cost share level	Federal Premium High Cost	Number (10,2)	Must be greater than or equal to 0	No
42	High Cost Provincial Premiums	Premium paid by the provincial government (in dollars) at High Cost share level	Provincial Premium High Cost	Number (10,2)	Must be greater than or equal to 0	No
43	Catastrophic Producer Premiums	Premium paid by the producer (in dollars) at Catastrophic cost share level	Producer Premium Catastrophic	Number (10,2)	Must be greater than or equal to 0	No
44	Catastrophic Federal Premiums	Premium paid by the federal government (in dollars) at Catastrophic cost share level	Federal Premium Catastrophic	Number (10,2)	Must be greater than or equal to 0	No
45	Catastrophic Provincial Premiums	Premium paid by the provincial government (in dollars) at Catastrophic cost share level	Provincial Premium Catastrophic	Number (10,2)	Must be greater than or equal to 0	No
46	Unseeded Acreage Benefit Premium - Producer	Premium ($) paid by producer for Unseeded Acreage benefit	Producer Premium USAB	Number (10,2)	Must be greater than or equal to 0	No
47	Unseeded Acreage Benefit Premium - Federal	Premium ($) paid by Federal Government for Unseeded Acreage benefit	Federal Premium USAB	Number (10,2)	Must be greater than or equal to 0	No
48	Unseeded Acreage Benefit Premium - Province	Premium ($) paid by Province for Unseeded Acreage benefit	Provincial Premium USAB	Number (10,2)	Must be greater than or equal to 0	No
49	Tree/Vine Loss Comprehensive Premiums - Producer	Comprehensive Premium paid by the producer (in dollars) for tree/vine loss coverage	Producer Premium Tree/Vine Loss	Number (10,2)	Must be greater than or equal to 0	No
50	Tree/Vine Loss Comprehensive Premiums - Federal	Comprehensive Premium paid by the federal government (in dollars) for tree/vine loss coverage	Federal Premium Tree/Vine Loss	Number (10,2)	Must be greater than or equal to 0	No
51	Tree/Vine Loss Comprehensive Premiums - Province	Comprehensive Premium paid by the province (in dollars) for tree/vine loss coverage	Provincial Premium Tree/Vine Loss	Number (10,2)	Must be greater than or equal to 0	No
52	Total Premiums	Total premium paid by federal, provincial and producer (in dollars) including all cost share levels	Total Premium	Number (10,2)	Must be greater than or equal to 0	No

Claim data at the Producer and Crop level (up to Crop Year 2020)

ON_####_CLAIMS_UPTO2020_YYYYMMDD.csv
ON_HISTORICAL_CLAIMS_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required	Required Historical
1	Crop Year	Year of the AgriInsurance contract	CROP_YR	Number (4)	Crop Year file: Must be from 1970 to current calendar year + 1, and This must also match the #### year in the file name Historical file: This must be from 1970 to maximum historical crop year	Yes	Yes
2	Policy Number	Provincial policy or contract number	ENDRS_SERIAL_NO	Alpha (8)	N/A	Yes	Yes
3	Producer ID	Producer unique identifier	CLIENT_ENROL_NO	Alpha (8)	N/A	Yes	Yes
4	Crop Code	Code associated to a specific crop	CROP_CD	Alpha (3)	Look up the Crop Code in the Crops table	Yes	Yes
5	Crop Description	Description of the crop, this will most of the time be the crop name	crop_name	Alpha (30)	Not to be loaded in National Dataset. This info will be merged in from the Crop Codes table.	Yes	Yes
6	Indemnity Amount	Indemnity amount paid during the year to the producer	PAYABLE_CLAIM_AMT	Number (10,2)	Must be greater than or equal to 0	Yes	No
7	Number of Indemnity Exposure Units	Number of exposure units that were indemnified	DAMAGE_ACREAGE	Number (6,2)	Must be greater than or equal to 0	Yes	Yes
8	Indemnity Paid Date	The date of the last indemnity payment	Claim_Approved_dt	Date	Valid date format is: MM/DD/YYYY	N/A	N/A
9	Cause of loss description	Description of the Cause of loss	Claim_Peril	Alpha (50)	N/A	No	No
10	Indemnity Type Description	Description of the Type of indemnity (for example, Abandonment, Production, Hail spot loss)	Claim_Type	Alpha (50)	Lookup to Claim Types table	No	No

Claim data at the Producer and Crop level for Crop Year 2021+

ON_####_CLAIMS_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required	Required Historical
1	Producer ID	Producer unique identifier	Producer ID	Alpha (10)	N/A	Yes	N/A
2	Policy Number	Provincial policy or contract number	Policy Number	Alpha (8)	N/A	Yes	N/A
3	Processor ID	Processor unique ID associated with the Commodity (used for ON)	Processor ID	Alpha (10)	N/A	No	N/A
4	Crop Year	Year of the AgriInsurance contract	Crop Year	Number (4)	Crop Year file: Must be from 2021 to current calendar year + 1, and This must also match the #### year in the file name	Yes	N/A
5	Crop Code	Code associated to a specific crop	Crop Code	Alpha (10)	Look up the Crop Code in the Crops table along with Plan Name	Yes	N/A
6	Crop Description	Description of the crop, this will most of the time be the crop name	Plan Name	Alpha (50)	Not to be loaded in National Dataset. This info will be merged in from the Crop Codes table.	Yes	N/A
7	Indemnity Amount	Indemnity amount paid during the year to the producer	Total indemnities	Number (10,2)	Must be greater than or equal to 0	No	N/A
7	Number of Indemnity Exposure Units	Number of exposure units that were indemnified	Acres for cause of loss	Number (6,2)	Must be greater than or equal to 0	No	N/A
8	Indemnity Paid Date	The date of the last indemnity payment	Indemnity payment date	Date	Valid date format is: MM/DD/YYYY	Yes	N/A
9	Cause of loss description	Description of the Cause of loss	Cause of loss	Alpha (50)	Acceptable Values are: Disease Drought Flood Freeze Frost Hail Heat Low Temperature Pest Infestation Precipitation Uninsured Wild Life Wind Winterkill	Yes	N/A
10	Indemnity Type Description	Description of the Type of indemnity (for example, Abandonment, Production, Hail spot loss)	Number of Claims	Alpha (50)	Acceptable Values are: Abandonment By-passed acreage Colony loss Establishment Excess rainfall Hail spot loss Insufficient rainfall Production loss Production loss (separate harvest) Production loss (separate inbred) Replant Salvage Seed cost (by-passed acreage) Seed cost (production) Seed cost (replant) Tree or vine loss Unseeded acreage	Yes	N/A

Premium Rate data at the Crop level

ON_####_PREMIUMRATES_YYYYMMDD.csv
ON_HISTORICAL_PREMIUMRATES_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required	Required Historical
1	Crop Year	Year of the AgriInsurance contract	Crop Year	Number (4)	Crop Year file: Must be from 1970 to current calendar year + 1, and This must also match the #### year in the file name Historical file: This must be from 1970 to maximum historical crop year	Yes	Yes
2	Crop Code	Code associated to a specific crop	Crop Code	Alpha (3)	Lookup to Crops table	Yes	Yes
3	Plan or Crop Name in Certification	Name of the plan or crop as it appears in the actuarial certification or on rate sheets.	Crop Plan	Alpha (60)	N/A	Yes	Yes
4	Unit Price Option Description	Description of the unit price option selected by the producer (for example, High, Low, Variable, Fixed or 100%, 80%, 60%)	Price Option	Alpha (5)	Must be one of the following values: Fixed Float	Yes	Yes
5	Coverage Level	Coverage level purchased by the producer (in percentage)	Coverage Level	Number (5,2)	Must be greater than 0 and less than or equal to 100	Yes	Yes
6	Pure Premium Rate	Pure premium (in percentage)	Calculated Claim Rate (Projected)	Number (4,2)	Must be greater than 0	Yes	Yes
7	Floating Price Factor	Factor applied in the premium rate methodology to account for the additional risk due to variable unit price.	Floating Price Factor	Number (4,3)	Must be greater than 0	Yes	Yes
8	Uncertainty Load Factor	Uncertainty load factor	Uncertainty Margin	Number (4,3)	Must be greater than 0	Yes	Yes
9	Debt Recovery Load Decimal	Debt Recovery Load (in decimal)	DebtLoad	Number (5,4)	N/A	Yes	Yes
10	SSL Decimal	Self-sustainability load (in decimal)	SSL	Number (5,4)	N/A	Yes	Yes
11	Coverage Level Conversion Factor	Factor applied in the premium rate methodology to convert premium rate at base coverage level to other coverage levels.	Conversion Factor for Coverage Level	Number (4,3)	Must be greater than 0	Yes	Yes
12	BBF	Balance Back Factor applied to the crop	ERBB	Number (4,3)	Must be greater than 0	Yes	Yes
13	Exposure Base Adjustment Factor	Factor applied in the premium rate methodology to keep premium rates neutral due to the impact of using a Brix schedule to determine claim prices	Exposure Base Adjustment Factor (Grapes)	Number (4,3)	N/A	No	No
14	Indicated Premium Rate	Premium rate at the crop level including all loads, but before application of cap and individual surcharge/discount for example, loyalty discount (in percent)	Indicated Premium Rate as Percentage of Liability	Number (4,2)	Must be greater than 0	Yes	Yes
15	Guaranteed Production	Production quantity insured based on the probable yield and the exposure unit (in production unit for example, pounds)	Production Guarantee	Number (7,2)	Must be greater than 0	No	No
16	Estimated Unit Price	Estimated Price per production unit, used when calculating premium amount	Premium Price	Number (7,4)	Must be greater than 0	No	No
17	Selected Premium Rate	Premium rate at the crop level including all loads and cap, before application of individual surcharge/discount for example, loyalty discount (in percentage)	Selected Premium Rate	Number (5,2)	Must be greater than 0	Yes	Yes
18	Selected Premium Rate Unit	Unit for the Selected Premium Rate (for example, $ per acre, $ per hive, % of liability)	Selected Premium Rate Unit	Alpha (20)	Must be one of the following values: $ per acre $ per colony $ per hive % of insurable value % of liability	Yes	Yes
19	Apple Salvage Load Decimal	Load applied to premium rate to account for Apple salvage claims (in decimal)	Salvage/WO Factor (Apples)	Number (3,2)	Must be 0 or greater	No	No
20	Apple District Factor	Factor applied to premium rate to account for historical district experience	District_Factor (Apples)	Number (3,2)	Must be greater than 0	No	No
21	Forage Rainfall Price Index Factor	Factor applied to premium rate methodology to account for additional risk due to forage price index	Price Index Factor (Forage Rainfall)	Number (4,3)	Must be greater than 0	No	No
22	Cucumbers Exchange Rate Factor	Factor applied to premium rate to account for conversion from USD to CAD dollars.	Exchange Rate Factor (Cucumbers)	Number (3,2)	Must be greater than 0	No	No
23	Organic Factor	Factor applied to premium rate to account for additional risk due to organic growing practices.	Organic_Load	Number (2,1)	Must be greater than 0	No	No
24	Surcharge/Discount Factor for Quality	Surcharge/Discount Factor for Quality Products	Adjustment Factor for Quality (Natto Soybeans)	Number (3,2)	Must be greater than 0	No	No
25	Grapes and Vines Variety Conversion Factor	Factor applied to premium rate to convert different types of grapes and vines varieties (Hybrid, Labrusca, Vinifera).	Variety Coversion Factor (Grapes & Vines)	Number (3,2)	Must be greater than 0	No	No
26	Hemp Fiber Only Load	Factor applied to premium rate to reflect reduced risk given that only fiber is insured.	Fiber Only Load (Hemp)	Number (5,4)	Must be greater than 0	No	No
27	Total Production Coverage Only Factor	Factor applied to premium rate to reflect risk due to producer's selection to insure all production (applies to vegetables).	TPC Only Factor (Processing Vegetables)	Number (3,2)	Must be greater than 0	No	No
28	Separate Harvest Coverage Load	Load applied to premium rate to reflect risk due to producer's selection to insure each harvest individually (applies to Processing Vegetables).	SHC Load (Processing Vegetables)	Number (3,2)	Must be 0 or greater	No	No
29	Separate Insurance Coverage Load	Load applied to premium rate to reflect risk due to producer's selection to insure each harvest individually (applies to Seed Corn)	SIC Load (Seed Corn)	Number (3,2)	Must be 0 or greater	No	No

Plan Type reference table

ON_REFERENCE_PLANTYPES_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required
1	Coverage Type	This is the type of coverage the plan is insured under (for example, Quantity, Hail, Acreage Loss, Spot Loss, etc.)	plan_type	Alpha (33)	Acceptable values are: Acerage Loss Crop Establishment Livestock Asset Loss Multi Peril Single Peril Trees and Plants Weather Based-Rainfall Standalone	Yes

Field #

AAFC Field Name

Description

ON Field Name

Data Type

Validation

Required

Coverage Type

This is the type of coverage the plan is insured under (for example, Quantity, Hail, Acreage Loss, Spot Loss, etc.)

plan_type

Alpha (33)

Acceptable values are:

Acerage Loss
Crop Establishment
Livestock Asset Loss
Multi Peril
Single Peril
Trees and Plants
Weather Based-Rainfall Standalone

Yes

Crop Code reference table

ON_REFERENCE_CROPCODES_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required
1	Crop Code	Code associated to a specific crop	CROP_CD	Alpha (3)	N/A	Yes
2	Crop Description	Description of the crop, this will most of the time be the crop name	crop_name	Alpha (30)	N/A	Yes

Claim Type reference table

ON_REFERENCE_CLAIMTYPES_YYYYMMDD.csv

Field #	AAFC Field Name	Description	ON Field Name	Data Type	Validation	Required
1	Indemnity Type Description	Description of the Type of indemnity (for example, Abandonment, Production, Hail spot loss)	CLAIM_TYPE	Alpha (50)	N/A	Yes

Updated: February 29, 2024

Published: February 29, 2024