Touchstone 4.0 Database Documentation
tRRRR_LOSS_ByReinsuranceExposureAttributeGeo Table
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.
Creation Date5/31/2016 9:46 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.

Primary Key ExposureAttributeSID

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

Primary Key GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete set of records, see tGeography 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  
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

AIRExposureSummary Database



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.