tRRRR_LOSS_DimExposureAttribute Table

Description

Stores information about each exposure attribute that:

Touchstone used to aggregate losses
Generated losses during the analysis

Touchstone creates the dimension table for each analysis that included an exposure attribute, such as line of business, as an output option.

For example, if a user saved losses by line of business, the table includes one row for each line of business that generated loss. The ExposureAttributeTypeCode would be ‘ULOB’, and the ExposureAttribute values would contain the names of the lines of business.

Properties

Creation Date	4/11/2022 6:15 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Description	Datatype	Length
ExposureAttributeSID	Unique system-generated sequential identifier for the exposure attribute record.	int	4
ExposureAttributeTypeCode	Code that represents the type of exposure attribute. For a complete list of codes, see tExposureAttributeType Table.	varchar	10
ExposureAttribute	Name of the exposure attribute.	varchar	255

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ExposureAttributeSID

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

int

ExposureAttributeTypeCode

Code that represents the type of exposure attribute.

For a complete list of codes, see tExposureAttributeType Table.

varchar

ExposureAttribute

Name of the exposure attribute.

varchar

255

Objects that depend on tRRRR_LOSS_DimExposureAttribute

Database Object	Object Type	Description	Dep Level
tRRRR_LOSS_ByExposureAttribute	Table	Stores event losses for one detailed loss analysis by exposure attribute.	1
tRRRR_LOSS_ByExposureAttributeGeo	Table	Stores event losses for one detailed loss analysis by each combination of exposure attribute and geography. Touchstone creates one table for each analysis that includes Line of Business and Geography as output options.	1
tRRRR_LOSS_ByExposureAttributeZone	Table	Stores event losses for one detailed loss analysis by each combination of exposure attribute and zone. Touchstone creates one table for each analysis that includes Line of Business and Zone as output options.	1
tRRRR_LOSS_ByReinsuranceExposureAttribute	Table	Stores event losses for one detailed loss analysis by each combination of reinsurance treaty and exposure attribute. Touchstone creates one table for each analysis that included a Geography as an output option and a reinsurance program as an analysis option.	1
tRRRR_LOSS_ByReinsuranceExposureAttributeGeo	Table	Stores event losses for one detailed loss analysis by each combination of reinsurance treaty, exposure attribute, and geography. Touchstone creates one table for each analysis that included a Geography and Line of Business as output options and a reinsurance program as an analysis option.	1

Related Objects

AIRExposureSummary Database