Touchstone 4.0 Database Documentation
tRRRR_EC_DimAccumulator Table
Description
Stores information about each accumulation object. tRRRR_EC_ByAccumulator Table refers to the data in this parent table.
Properties
Creation Date5/31/2016 9:46 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   
 AccumulatorTypeCode

Code that represents the type of accumulator. 

For a complete list of codes, see tAccumulatorType Table.

VarChar10   
 GeoMatchLevelCode

Code that represents the level at which geocode match occurred.

For a complete list of codes, see tGeoMatchLevel Table.

VarChar10  
 AccumulatorNameName of the accumulator;  Structure is {DataSet}.{PolicyID}.{LocationID}.VarChar500  
 City
City in which the location resides.
VarChar255  
 Address

Street address for the location within the accumulator zone resides.

VarChar255  
 LatitudeLatitude coordinate for the location.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 LongitudeLongitude coordinate for the location.  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.Numeric9 (9,6)  
 CountryNameName of the country.VarChar255  
 CRESTAName

Name of the CRESTA.

VarChar255  
 AreaNameName of the area.VarChar255  
 SubareaNameName of the subarea.VarChar255  
 PostalCodeName of the postal code.VarChar15  
 Subarea2NameName of the location's subarea2 code.VarChar255  
 EventScaleMagnitude of event analyzed. For example, a hurricane category or the intensity of an earthquake. This value is populated from tSpatialDataset Table.VarChar255  
 EventYearActual event year. This value is populated from tSpatialDataset Table.Integer4  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
Objects that depend on tRRRR_EC_DimAccumulator
 Database ObjectObject TypeDescriptionDep Level
tRRRR_EC_DimSubAccumulator tabletRRRR_EC_DimSubAccumulatorTableStores 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.1
See Also

Related Objects

AIRExposureSummary Database

 

 


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.