AIREvents Database Documentation
TblModel85 Table
AIREventsHistorical Database : TblModel85 Table
Description

Stores detailed information about each 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.

Properties
Creation Date4/11/2019 3:03 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows298
Data Space Used56.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 Year the event occurred.int4  
 Name of the event.varchar255  
 

Code that represents the catalog type.

  • HIST = Historical
  • EDS = Extreme Disaster Scenario
  • RDS = Lloyd's Realistic Disaster Scenarios
  • GOVT = Government
varchar4  
Primary Key Unique system-provided identifier for the event.int4   
 Code that represents the model.int4  
 Identifier of the event.int4  
 Year in the catalog that the event occurred.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

AIREventsHistorical Database