Touchstone 4.0 Database Documentation
tRRRR_CLSH_LocationByContract Table
Description
Stores statistical information about the locations (within the contract) that are affected by the clash underwriting analysis.
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 ContractSIDUnique system-generated sequential identifier for the contract record.Integer4   
Primary Key LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 LocationIDUnique user-defined identifier for the location.VarChar100  
 LocationNameUser-defined name for the location.VarChar100  
 ContractIDUnique user-defined identifier for the contract.VarChar100  
 CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15  
 AreaCode

Area code for the location, if applicable.

For a complete list of codes, see tGeography Table.

VarChar15  
 SubareaCode

Subarea code for the location, if applicable.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalCode

Postal code for the location, if applicable.

For a complete list of codes, see tGeography Table.

VarChar15  
 AddressStreet address 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)  
 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)  
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 UserLineOfBusinessUser's Line of Business.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  
 ReplacementValueDaysCoveredNumber of days covered by the Replacement Value D amountInteger4  
 CurrencyCode

ISO 3-character code for the currency.

For a complete list of codes, see tCurrency Table.

Char3  
 ClashCountNumber of locations within the contract that are affected by clash underwriting.Integer4  
 ClashTRVTotal replacement values for the location.Double9  
 GeoMatchLevelCode

Code that represents the level at which a geocode match may occur.

For a complete list of codes, see tGeoMatchLevel Table.

VarChar10  
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.