There is no header row for Wildlife Statistics. Header content will be in the first few fields of the file. Header content will be defaulted from the 1st Detail Row in the file.
This file will be created and uploaded by each province. The file will be comma separated value ASCII format. Binary files will not be accepted. Extra fields on a line will be ignored.
Order | Field | Description |
---|
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 | Calendar Year Paid | - Data type: numeric (4)
- yyyy
|
4 | Provincial Ag Product Code | - The Ag Product code assigned by the Province to the Agricultural Product damaged by wildlife.
- 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.
|
5 | Provincial Ag Product Description | - The Ag Product text description assigned by the Province to the damaged 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.
|
6 | Responsible Wildlife | - The Ag Product text description assigned by the Province to wildlife responsible for the damage.
|
7 | Reporting Date | - The date of the statistics being reported.
- Data type: numeric(4) - numeric(2) - numeric(2)
- yyyy-MM-dd
|
8 | Number of Producers | - The number of producers reporting damage, by Ag Product.
- Data type: numeric(12)
- Valid range is 0 to 999,999,999,999
|
9 | Exposure Unit | - The unit of measurement for this damaged Ag Product.
- Data type: numeric(4)
- Valid values are listed in Annex I.4 - Valid Values by Field
|
10 | Units Damaged | - The total number of exposure units damaged.
- Data type: numeric (12)
- Valid range is 0 to 999,999,999,999
|
11 | Number of Claims | - The number of claims for the damaged Ag Product.
- Data type: numeric (12)
- Valid range is 0 to 999,999,999,999
|
12 | Amount of Compensation | - The dollar amount paid in compensation to the producers for this damaged Ag Product.
- Data type: decimal(14,2)
- Valid range 0 to 999,999,999,999.99
|