tRRRR_LOSS_DimLocation Table

Description

Stores information about locations that experienced loss in the analysis. This dimension table is created when losses are saved by location.

The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference, and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited.

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
ExposureDataSourceSID	Unique system-generated sequential identifier for the exposure data source record. For a complete list of records, see tDataSource Table.	int	4
LocationSID	Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table.	int	4
ContractSID	Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table.	int	4
ExposureSetName	Name of the exposure set.	varchar	255
LocationID	Unique user-provided identifier for the location.	varchar	100
GeographySID	Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table.	int	4
TotalReplacementValue	Sum of replacement values for all Coverages.	float	9
CurrencyCode	ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table.	char	3
GeoMatchLevelCode	Code for the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table.	varchar	10
AIROccupancyCode	Code that represents the AIR occupancy code. For a complete list of codes, see tAIROccupancy Table.	smallint	2
AIRConstructionCode	Code that represents the AIR construction code. For a complete list of codes, see tAIRConstruction Table.	smallint	2
Stories	Total number of stories in the location.	smallint	2
YearBuilt	Year the building was built.	smallint	2
City	City in which the location resides.	varchar	255
Address	Address for the location.	varchar	255
Latitude	Latitude coordinate for the city. Values will be positive for locations north of the equator and negative south of the equator.	numeric	9 (9,6)
Longitude	Longitude coordinate for the city. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.	numeric	9 (9,6)
ReplacementValueA	Coverage A replacement value for the location.	float	9
ReplacementValueB	Coverage B replacement value for the location.	float	9
ReplacementValueC	Coverage C replacement value for the location.	float	9
ReplacementValueD	Coverage D replacement value for the location.	float	9
ReplacementValueDaysCovered	Number of days covered by the Replacement Value D amount.	int	4
Premium	Premium amount. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%).	float	9
Territory	User-defined territory.	varchar	60
InceptionDate	Inception date of the contract. Also referred to as the Effective FROM Date.	date	8
ExpirationDate	Contract expiration date. Also referred to as the Effective TO Date.	date	8
GrossArea	Total area of the structure.	float	9
UserDefined1	User-defined field 1.	varchar	60
UserDefined2	User-defined field 2.	varchar	60
UserDefined3	User-defined field 3.	varchar	60
UserDefined4	User-defined field 4.	varchar	60
UserDefined5	User-defined field 5.	varchar	60
ExposureCurrencyCode	ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table.	char	3
UserGeoMatchLevel	User-specified geocode match level.	varchar	60
GeocoderCode	Code for the utility used to geocode the location. For a complete list of codes, see tGeocoder Table.	varchar	10
GeocoderAccountId	Identifier for the geocode account used for premium geocoding through Syncsort.	nvarchar	50
DamageFunctionID	User-specified identifier for the damage function.	varchar	60

Objects that depend on tRRRR_LOSS_DimLocation

	Database Object	Object Type	Description	Dep Level
	tRRRR_LOSS_ByLocation	Table	Stores location-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Location" in the analysis Output Options.	1
	tRRRR_LOSS_ByLocationSummary	Table	Stores summary losses for one detailed loss analysis by location. Touchstone creates one table for each analysis that includes Location Summary as an output option.	1

Database Object

Object Type

Description

Dep Level

tRRRR_LOSS_ByLocation

Table

Stores location-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Location" in the analysis Output Options.

tRRRR_LOSS_ByLocationSummary

Table

Stores summary losses for one detailed loss analysis by location.

Touchstone creates one table for each analysis that includes Location Summary as an output option.

Objects that tRRRR_LOSS_DimLocation depends on

	Database Object	Object Type	Description	Dep Level
	tRRRR_LOSS_DimExposureDataSource	Table	Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis.	1

Related Objects