Touchstone 4.0 Database Documentation
tRRRR_NONCAT_DimLocation Table
Description
Stores information about locations that experienced loss in a non-catastrophe loss analysis. This dimension table is created when losses are saved by location.
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

Unique system-generated sequential identifier for the exposure data source record.

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   
 LocationIDUnique user-defined identifier for the location.VarChar100  
 AIRConstructionCode

Code that represents the AIR construction code.

For a complete list of codes, see tAIRConstruction Table.

SmallInt2  
 AIROccupancyCode

Code that represents the AIR occupancy code.

For a complete list of codes, see tAIROccupancy Table.

SmallInt2  
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
 GeoMatchLevelCode

Code for the level at which geocode match occurred.

For a complete list of codes, see tGeoMatchLevel Table.

VarChar10  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 AddressAddress for the location.VarChar255  
 CityCity in which the location 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)  
 Longitude

Longitude 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)  
 StoriesTotal height of the structure.SmallInt2  
 YearBuiltYear the structure was built.SmallInt2  
 PremiumPremium amount. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%).Double9  
 GrossAreaTotal area of the location.Double9  
 TerritoryUser-defined territory.VarChar60  
 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  
 ReplacementValueACoverage A replacement value for the location.Double9  
 ReplacementValueBCoverage B replacement value for the location.Double9  
 ReplacementValueCCoverage C replacement value for the location.Double9  
 ReplacementValueDCoverage D replacement value for the location.Double9  
 TotalReplacementValueSum of replacement value for all coverages.Double9  
 InceptionDateInception date of the non-catastrophe contract to which the location belongs. .  Also referred to as the Effective FROM Date.DBTimeStamp4  
 ExpirationDateExpiration date of the non-catastrophe contract to which the location belongs. Also referred to as the Effective TO Date.DBTimeStamp4  
Objects that depend on tRRRR_NONCAT_DimLocation
 Database ObjectObject TypeDescriptionDep Level
tRRRR_NONCAT_ByLocation tabletRRRR_NONCAT_ByLocationTableStores location-level loss results from a non-catastrophe loss analysis.  This table is created when the user specifies "Save Loss by Location" in the analysis Output Options.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.