AIREvents Database Documentation
TblModel87 Table
AIREventsHistorical Database : TblModel87 Table
Description

Stores detailed information about each simulated event in the catalog for the AIR Multiple Peril Crop Insurance Model for India (Model 87).

Crops covered by this model include kharif and rabi.

This model is only available for use in Touchstone Re.

 

Properties
Creation Date8/11/2020 10:16 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows39
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 Represents the actual year when the event occured.numeric9 (18,0)  
 Name/ description of the event.varchar50  
 

Represents the type of catalog that can be used during a Loss analysis.

  • ALERT = ALERT
  • CUST = Custom
  • HIST = Historical Events
  • RDS = Lloyd's Realistic Disaster Scenarios
  • REAL = RealTime
  • STC = Stochastic
  • USER = User Custom Events
varchar50  
 Unique system-provided identifier for the event.numeric9 (18,0)   
 Code that represents the model.numeric9 (18,0)  
 Year in the catalog that the event occured.numeric9 (18,0)  
 Identifier for the event.numeric9 (18,0)  
 Top areas that were most affected by Kharif.varchar50  
 Top areas that were most affected by Rabi.varchar50  
See Also

Related Objects

AIREventsHistorical Database