Touchstone 4.0 Database Documentation
tRRRR_EC_DimSubAccumulator Table
Description
Stores information about each sub-accumulation object. A sub-accumulation object is a concentric ring that is assigned a peril-specific damage ratio. All locations that lie within this ring are analyzed together as a single group.
Properties
Creation Date5/31/2016 9:45 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 AccumulatorIDIdentifier for the zones, rings, or polygons in which exposure concentration is accumulated for a specified peril in a Geospatial analysis.Integer4   
Primary Key SubAccumulatorIDUnique system-generated identifier for the single concentric ring in which exposure concentration is accumulated for a specified peril during the Geospatial analysis.Integer4   
Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 RadiusRadius of the sub-accumulator.Single4  
 UnitCode

Code for the unit of measure used to express the radius of the ring.

For a complete list of codes, see tUnit Table.

VarChar10   
 DamageRatioPercent of the total replacement value of a property that is damaged. A damage ratio of 100 represents a total loss.Single4   
 BucketMinUsed for wind speed tracking, it is the minimum value of the bucket range. Numeric9 (19,6)  
 BucketMaxUsed for wind speed tracking, it is the maximum value of the bucket range. Numeric9 (19,6)  
 BucketLabelAttribute of the bucket. For example, wind speed, soil type, elevation.VarChar255  
Objects that tRRRR_EC_DimSubAccumulator depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_EC_DimAccumulator tabletRRRR_EC_DimAccumulatorTableStores information about each accumulation object. tRRRR_EC_ByAccumulator Table refers to the data in this parent table.1
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


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.