Stores information about the Multi Peril Crop Insurance Model for the United States.
Default industry premiums are based on government-reported premium amounts. The table also stores user-specified custom percentages that the application can apply to the default industry premiums.
Touchstone Re stores premiums for each of the three MPCI funds (BuyUp, Cat, and Revenue) and applies the premiums and custom percentages during loss analyses that include the MPCI Model for the U.S.
| Creation Date | 4/11/2022 6:17 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| ModelCode | Code that represents a model included in the analysis. | int | 4 | ||||
| ModelVersion | Version of the AIR model. | varchar | 10 | ||||
| GeographySID | Unique system-generated sequential identifier for the U.S. state associated with the premiums. | int | 4 | ||||
| BuyupDefault | Default (government-specified) premium for the BuyUp fund. | float | 9 | ||||
| CatDefault | Default (government-specified) premium for the Cat fund. | float | 9 | ||||
| RevenueDefault | Default (government-specified) premium for the Revenue fund. | float | 9 | ||||
| BuyupCustomPercentage | Percentage of the BuyupDefault value that defines the user-specified premium for the BuyUp fund. | float | 9 | ||||
| CatCustomPercentage | Percentage of the CatDefault value that defines the user-specified premium for the Cat fund. | float | 9 | ||||
| RevenueCustomPercentage | Percentage of the RevenueDefault value that defines the user-specified premium for the Revenue fund. | float | 9 |