AIREvents Database Documentation
TblModel85 Table
AIREvents Database : TblModel85 Table
Description

Stores detailed information about each simulated event in the catalog for the Multiple-Peril Crop Insurance (MPCI) Model for China (Model 85).

Crops covered by this model include corn, cotton, rapeseed, rice, soybean, wheat, corn combined, and forestry.

This model is only available for use in Touchstone Re or CATRADER.
Properties
Creation Date5/16/2014 3:37 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows90000
Data Space Used13,992.00 KB
Index Space Used64.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-provided identifier for the event.int4   
 Code that represents the model.int4  
 Year in the catalog that the event occurred.int4  
 Identifier of the event.int4  
 

Description of the event. 

Note that the description includes both the peril and province(s) affected by the event. 

varchar200  
 

Peril type.

  • Drought
  • Flood
  • Wind
  • Frost/Freeze
  • Fire
  • Flood
varchar25  
 

Total area affected by the event.  Measured in 10,000 mu (note: 15 mu = 1 hectare)

bigint8  
See Also

Related Objects

AIREvents Database