Touchstone Re 2022 Database Reference
tCatBondAttribute Table
AIRUserSetting Database : tCatBondAttribute Table
Description

Stores the attributes that users in each business unit can specify for catastrophe bond reinsurance programs, for example, the sponsors or covered perils.

Currently, Touchstone Re supports only one business unit.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows42
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CatBondAttributeSID

Unique system-generated sequential identifier for the catastrophe bond attribute.

int4   
 BusinessUnitSIDUnique system-generated sequential identifier for the business unit associated with the catastrophe bond attribute.int4   
 CatBondAttributeName

Name of the catastrophe bond attribute.

  • Sponsor
  • Covered Perils / Areas
  • Offering Risk Analysis 1
  • Offering Attach Prob1. %
  • Offering Expected Loss1 %
  • Offering Exhaust Prob1. %
  • Offering Risk Analysis 2
  • Offering Attach Prob2. %
  • Offering Expected Loss2 %
  • Offering Exhaust Prob2. %
  • Rating Agency
  • Modeling Firm
  • Rating
  • Additional Information
  • Calculation Agent
  • Manager
  • Collateral Account
  • Collateral
  • Reference Rate
  • Trigger Type
  • Cover Type
varchar50   
 CatBondAttributeDataTypeData type of the catastrophe bond attribute, for example, varchar or float.varchar8  
 intFieldIdInternal identifier for the catastrophe bond attribute.int4  
See Also

Related Objects

AIRUserSetting Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.