Touchstone 4.0 Database Documentation
tRRRR_LOSS_ByReinsuranceExposureAttributeGeo Table
Description
Stores 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.
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 CatalogTypeCode

Code that represents the type of catalog used to 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.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.

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

Integer4   
Primary Key ReinsuranceSID

Unique system-generated sequential identifier for the reinsurance record.

For a complete list of records, see tReinsurance Table.

Integer4   
Primary Key ExposureAttributeSID

Unique system-generated sequential identifier for the exposure attribute record.

Integer4   
Primary Key GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete set of records, see tGeography Table.

Integer4   
 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  
Objects that tRRRR_LOSS_ByReinsuranceExposureAttributeGeo depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_DimExposureAttribute tabletRRRR_LOSS_DimExposureAttributeTableStores specific exposure attribute values that were 1) used to aggregate losses and 2) experienced loss in the analysis. For example, if the loss results were saved by line of business, this table will include one row for every line of business that had a loss. The ExposureAttributeTypeCode would be ‘ULOB’, and the ExposureAttribute values would contain the names of the lines of business. This dimension table is created when losses are saved by any exposure attribute, such as Line of Business.1
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

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.