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

Stores the number of events associated with each combination of catalog type, model, and year included in a detailed loss analysis. Touchstone generates the table only for analyses that a user transferred to Touchstone Re using the company loss association feature.

During a company loss association, Touchstone writes information about a company loss file (CLF) set to the AIRCompanyLoss database and Touchstone Re associates the CLF set with a Touchstone Re company.

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 a catalog type included in the analysis.

For a complete list of codes, see tCatalogType Table.

varchar10   
Primary Key ModelCode

Code that represents a model included in the analysis.

For a complete list of codes, see tModel Table.

smallint2   
Primary Key YearID

Unique identifier for an event year included in the analysis.

In a multi-year catalog, the YearID represents five modeled years.

int4   
 TotalCountNumber of events included in the analysis and associated with the combination of catalog type, model, and year specified in the row.int4  
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.