Stores statistical information about the locations (in the contract) that are affected by the clash underwriting analysis.
Touchstone 2022 Database Reference
tRRRR_CLSH_LocationByContract Table
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ContractSID | Unique system-generated sequential identifier for the contract record. | int | 4 | |||
| | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| LocationID | Unique user-defined identifier for the location. | varchar | 100 |  | |||
| LocationName | User-defined name for the location. | varchar | 100 | | |||
| ContractID | Unique user-defined identifier for the contract. | varchar | 100 | | |||
| CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| AreaCode | Area code for the location, if applicable. For a complete list of codes, see tGeography Table | varchar | 15 | | |||
| SubareaCode | Subarea code for the location, if applicable. For a complete list of codes, see tGeography Table | varchar | 15 | | |||
| PostalCode | Postal code for the location, if applicable. For a complete list of codes, see tGeography Table | varchar | 15 | | |||
| Address | Street address for the location. | varchar | 255 | | |||
| City | City in which the location resides. | varchar | 255 | | |||
| Latitude | Latitude coordinate for the location. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (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. | numeric | 9 (9,6) | | |||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 | | |||
| UserLineOfBusiness | User's Line of Business. | varchar | 60 | | |||
| ReplacementValueA | Coverage A replacement value for the location. | float | 9 | | |||
| ReplacementValueB | Coverage B replacement value for the location. | float | 9 | | |||
| ReplacementValueC | Coverage C replacement value for the location. | float | 9 | | |||
| ReplacementValueD | Coverage D replacement value for the location. | float | 9 | | |||
| ReplacementValueDaysCovered | Number of days covered by the Replacement Value D amount | int | 4 | | |||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| ClashCount | Number of locations within the contract that are affected by clash underwriting. | int | 4 | | |||
| ClashTRV | Total replacement values for the location. | float | 9 | | |||
| GeoMatchLevelCode | Code that represents the level at which a geocode match may occur. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 | | |||
| UserGeoMatchLevel | User-specified geocode match level. | varchar | 60 | |