Touchstone 4.0 Database Documentation
tRRRR_LOSS_ByReinsurance Table
Stores 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.
Creation Date5/31/2016 9:45 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CatalogTypeCode

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

For a complete list of codes, see tCatalogType Table.

Primary Key EventIDUnique system-provided identifier of the event that produced the loss.Integer4   
Primary Key ModelCode

Code that represents the AIR model, associated with the event that produced the highest loss in the simulated year.

For a complete list of codes, see tModel Table.

Primary Key YearIDUnique identifier that tracks the scenario. In multi-year catalogs, each scenario actually consists of five modeled years.Integer4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Primary Key ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

 GroundUpLossGround-Up loss value prior to the application of terms. For reinsurance, this is the ground-up loss for the treaty.Double9  
 GrossLossGross loss value, which is the loss after layer-level terms are applied.Double9  
 ReinsuranceRecoveryLossReinsurance Recovery loss value.  Used for reinsurance, this is the loss after applying reinsurance terms, such as ceded percent.Double9  
Objects that tRRRR_LOSS_ByReinsurance depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_DimReinsurance tabletRRRR_LOSS_DimReinsuranceTableThis 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.1
See Also

Related Objects

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.