Touchstone 4.0 Database Documentation
tRRRR_LOSS_DimExposureAttribute Table
Description
Stores 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.
Properties
Creation Date5/31/2016 9:46 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 ExposureAttributeSID

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

Integer4   
 ExposureAttributeTypeCode

Code that represents the type of exposure attribute. 

For a complete list of codes, see tExposureAttributeType Table.

VarChar10   
 ExposureAttributeName of the exposure attribute.VarChar255  
Objects that depend on tRRRR_LOSS_DimExposureAttribute
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_ByExposureAttribute tabletRRRR_LOSS_ByExposureAttributeTableStores event attribute loss results from a detailed Loss analysis.1
tRRRR_LOSS_ByExposureAttributeGeo tabletRRRR_LOSS_ByExposureAttributeGeoTableStores the exposure’s results by geographic attribute from a detailed loss analysis.  This table is created when the user specifies "Save Loss By Line of Business and Geography" in the analysis Output Options.1
tRRRR_LOSS_ByReinsuranceExposureAttribute tabletRRRR_LOSS_ByReinsuranceExposureAttributeTableStores 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

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.