Stores statistical information about the locations (within the portfolio) that are affected by the clash underwriting analysis.
Touchstone 2022 Database Reference
tRRRR_CLSH_LocationByPortfolio 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 | |
|---|---|---|---|---|---|---|---|
 | ExposureDataSourceSID | Unique system-generated sequential identifier for the exposure data source record. | int | 4 | |||
| | LocationSID | Unique system-generated sequential identifier for the location record. For a complete list of records, see tLocation Table. | int | 4 | |||
| | ClashLocationSID | Unique system-generated sequential identifier for the location record used in the clash underwriter analysis. For a complete list of records, see tLocation Table. | int | 4 | |||
| ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | ||||
| LocationID | Unique user-defined identifier for the location. | varchar | 100 |  | |||
| LocationName | Name of 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 | | |||
| ClashTypeCode | Code that represents the type of type of match used for clash underwriting. For a complete list of codes, see tClashType Table. | varchar | 10 | | |||
| ExposureSetName | Name of the exposure set. | varchar | 255 | | |||
| ExposureDataSourceName | Name of the exposure data source. | varchar | 255 | | |||
| 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 | |