Touchstone Re 2022 Database Reference
tReinsuranceCountryPerilYear Table
AIRReference Database : tReinsuranceCountryPerilYear Table
Description
Stores information that enables Touchstone Re to determine the lines of business (LOBs) supported for a given country, peril set, and exposure year.
Properties
Creation Date4/7/2017 4:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2350
Data Space Used96.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

ISO 2-character code for the country.

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key PerilSetCode

Numeric code for the peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
Primary Key YearSIDUnique system-generated sequential identifier for the exposure year.smallint2   
Primary Key SpecVersionInternal identifier for the set of lines of business supported for the country, peril set, and exposure year combination.int4   
See Also

Related Objects

AIRReference 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.