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 Date	4/11/2022 5:46 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 loss results by event attribute from a detailed Loss analysis.	1
tRRRR_LOSS_ByExposureAttributeGeo	Table	Stores 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_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 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	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.	1

Related Objects