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	10/8/2018 11:04 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	10000
Data Space Used	3,400.00 KB
Index Space Used	16.00 KB

Columns

Column Name	Description	Datatype	Length	Default
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)
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
Day	Represents the day/date in a year.	int	4	((1))

Related Objects

AIREvents Database