Touchstone 2022 Database Reference
tRRRR_LOSS_ByContractByTreaty Table
AIRExposureSummary Database : tRRRR_LOSS_ByContractByTreaty Table
Description

Stores reinsurance treaty losses for a detailed loss analysis by contract.

Touchstone creates one table for each analysis when you select save losses by the "By Treaty" option  in a detailed loss analysis. This option appears only for users of the NGM Technical Preview group.

Properties
Creation Date4/11/2022 6:15 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used16.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 PartitionID int4   
 CatalogTypeCode varchar10   
 EventID int4   
 ModelCode smallint2   
 YearID int4   
 PerilSetCode int4   
 ExposureDataSourceSID int4   
 ContractSID int4   
 ReinsuranceSID int4   
 GroundUpLoss float9  
 GrossLoss float9  
 NetOfPreCATLoss float9  
 RecoveryLoss float9  
 GroundUpSD float9  
 GrossSD float9  
 NetOfPreCATSD float9  
 RecoverySD float9  
 GroundUpMaxLoss float9  
 GrossMaxLoss float9  
 NetOfPreCATMaxLoss float9  
 RecoveryMaxLoss float9  
See Also

Related Objects

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