Stores geographical attributes and primary risk characteristics for each location.
The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID).
Stores geographical attributes and primary risk characteristics for each location.
The table serves as a reference point between Location and Contract entities.You can identify each location by the location sequential identifier (SID).
Creation Date | 4/12/2021 11:26 AM |
File Group | PRIMARY |
Text File Group | PRIMARY |
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 | |
---|---|---|---|---|---|---|---|
LocationSID | Unique system-generated sequential identifier for the location record. | int | 4 | ||||
ContractSID | Unique system-generated sequential identifier for the contract record. For a complete list of records, see tContract Table. | int | 4 | ||||
ExposureSetSID | Unique system-generated sequential identifier for the exposure set record. For a complete list of records, see tExposureSet Table. | int | 4 | ||||
ISOBIN | Unique ISO Building Identification Number (BIN). | varchar | 14 | ||||
LocationID | Unique user-defined identifier for the location. | varchar | 100 | ||||
LocationName | User-defined name for the location. | varchar | 100 | ||||
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 | ||||
PerDiemRate | Per diem rate for the time element. This value is calculated using the following equation: PerDiemRate = ReplacementValueD / ReplacementValueDaysCovered. Note: When the ReplacementValueDaysCovered value is zero, the PerDiemRate is 365. | float | 9 | ([ReplacementValueD]/case when isnull([ReplacementValueDaysCovered],(0))=(0) then (365.0) else [ReplacementValueDaysCovered] end) | |||
TotalReplacementValue | Total replacement value for all coverage combined. This value is calculated using the following equation: Total Replacement Value = ReplacementValueA+ReplacementValueB+ReplacementValueC+ReplacementValueD(Annualized) | float | 9 | ((([ReplacementValueA]+[ReplacementValueB])+[ReplacementValueC])+case when [ReplacementValueDaysCovered]=(0) then [ReplacementValueD] else ((365.0)*[ReplacementValueD])/[ReplacementValueDaysCovered] end) | |||
Premium | Premium amount. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). | float | 9 | ||||
CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
Territory | User-defined territory. | varchar | 60 | ||||
IsTenant | Indicates whether the location is covered under a tenant policy.
| bit | 1 | ||||
LocationGroup | Name of the location group. | varchar | 60 | ||||
IsPrimaryLocation | Indicates whether the location is the primary location in a location group.
| bit | 1 | ||||
ParentLocationSID | Unique system-generated sequential identifier of the primary location. | int | 4 | ||||
GeographySID | Unique system-generated sequential identifier for the geographic record. | int | 4 | ||||
CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | ||||
CountryName | Name of the country. This name corresponds to the CountryCode field. | varchar | 255 | ||||
CRESTACode | CRESTA code for the location, when applicable. If CRESTA is not applicable for this country,use the AreaCode column. Contact your AIR representative for a complete list of CRESTA codes by country. | varchar | 15 | ||||
CRESTAName | Name of the CRESTA. This name corresponds to the CRESTACode field. | varchar | 255 | ||||
AreaCode | Area code for the location, when applicable. If an Area Code is not applicable for this country, use the CRESTACode column. Contact your AIR representative for a complete list of area codes by country. | varchar | 15 | ||||
AreaName | Name of the area. This name corresponds to the AreaCode field. | varchar | 255 | ||||
SubareaCode | Subarea code for the location. Contact your AIR representative for a complete list of subarea codes by country. | varchar | 15 | ||||
SubareaName | Name of the subarea. This name corresponds to the SubareaCode field. | varchar | 255 | ||||
PostalCode | Postal code for the location. Contact your AIR representative for a complete list of postal codes by country. | varchar | 15 | ||||
PostalName | Name for the postal code. When applicable, this name corresponds to the PostalCode field. | varchar | 255 | ||||
Subarea2Code | Area level code at a finer resolution than postal. This is populated when a country has more than four codes. This field is used by three countries:
Contact your AIR representative for a complete list of subarea2 codes by country. | varchar | 15 | ||||
Subarea2Name | Name for the Subarea2 code. This name corresponds to the Subarea2Code field. | varchar | 255 | ||||
Address | Street address for the location. | varchar | 255 | ||||
City | City in which the location resides. | varchar | 255 | ||||
Zip9 | Nine-digit ZIP Code (ZIP+4 Code) for the location. | varchar | 20 | ||||
Latitude | Latitude coordinate for the city. 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 city. 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) | ||||
ValidatorMatchCode | Code for the level at which the address validation occurred. | varchar | 10 | ||||
EnhancedGeoMatchLevelCode | Code for the level at which the enhanced geocode match occurred. For a complete list of codes, see tEnhancedGeoMatchLevel Table. | varchar | 10 | ||||
GeoMatchLevelCode | Code for the level at which geocode match occurred. For a complete list of codes, see tGeoMatchLevel Table. | varchar | 10 | ||||
GeocoderCode | Code for the utility used to geocode the location. For a complete list of codes, see tGeocoder Table. The premium geocodes obtained by licensing this feature are restricted for use only within Touchstone and cannot be used outside of Touchstone. These are identified by the GeocoderCode = 'Syncsort' column in Touchstone AIRExposure, AIRReference and AIRResults databases. For the Export feature, these premium geocodes are either encrypted or removed during export to comply with these contractual restrictions. Direct extracts of premium geocodes from the Touchstone databases are also contractually prohibited. | varchar | 10 | ||||
InceptionDate | Inception date of the contract. Also referred to as the Effective FROM Date. | date | 8 | ||||
ExpirationDate | Contract expiration date. Also referred to as the Effective TO Date. | date | 8 | ||||
AIROccupancyCode | AIR-defined occupancy code. For a complete list of codes, see tAIROccupancy Table. | smallint | 2 | ||||
AIRConstructionCodeA | AIR-defined construction code for the building (Coverage A). For a complete list of codes, see tAIRConstruction Table. | smallint | 2 | ||||
AIRConstructionCodeB | AIR-defined construction code for the other structures (Coverage B). For a complete list of codes, see tAIRConstruction Table. | smallint | 2 | ||||
UserOccupancySchemeCode | Provider of the occupancy scheme codes (i.e. AIR, ISO). For a complete list of codes, see tUserOccupancyScheme Table. | varchar | 10 | ||||
UserOccupancyCode | User-defined occupancy code. For a complete list of codes, see tUserOccupancy Table. | varchar | 10 | ||||
UserConstructionSchemeCode | Provider of the construction scheme codes (i.e. AIR, RMS). For a complete list of codes, see tUserConstructionScheme Table. | varchar | 10 | ||||
UserConstructionCodeA | User-defined construction code for the building (Coverage A). For a complete list of codes, see tUserConstruction Table. | varchar | 10 | ||||
UserConstructionCodeB | User-defined construction code for other structures (Coverage B). For a complete list of codes, see tUserConstruction Table. | varchar | 10 | ||||
RiskCount | Number of risks for the location record. | int | 4 | ||||
YearBuilt | Year the structure was built. | smallint | 2 | ||||
Stories | Number of stories in the structure. | smallint | 2 | ||||
BuildingHeight | Total height of the structure. | int | 4 | ||||
BuildingHeightUnitCode | Code for the unit of measure used to express the building's height. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
GrossArea | Total area of the structure. | float | 9 | ||||
GrossAreaUnitCode | Code for the unit of measure used to express the building's gross area. For a complete list of codes, see tUnit Table. | varchar | 10 | ||||
GeoPoint | SQL spatial attribute for the latitude and longitude coordinates. | geography | 0 | ||||
EnteredDate | Date and time when the contract was created. | datetime | 4 | (getutcdate()) | |||
EditedDate | Date and time when the contract was last modified. | datetime | 4 | (getutcdate()) | |||
AuditStatusCode | Code that represents the status of exposure data import. For a complete list of codes, see tAuditStatus Table. | int | 4 | ||||
StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
UserDefined1 | User-defined field 1. | varchar | 60 | ||||
UserDefined2 | User-defined field 2. | varchar | 60 | ||||
UserDefined3 | User-defined field 3. | varchar | 60 | ||||
UserDefined4 | User-defined field 4. | varchar | 60 | ||||
UserDefined5 | User-defined field 5. | varchar | 60 | ||||
RowVersion | Used for version stamping. | timestamp | 8 | ||||
NonCATGroundUpLoss | Ground-Up loss value prior to the application of Non-CAT policy terms. | float | 9 | ||||
UserGeoMatchLevel | User-specified geocode match level. | varchar | 60 | ||||
DamageFunctionID | User-specified identifier for the damage function. | varchar | 60 | ||||
GeocoderAccountId | Identifier for the geocode account used for premium geocoding through Syncsort. | nvarchar | 50 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
tLayerConditionLocationXref | Table | System reference table used to map the location to the layer condition. | 1 | |
tLocFeature | Table | Stores detailed building information for each location. The information includes secondary risk characteristics, such as the building shape and glass type. | 1 | |
tLocOffshore | Table | Stores risk characteristics for each offshore location. | 1 | |
tLocStepFunctionXref | Table | System reference table used to determine the step functions that are associated with a location. | 1 | |
tLocTerm | Table | Stores information about location terms. | 1 | |
tLocWC | Table | Stores information about the workers' compensation details for the location. | 1 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
tContract | Table | Stores records for primary insurance policies. | 1 |