Touchstone 2022 Database Reference
tRRRR_EC_MappingLocationSubAccumulator Table
AIRExposureSummary Database : tRRRR_EC_MappingLocationSubAccumulator Table
Description
Stores the mapping between the locations and sub-accumulators included in a geospatial analysis. You can join this table to the tRRRR_EC_ByLocation Table and tRRRR_EC_DimSubAccumulator Table to view losses by location and sub-accumulator.
Properties
Creation Date4/11/2022 6:15 PM
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
 ExposureDataSourceSID

Unqiue system-generated sequential identifier for the location record.

For a complete list of records, see tDataSource Table.

int4   
 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

int4   
 AccumulatorSIDUnique system-generated identifier for the zones, rings, or polygons in which exposure concentration is accumulated for a specified peril in a Geospatial analysis.int4   
 PerilSetCode

Numeric code for the peril or set of perils included in the analysis.

For a complete list of codes, see tPerilSet Table.

int4   
 SubAccumulatorSIDUnique system-generated identifier for the single concentric ring in which exposure concentration is accumulated for a specified peril during the analysis.int4   
 DistanceFromCenter real4   
See Also

Related Objects

AIRExposureSummary Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.