Touchstone 4.0 Database Documentation
tRRRR_EC_DimLocation Table
Description
Stores attributes associated with each location included in the analysis. These attributes are displayed on the user interface along with data from tRRRR_EC_ByLocation Table.
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 ExposureDataSourceSID

Stores attributes associated with each location included in the analysis. These attributes are displayed on the user interface along with data from tRRRR_EC_ByLocation Table.

For a complete list of records, see tDataSource Table.

Integer4   
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4  
 ExposureSetNameName of the exposure set.VarChar255  
 LocationIDUnique user-provided identifier for the location.VarChar100   
 TotalReplacementValueAccumulated replacement values of all Coverages (A, B, C, and D) for the location.Double9  
 RiskCountNumber of risks for the specified location record.Integer4  
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3  
 AIRConstructionCode

AIR-defined construction code.

For a complete list of codes, see tAIRConstruction Table.

SmallInt2  
 AIROccupancyCode

AIR-defined occupancy code.

For a complete list of codes, see tAIROccupancy Table.

SmallInt2  
 CityCity in which the location resides.VarChar255  
 AddressStreet address for the location.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)  
 GeoMatchLevelCode

Code that represents the level at which geocode match occurred.

For a complete list of codes, see tGeoMatchLevel Table.

VarChar10  
 StoriesTotal height of the structure.UnsignedTinyInt1  
 YearBuiltYear the structure was built.SmallInt2  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
 UserDefined1User-defined field 1.VarChar60  
 UserDefined2User-defined field 2.VarChar60  
 UserDefined3User-defined field 3.VarChar60  
 UserDefined4User-defined field 4.VarChar60  
 UserDefined5User-defined field 5.VarChar60  
 EmployeesEmployee count, by location, within the analyzed area.Double9  
 DayShiftEmployeesDay-shift employee count, by location, within the analyzed area.Double9  
 EveningShiftEmployeesEvening-shift employee count, by location, within the analyzed area.Double9  
 NightShiftEmployeesNight-shift employee count, by location, within the analyzed area.Double9  
Objects that depend on tRRRR_EC_DimLocation
 Database ObjectObject TypeDescriptionDep Level
tRRRR_EC_ByLocation tabletRRRR_EC_ByLocationTableStores the results of the Geospatial analysis at the latitude/longitude location-level.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.