AIRGeography Database

Description

The AIRGeography database stores geography-based information used byTouchstone Re.

The following tables apply only to Touchstone, but may appear in your installation for internal purposes:

TblAreaBoundaries
TblAreaCatmap
TblAreaCity
TblAreaCountrySchemePath
TblAreaDistribution_xref
TblAreaExternal
TblAreaExternalInternalXref
TblAreaModel
TblAreaScheme
TblAreaSchemePath
TblAreaWeightType
TblCountryAlias
TblCountryGeoTolerance
TblGridPartitionRef
TblMarineCraftPostalMap
TblMexicoHUEQ_Xref
TblOccAirWeightType_xref
TblProminentLandmarks
TblSourceDefaultTarget_Xref
TblSourceDefaultTargetWc_Xref
TblSourceTargetMap_ANZ
TblSourceTargetMap_BRA
TblSourceTargetMap_CAM
TblSourceTargetMap_CAN
TblSourceTargetMap_CHI
TblSourceTargetMap_EUR
TblSourceTargetMap_IND
TblSourceTargetMap_JAP
TblSourceTargetMap_MEU
TblSourceTargetMap_MEX
TblSourceTargetMap_SAM
TblSourceTargetMap_SEA
TblSourceTargetMap_SEU
TblSourceTargetMap_US
TblSourceTargetMapWC_JAP
tCentroidCheckRequired
tCountryGeoRegionXref
tCountrySupportedGeoLevel
tDisaggregatedGeoLevel
tEncoderMetaData
tRemodeledGeographyXref
tSubareaCentroidToPostal
tUpxAreaSchemeMapping
tUSCity

For more information about the tables, see Touchstone Database Reference on AIR's Developer Zone.

Schema Diagram

You can view a diagram of the AIRGeography database in Schema Diagrams.

Tables

Table	Description
tAlternategeography_mapping_factors	Stores country-level mapping factors for primary and alternate geography records.
tChinaMPCIAreaRatio	Stores values used to disaggregate program data in China from the province (area) or city level to a higher resolution. The values are based on weighted averages developed using AIR's Industry Exposure Database. For example, Touchstone Re uses the ratios supplied in the table to disaggregate premiums, define limits and retentions by county or city, and so on.
tChinaMPCIExposureRatio	Stores values used to disaggregate exposures in China from the province (area) or city level to the county (subarea) level. The values are based on weighted averages developed using AIR's Industry Exposure Database. For example, Touchstone Re may multiply the total exposure for each province, peril, and line of business by the ratios supplied in the table to determine the portion of the exposure to associate with each county. How Touchstone Re computes exposure depends on whether a user excluded any provinces or cities from the computation.
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.
tCountryScheme	Stores the area and subarea schemes supported for each country.
tDbHistory	Stores information about any packages applied to the database.
tDBVersion	Stores the version of the database.
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.
tIndiaCropGeography	Stores general geographic information that Touchstone Re uses to support the Multiple Peril Crop Insurance (MPCI) Model for India. For example, the table stores the areas and subareas that the model supports. The geographic information in the table is specific to the MPCI peril. In the Exposure Set pane of the Touchstone Re user interface, India is listed as two countries: India and India Crop. For India, Touchstone Re uses the geographical information in tGeography Table. For India Crop, Touchstone Re uses the geographic information in tIndiaCropGeography Table.
tIndiaMPCICluster	Stores information about the clusters supported in the Multiple Peril Crop Insurance (MPCI) Model for India. A cluster is a government-defined group of districts created to smooth out the risk to crop insurance providers. The geographic information in the table is specific to the MPCI peril.
tIndiaMPCIClusterSet	Stores information about the cluster sets supported in the Multiple Peril Crop Insurance (MPCI) Model for India. A cluster set is a collection of government-defined group of districts created to smooth out the risk to crop insurance providers. The geographic information in the table is specific to the MPCI peril.
tIndiaMPCIFactors	Stores information about the state-to-district disaggregation factors supported in the Multiple Peril Crop Insurance (MPCI) Model for India. Touchstone Re uses disaggregation factors to disaggregate state- or cluster-level exposure data to the district level.
tIndiaMPCIFactorSet	Stores information about the sets of state-to-district disaggregation factors supported in the Multiple Peril Crop Insurance (MPCI) Model for India. Touchstone Re uses disaggregation factors to disaggregate state- or cluster-level exposure data to the district level.
tReinsuranceGeographyAreaTag	Stores codes that represent the area and subarea associated with each geography.
tReinsuranceGeographyEMM	Stores the validated geographic information that Touchstone Re displays on the user interface for countries that support custom lines of business, models, and event sets.
tReinsuranceInternalCodeMapping	Stores internal area and subarea mappings for each geography.
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.
tUpgradeLog	Stores information about upgrade scripts.