Touchstone 4.0 Database Documentation
tRRRR_LOSS_DimReinsurance Table
Description
This table stores information about reinsurance treaties that experienced loss in the analysis. More descriptive information about the reinsurance can be found by joining to the tAnalysisReinsurance Table. This dimension table is created when losses are saved by treaty.
Properties
Creation Date5/31/2016 9:45 AM
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 ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

Integer4   
 ReinsuranceTypeCode

Code that represents the reinsurance type. 

For a compete list of codes, see tReinsuranceType Table.

VarChar10   
 ReinsuranceIDUser-defined identifier for the reinsurance treaty.VarChar100  
Objects that depend on tRRRR_LOSS_DimReinsurance
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_ByReinsurance tabletRRRR_LOSS_ByReinsuranceTableStores the reinsurance treaty loss results from a detailed loss analysis.  This table is created when the user specifies any reinsurance type in the analysis Output Options.1
tRRRR_LOSS_ByReinsuranceExposureAttribute tabletRRRR_LOSS_ByReinsuranceExposureAttributeTable

 Stores the reinsurance results by exposure attribute from a detailed loss analysis.  This table is created when the user specifies "Save Loss By Geography" and selects any reinsurance type  in the analysis Output Options.

1
tRRRR_LOSS_ByReinsuranceExposureAttributeGeo tabletRRRR_LOSS_ByReinsuranceExposureAttributeGeoTableStores the reinsurance results by exposure attribute from a detailed loss analysis.  This table is created when the user specifies "Save Loss By Line of Business and Geography" and selects any reinsurance type  in the analysis Output Options.1
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.