TblModel07_Hist Table

Description

The Multiple-Peril Crop Insurance (MPCI) Model for the United States (Model 07) includes four stochastic catalogs. Each catalog includes the same 10,000 potential yield events (or annual harvests) for each major insured crop in the United States (corn, soybean, wheat, cotton, and rice). However, the catalogs include a different set of stochastic crop price ratios, which are designed to reflect potential price volatility (high, medium, low, and historical) between harvest and planting time.

This table stores detailed information about each simulated event in the historical volatility catalog. Note that the "historical" catalog exhibits price volatilities most similar to historical price volatilities.

This model is only available for use in Touchstone Re or CATRADER.

Properties

Creation Date	9/24/2025 11:39 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	10000
Data Space Used	1,784.00 KB
Index Space Used	8.00 KB

Columns

Column Name	Description	Datatype	Length
EventID	Unique system-provided identifier for the event.	int	4
ModelID	Code that represents the model.	int	4
Event	Identifier for the event.	numeric	9 (18,0)
Year	Year in the catalog that the event occured.	numeric	9 (18,0)
Day	Represents the day/date in a year.	int	4
Event_Info_Corn	Yield ratio and price ratio values for corn. Y = Yield ratio: Harvest Yield / Normal Yield. Normal Yield is derived from a long-term average. P = Price Ratio: Harvest Price/Planting Price, which equals the Projected Price	varchar	50
Event_Info_Soybean	Yield ratio and price ratio values for soybean. Y = Yield ratio: Harvest Yield / Normal Yield. Normal Yield is derived from a long-term average. P = Price Ratio: Harvest Price/Planting Price, which equals the Projected	varchar	50
Event_Info_Wheat	Yield ratio and price ratio values for wheat. Y = Yield ratio: Harvest Yield / Normal Yield. Normal Yield is derived from a long-term average. P = Price Ratio: Harvest Price/Planting Price, which equals the Projected	varchar	50
Event_Info_Cotton	Yield ratio and price ratio values for cotton. Y = Yield ratio: Harvest Yield / Normal Yield. Normal Yield is derived from a long-term average. P = Price Ratio: Harvest Price/Planting Price, which equals the Projected	varchar	50
Event_Info_Rice	Yield ratio and price ratio values for rice. Y = Yield ratio: Harvest Yield / Normal Yield. Normal Yield is derived from a long-term average. P = Price Ratio: Harvest Price/Planting Price, which equals the Projected	varchar	50
Top_Affected_Areas	Area codes affected by the event.	varchar	50
PRF_National_Loss_Fraction	Indicates the Loss Fraction-National Rainfall Index Loss ratio. This event filtering parameter is supported only for Touchstone Re.	decimal	9 (6,3)
ENSO_Index	Each year is assigned a Multivariate ENSO Index for climate variability filtering. This variate indicates filter simulation years by El Nino-Southern oscillation conditions.	decimal	9 (6,3)

Related Objects

AIREvents Database