Stores detailed information about each simulated event in the catalog for the Multiple-Peril Crop Insurance (MPCI) Model for the Canada (Model 89).
Crops covered by this model include barley, blueberry, canola, corn, flax, lentil, oat, pea, potato, soybean, and wheat.
| Creation Date | 9/27/2018 11:18 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 40000 |
| Data Space Used | 2,528.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventID | Unique system-provided identifier for the event. | int | 4 | |||
| ModelID | Code that represents the model. | int | 4 |  | |||
| Event | Identifier of the event. | int | 4 | | |||
| Year | Year in the catalog that the event occurred. | int | 4 | | |||
| LossType | Code that represents the type of event:
| varchar | 30 | | |||
| NationalBarleyYield | National yield ratio for barley, which is the ratio of the yield at harvest to the expected yield at planting nationwide. | decimal | 9 (4,1) | | |||
| AlbertaBarleyPrice | Price ratio for barley in Alberta, which is the ratio of the price at harvest to the price at planting. | decimal | 9 (4,1) | | |||
| ManitobaUnseededAcreageFraction | Fraction of Manitoba acreage that is unseeded. | decimal | 9 (4,3) | | |||
| TopAffectedAreas | Area codes that were affected by the event. | varchar | 5 | |