| 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. |
Touchstone Re 2022 Database Reference
dbo Schema