| Table | Description |
|---|
| TblAreaBoundaries | Stores information that the application uses to draw states and counties for the Google Earth implementation.
The application also uses the information in the airfn_GeoCodeInBoundaries function to determine whether a user-specified latitude and longitude pair is within the specified area. |
| TblAreaCatmap | Stores valid internal area information. |
| TblAreaCity | Stores city information. |
| TblAreaCountrySchemePath | Stores valid scheme paths for each country. |
| TblAreaDistribution_xref | Stores reference data that the application uses to retrieve the highest weighted areas and to assign values to areas that do not have a sufficiently high weight. |
| TblAreaExternal | Stores valid area information. |
| TblAreaExternalInternalXref | Stores internal identifiers for each geography SID (sequential identifier). |
| TblAreaModel | Stores the mappings between each area and the model that corresponds to the area for the current version of the application. |
| TblAreaScheme | Stores internal area scheme definitions. |
| TblAreaSchemePath | Stores area scheme path definitions and area scheme path chains. |
| TblAreaWeightType | Stores a list of supported area weight types. |
| TblCountryAlias | Stores alias information for each country.
The application uses aliases to resolve country names during the import process. |
| TblCountryGeoTolerance | Stores the tolerance value for each country, which the application uses during the reverse geocoding process.
The tolerance value determines the accuracy of reverse geocoding near an area boundary.
Reverse geocoding is the process of determining the area that corresponds to a user-specified latitude and longitude pair. |
| TblCountryMappingAreacode | Stores valid scheme paths for each country and area code record. |
| TblGridPartitionRef | Stores information about disaggregation partitions. |
| TblMarineCraftPostalMap | Stores information that the application uses to convert inland geocodes to ocean geocodes when the construction class code of an exposure is Marine Craft.
The application uses the information when a user applies the Move Marine Craft Geocodes to Coast option. |
| TblMexicoHUEQ_Xref | Stores the Touchstone CRESTA code that corresponds to each CATRADER CRESTA code for the hurricane and earthquake perils in Mexico.
The application uses the information to export UNICEDE data. |
| TblOccAirWeightType_xref | Stores the weight type that corresponds to each occupancy class code. |
| TblProminentLandmarks | Stores prominent landmarks, which are used only by CATStation. |
| TblSourceDefaultTarget_Xref | Stores information that the application uses in the airsp_EA_PagingPrepare stored procedure to retrieve the highest weighted regions and to assign values to regions that do not have a high enough weight. |
| TblSourceDefaultTargetWc_Xref | Stores information that the application uses in the airsp_EA_PagingPrepare stored procedure to retrieve the highest weighted regions for Workers' Compensation and to assign values to regions that do not have a high enough weight. |
| TblSourceTargetMap_ANZ | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Australia and New Zealand and the weight for each location. |
| TblSourceTargetMap_BRA | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Brazil and the weight for each location. |
| TblSourceTargetMap_CAM | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Central America and the weight for each location. |
| TblSourceTargetMap_CAN | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Canada and the weight for each location. |
| TblSourceTargetMap_CAR | Stores grid identifier and weight type that corresponds to each source code.The table also stores 'look-up' area codes that the application uses for disaggregated locations in Central African Republic (CAR) and the weight for each location. |
| TblSourceTargetMap_CHI | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in China and the weight for each location. |
| TblSourceTargetMap_EUR | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Europe and the weight for each location. |
| TblSourceTargetMap_IND | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in India and the weight for each location. |
| TblSourceTargetMap_JAP | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Japan and the weight for each location. |
| TblSourceTargetMap_MEU | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated mid-European locations and the weight for each location. |
| TblSourceTargetMap_MEX | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Mexico and the weight for each location. |
| TblSourceTargetMap_SAM | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in South America and the weight for each location. |
| TblSourceTargetMap_SEA | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in Southeast Asia and the weight for each location. |
| TblSourceTargetMap_SEU | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated southern-European locations and the weight for each location. |
| TblSourceTargetMap_US | Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in the United States and the weight for each location. |
| TblSourceTargetMapWC_JAP | Stores the grid identifier and weight type that corresponds to each source code. The table is used for workers' compensation and also stores 'look-up' area codes that the application uses for disaggregated locations in Japan and the weight for each location. |
| tCentroidCheckRequired | Stores codes that represent the geographic centriods that the application uses during disaggregation for Japan. |
| tConvertCL2Country | Stores information about the country names used in CLASIC/2. The application uses the information to convert CLASIC/2 country names to Touchstone country names. |
| tCountryGeoRegionXref | Stores the geographic region that corresponds to each country. |
| tCountryScheme | Stores the area and subarea schemes supported for each country. |
| tCountrySupportedGeoLevel | Stores values that indicate the supported geocode match levels for each country. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Stores the version of the database. |
| tDisaggregatedGeoLevel | Stores the geographic resolution that Touchstone disaggregates to for each country. |
| tEncoderMetaData | Reserved for future use. |
| tGeoCountry | Stores values that indicate the type of reverse geocoding that the application supports for each country. |
| tGeography | Stores the post-validation geographical area information that the application displays on the user interface.
After you import exposure data, the application writes the data to TblAreaExternal Table and validates the data using the airsp_ValidateArea stored procedure. Then, the application updates the records in tGeography to match the content of TblAreaExternal. |
| tGeoLabel | Stores country-level geography label information. |
| tGeoRegion | Stores region information. |
| tReinsuranceGeographyTSXref | Stores the geographic reference mapping identifiers between Touchstone and Touchstone Re. |
| tRemodeledGeographyXref | System reference table used to map geographic SIDs. |
| tSIDControl | Contains a list of all SID tables and the last SID value in use for each table. After each insert operation, the SID value will update. |
| tSubareaCentroidToPostal | Stores the mapping between subareas and postal codes in the United States. Touchstone uses the mappings during reverse geocoding operations. |
| tUpgradeLog | Stores information about upgrade scripts. |
| tUpxAreaSchemeMapping | Stores the mapping between UPX area scheme and level types. |
| tUSCity | Stores city information for the United States. |
