tUSMPCIIndPremium Table

Description

Stores Multiple Peril Crop Insurance (MPCI) industry premiums associated with each state in the United States (U.S.) for each supported version of the MPCI Model for the U.S.

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.

Properties

Creation Date	4/4/2022 3:02 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	192
Data Space Used	24.00 KB
Index Space Used	16.00 KB

Columns

Column Name	Description	Datatype	Length
USMPCIIndPremiumSID	Unique system-generated sequential identifier for the premium record.	int	4
BusinessUnitSID	Unique system-generated sequential identifier for the business unit associated with the premium record.	int	4
USMPCITypeCode	Code that indicates whether the premium record represents the default (government-assigned) premium or a user-specified premium. For a complete list of codes, see tUSMPCIType Table.	tinyint	1
ModelCode	Code that represents the AIR model associated with the group assignment.	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. For a complete list of codes, see tGeography Table.	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

Related Objects

AIRUserSetting Database