Touchstone Re 2022 Database Reference
tRRRR_LOSS_ByReTreaty Table
AIRResultRe Database : tRRRR_LOSS_ByReTreaty Table
Description

Stores event losses for one analysis by reinsurance treaty.

Touchstone Re creates one table for each analysis.

Properties
Creation Date4/11/2022 6:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CatalogTypeCode

Code that represents the type of catalog that produced the loss.

For a complete list of codes, see tCatalogType Table.

varchar10   
Primary Key EventIDUnique system-provided identifier of the event that produced the loss.int4   
Primary Key DayID int4   
Primary Key ModelCode

Code that represents the catastrophe model that generated the losses.

For a complete list of codes, see tModel Table.

smallint2   
Primary Key YearIDIdentifier of the year that generated the losses.int4   
Primary Key ReTreatySID

Unique system-generated sequential identifier for the reinsurance treaty.

For a complete list of records, see tReinsuranceTreaty Table.

int4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
 TreatyLoss100ParticipationReinsurance treaty loss at 100% participation.float9  
 TreatyFinalNetLoss100Participation

Reinsurance treaty final net loss at 100% participation.

The final net loss is the event loss less any reinstatement premium that is triggered by the payment of that event loss.

float9  
See Also

Related Objects

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