| Table | Description |
|---|
| tAccumulatorType | Stores the filter criteria used during geospatial analyses to accumulate values for all properties in the exposure data. |
| tAccumulatorTypeSpatialDataSetTypeXref | System reference table that stores the data set information that corresponds to event and boundary filter criteria used during geospatial analyses. |
| tActivityFailureAction | Stores the options that define how HPC responds to processing parent activities when child activities fail. |
| tActivityOutputAggregation | Reserved for future use. |
| tActivityOutputStatus | Reserved for future use. |
| tActivityResourceType | Stores the location of resources used to complete activities, for example, the cloud or on premises. |
| tActivityResultStatus | Stores codes used by the Activity Monitor to identify the status of each activity that the application completes.
If an activity has unexpected results, the activity result status code identifies the cause. |
| tActivityStage | Stores codes used by the Activity Monitor to identify the current stage of an activity. |
| tActivityStatus | Stores codes used by the Activity Monitor to identify the current status of activities in the Process stage. |
| tActivityTargetState | Stores codes that indicate whether a target, for example, an exposure set, is locked for edit by an activity. |
| tActivityTargetType | Stores codes that represent types of activity targets. |
| tActivityType | Stores codes that represent types of activities. |
| tActivityTypeActivityStageXref | System reference table used by the Activity Monitor to determine the current stage of the activity. |
| tActivityTypeRestrictedActivityTypeXref | System reference table that stores the activities types that are restricted for Azure cloud provisioning/deprovisioning. |
| tAggregateDeductibleType | Stores codes that represent types of aggregate deductibles. |
| tAggregateLimitType | Stores codes that represent types of aggregate limits. |
| tAIRConstOccRegion | Stores codes that represent geographic regions. |
| tAIRConstOccRegionConstXref | System reference table that stores the AIR construction class codes supported for each geographic region. |
| tAIRConstOccRegionCountryXref | System reference table that stores the countries supported for each region. |
| tAIRConstOccRegionOccXref | System reference table that stores the AIR occupancy class codes supported for each region. |
| tAIRConstruction | Stores information about AIR construction class codes. |
| tAIRFloodZoneCategory | Stores information about AIR flood zones. |
| tAIRLineOfBusiness | Defines the AIR Line of Business types. |
| tAIROccConSpecial | Stores special AIR construction and occupancy class codes for each region. |
| tAIROccConSpecialType | Stores the definitions of the terms CON and OCC used in tAIROccConSpecial Table. |
| tAIROccupancy | Stores information about AIR occupancy class codes. |
| tAIROccupancyRegionXref | System reference table that stores the geography and line of business associated with each AIR occupancy class code. |
| tAIROccupancyWeightType | Stores the weight type codes used during disaggregation. |
| tAIROccupancyWeightTypeXref | System reference table used to determine the weight type for each occupancy code. |
| tAIRProduct | Stores AIR software application (product) names. |
| tAnalysisStatus | Stores analysis statuses, which are used by the analysis engine. |
| tAnalysisTargetRole | Stores codes that represent the roles of marginal impact analysis targets. |
| tAnalysisTargetType | Stores types of analysis targets.
An analysis target is the data to analyze, for example, an exposure view. |
| tAnalysisType | Stores the analysis types available in the application. |
| tAppurtenantStructure | Stores codes that represent types of appurtenant structures.
The codes are used in the tLocFeature Table. |
| tAuditStatus | System reference table used internally by the loss and geospatial analysis engines to determine the status of a location in the location table. |
| tAveragePropertyOption | Stores codes that indicate whether average properties are used during loss analyses. |
| tBaseFloodElevation | Stores the possible measurement ranges used to define the elevation, in feet above sea level, for the base flood options. |
| tBasementFinishType | Stores codes that indicate whether a basement is finished.
The codes are used in the tLocFeature Table. |
| tBrickVeneer | Stores codes that indicate the percentage of a building that is constructed of brick veneer.
The codes are used in the tLocFeature Table. |
| tBuildingCondition | Stores codes that indicate the condition of a building.
The codes are used in the tLocFeature Table. |
| tBuildingExteriorOpening | Stores codes that indicate the percentage of a building's exterior walls that comprise openings. Openings include windows and doors.
The codes are used in the tLocFeature Table. |
| tBuildingShape | Stores codes that indicate the shape of a building.
The codes are used in the tLocFeature Table. |
| tBusinessUnitType | Stores the types of business units supported by the application. |
| tCaliforniaDOIZone | Stores the earthquake zones defined by the California Department of Insurance (DOI). |
| tCargoPacking | Stores information about the cargo packing details. |
| tCargoProtection | Stores information about the protection of cargo package. |
| tCascadeDeleteOption | Stores codes that represent the type of data to delete during a delete operation. |
| tCatalogModelXref | System reference table that stores the mappings between model codes and catalog model codes. |
| tCatalogTagType | Stores possible subtypes of event catalogs.
For example, a catalog tag type code can indicate that an event catalog is time dependent. |
| tCatalogType | Stores the possible catalogs that can be used during a Loss analysis. |
| tCatalogTypeFlagType | Reserved for future use. |
| tChimney | Stores codes used to identify whether a building has a chimney, and if so, the chimney height.
The codes are used in the tLocFeature Table. |
| tClashType | Stores information about match types used for clash underwriting. |
| tCLFIndustryLOB | Stores the industry line of business data by country used by Touchstone to generate company loss files (CLFs).
Industry LOB data appears in a CLF in the following order: country, peril, and INF version. |
| tCLFINFVersion | Stores information that Touchstone uses to define the INF version during a company loss file export. |
| tColdFormedTube | Stores codes that indicate the presence of cold-formed tubes in a building.
The codes are used in the tLocFeature Table. |
| tColumnBasement | Stores codes that indicate the type of connection between the columns and basement in a building with stell-reinforced concrete (SRC) or steel construction.
The codes are used in the tLocFeature Table.
|
| tCompanySize | Stores codes that indicate the size of a company associated with an offshore location.
The codes are used in the tLocFeature Table. |
| tComponent | Stores custom models that are integrated into Touchstone. |
| tContainerType | Stores codes that represent the types of data containers supported by Touchstone and Touchstone Re. |
| tContentDamageability | Stores the relative damageability of the contents exposed to flooding for the chosen occupancy. |
| tContentVulnerability | Stores codes that indicate the relative vulnerability of contents in a building.
The codes are used in the tLocFeature Table. |
| tContractType | Stores the supported contract types. |
| tConvertCL2CatalogType | Stores information about the catalog types used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 catalog types to Touchstone catalog types. |
| tConvertCL2ConditionDeductibleType | Stores information about the deductible types used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 deductible types to Touchstone deductible types. |
| tConvertCL2ConditionLimitType | Stores information about the limit types used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 limit types to Touchstone limit types. |
| tConvertCL2ContractType | Stores information about the contract types used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 contract types to Touchstone contract types. |
| tConvertCL2Country | Stores information about the country names used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 country names to Touchstone country names. |
| tConvertCL2Currency | Stores information about the currencies used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 currencies to Touchstone currencies. |
| tConvertCL2GeoLevel | Stores information about the geocode levels used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 geocode levels to Touchstone geocode levels. |
| tConvertCL2GeoMatchLevel | Stores information about the geocode match levels used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 geocode match levels to Touchstone geocode match levels. |
| tConvertCL2LOBCategory | Stores information about the lines of business (LOBs) used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 LOBs to Touchstone LOBs. |
| tConvertCL2LocTermsDeductibleType | Stores information about the location deductibles used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 location deductibles to Touchstone location deductibles. |
| tConvertCL2LocTermsLimitType | Stores information about the location limits used in CLASIC/2.
Touchstone uses the information to convert CLASIC/2 location limits to Touchstone location limits. |
| tConvertCL2SubmitStatus | Stores information about contract submittal statuses used in CLASIC/2.
Touchstone uses the information to to convert CLASIC/2 statuses to Touchstone statuses. |
| tConvertCSVReinsTargetType | Stores information that Touchstone uses to convert reinsurance target data in comma-separated values (CSV) files to a format supported by Touchstone. |
| tConvertCSVReinsuranceType | Stores information that Touchstone uses to convert reinsurance type data in comma-separated values (CSV) files to a format supported by Touchstone. |
| tConvertCTCurrency | Stores information about the currencies used in CATRADER.
Touchstone uses the information to convert CATRADER currencies to Touchstone currencies. |
| tConvertEDCConstruction | Stores information about the construction class codes used in the exposure data conversion tool (EDC).
Touchstone uses the information to convert RMS construction class codes to Touchstone construction class codes. |
| tConvertEDCCountry | Stores information about the country codes used in the exposure data conversion tool (EDC).
Touchstone uses the information to convert RMS country codes to Touchstone country codes. |
| tConvertEDCCountrySpecificConstruction | Stores information about region-specific construction class codes used in the exposure data conversion tool (EDC).
Touchstone uses the information to convert RMS construction class codes to Touchstone construction class codes. |
| tConvertEDCCountrySpecificOccupancy | Stores information about region-specific occupancy class codes used in the exposure data conversion tool (EDC).
Touchstone uses the information to convert RMS occupancy class codes to Touchstone occupancy class codes. |
| tConvertEDCOccupancy | Stores information about the occupancy class codes used in the exposure data conversion tool (EDC).
Touchstone uses the information to convert RMS occupancy class codes to Touchstone occupancy class codes. |
| tConvertEDCPeril | Stores information about peril codes used in the exposure data conversion tool (EDC).
Touchstone uses the information to convert RMS peril codes to Touchstone peril codes. |
| tConvertISOConstruction | Stores information about ISO construction class codes.
Touchstone uses the information to convert ISO construction class codes to Touchstone construction class codes. |
| tConvertISOOccupancy | Stores information about ISO occupancy class codes.
Touchstone uses the information to convert ISO occupancy class codes to Touchstone occupancy class codes. |
| tConvertUPXPerilSet | Stores information about peril codes supported in UPX files.
Touchstone uses the information to convert peril codes supported in UPX files to peril codes supported in Touchstone. |
| tCopyStatus | Stores the status options for when a user copies or moves contracts to an exposure set. |
| tCountry | Stores the supported country codes and indicates whether each country is modeled and an offshore location. |
| tCountryCurrencyXref | System reference table used to map currencies to countries when exporting company loss files (CLFs) and UNICEDE/2 files for CATRADER. |
| tCountryIndustryLOBXref | System reference table used to map the Industry Line of Business to a county. |
| tCountryPerilXref | System reference table used to determine the perils that are associated with a country. |
| tCoverage | Stores the possible coverage types. |
| tCurrency | Stores AIR currency codes. |
| tCurrencyMapping | Stores mappings between previously and currently supported currency codes. |
| tCustomFloodSOPType | Stores codes that represent types of custom standards of protection for flood.
A custom standard of protection is a user-specified level of flood protection that overrides the AIR-defined level of protection during analyses. Flood protection includes levees, dikes, and flood walls.
The codes are used in the tLocFeature Table. |
| tCustomFloodZone | Stores codes that represent user-specified flood zones.
The codes are used in the tLocFeature Table. |
| tDamagingSnowFrequency | Stores the possible frequencies of snowfalls that damage property.
The frequencies are used during hazard analyses. |
| tDamagingWindFrequency | Stores the possible frequencies of wind that damage property.
The frequencies are used during hazard analyses. |
| tDataSourceType | Stores codes that represent types of Touchstone data sources. |
| tDateFormat | Stores date formats used to export comma-separated values (CSV) files. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Defines the version of the database. |
| tDeductibleOption | Stores information about the types of loss to that you can apply deductibles to. |
| tDeductibleType | Stores codes that represent types of location, layer, and sublimit deductibles. |
| tDemandSurgeOption | Stores codes that indicate whether an analysis includes demand surge. |
| tDemandSurgeRegion | Stores the regions details to which demand surge can be applied during an analysis. |
| tDemandSurgeRegionGeo | Stores the country and area codes that correspond to each demand surge region. |
| tDQCountry | Stores country (and FIPS) information for use during a Data Quality analysis. |
| tDQRuleSetType | Stores the primary rule sets that can be applied during a Data Quality analysis. |
| tDQRuleSubType | Stores the specialized rules (sub rules) that can be applied during a Data Quality analysis. These rules are designed to only affect specific exposure data, such as Employee Count or Secondary Risk Characteristics. |
| tDQRuleTier | Stores the Data Quality rule hierarchy. Each rule belongs to a tier, this table aids in displaying the rule hierarchy on the user interface. |
| tDQScoringPerilOption | Stores information regarding which peril to use when determining a score during a Data Quality analysis. |
| tDQValueClass | Stores information used to identify augmentation location fields. |
| tEffectiveDistanceToCoast | Stores the possible options to measure the distance between the exposure and the closest water body, which includes oceans, very large lakes, and very large rivers. Used during the Hazard analysis. |
| tElevation | Stores the possible measurement ranges used to define the elevation of the exposure in relation to the mean sea level. |
| tEnhancedGeoMatchLevel | Stores the supported geocode match levels.
For more information about geocoding in Touchstone, refer Using Geocoding on AIR's Client Portal. The document describes how to use the EnhancedGeoMatchlevelCode and GeoMatchLevelCode to understand the quality of the geocoding results. |
| tEPAnnualType | Stores the possible types of annual EP curves that can be generated in Touchstone. |
| tEPCurveType | Stores the possible types of EP curve that can be generated in Touchstone. |
| tEPTargetType | Stores the possible exposure targets that the application can display EP curves for. |
| tEPType | Stores the possible information that can be displayed in the EP curve (i.e. Exceedance Probability curve or Tail Value at Risk curve). |
| tEquipment | Stores codes that indicate the quality of the bracing of a building.
The codes are used in the tLocFeature Table. |
| tEventFilterHawaiiCondition | Stores information for the types of event filters that can be applied to perils in Hawaii. |
| tEventFilterRuleAttribute | Stores information for the types of event filters that can be applied. |
| tEventFilterTerrorismWeaponType | Stores information regarding weapon types for the terrorism peril. |
| tEventSetPerilExclusion | Stores information regarding the exclusion of a peril set in a specific event set This table is used when writing combined perils for all models in an event set to the AIRUserSetting Database. |
| tEventSetType | Stores the possible event sets types that are available in Touchstone. |
| tExecutionPlan | Table used internally by SQL Server. When a user deletes data from Touchstone, this table identifies which information is to be deleted. |
| tExportStatus | Indicates the status of result and exposure export activities. |
| tExportTargetType | Stores the possible information that can be exported in Touchstone. Used to define error codes in dbo.tValidationError Table. |
| tExportType | Stores the possible types of exports that can be performed in Touchstone |
| tExposureAttributeType | Stores the possible types of exposure attributes used for the Loss analysis results options. |
| tExposureTargetType | Stores the possible exposure types that are valid for import. These codes are used for import validation error messaging, see tValidationError Table. |
| tExternalDoor | Stores codes that represent types of exterior doors.
The codes are used in the tLocFeature Table. |
| tFacultativeOption | Stores the possible way that a facultative policy is applied in regards to other reinsurance treaties. |
| tFEMAFloodZone | Stores the possible Federal Emergency Management Agency (FEMA) flood zones. Used during the Hazard analysis. |
| tFilterAttribute | Stores the possible filters that are available for the activities |
| tFilterAttributeActivityTypeXref | System reference table used to determine the possible activities that can be applied to specific filter attributes. |
| tFilterType | Stores the possible filter types that can be applied in exposure view filtering. |
| tFinancialPerspective | Stores the possible financial perspectives. |
| tFIRMCompliance | Stores codes that indicate whether a building is in compliance with the FEMA flood zone requirements in design and construction.
The codes are used in the tLocFeature Table.
|
| tFloodSource | Stores the sources of the flood data. Used during the Hazard analysis. |
| tFloodZone | Stores the possible flood zone categories. Used during the Hazard analysis. |
| tFoundation | Stores codes that represent types of building foundations.
The codes are used in the tLocFeature Table. |
| tFoundationConnection | Stores codes that represent types of connections between a structure and foundation.
The codes are used in the tLocFeature Table. |
| tFWMExposureArea | Stores the possible Florida Wind Mitigation (FWM) exposure areas. Used during the Hazard analysis. |
| tFWMExposureArea2010 | Stores the possible Florida Wind Mitigation (FWM) 2010 exposure areas. Used during the Hazard analysis. |
| tFWMWindSpeedRegion | Stores the possible Florida Wind Mitigation (FWM) wind speed regions. This is used to determine whether locations in Florida locations fall within the wind speed ranges for the state-defined wind speed regions. Used during the Hazard analysis. |
| tFWMWindSpeedRegion2010 | Stores the possible Florida Wind Mitigation (FWM) 2010 range of speed. Used during the Hazard analysis. |
| tGeocoder | Stores the geocode resources available in Touchstone.
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. |
| tGeoLevel | Stores codes that represent geographic levels. |
| tGeoMatchLevel | Stores codes that represent the levels at which a geocode match can occur.
To best interpret the GeoMatchLevelCode in regards to the geocoding results, refer to the document Using Geocoding in Touchstone, which is available on AIR's Client Portal. This document provides details on how to use the GeoMatchLevelCode, together with the EnhancedGeoMatchlevelCode, to understand the quality of the geocoding results. |
| tGlassPercent | Stores codes that represent the percentage of the walls in a building that consist of glass.
The codes are used in the tLocFeature Table. |
| tGlassType | Stores codes that represent types of glass used in a building.
The codes are used in the tLocFeature Table. |
| tHailStormFrequency | Stores the possible frequencies in which hail storms results in property damage. Used during the Hazard analysis. |
| tHazardAttribute | Stores the possible the attributes of a hazard. |
| tHazardAttributeTableReference | A reference table used to determine the possible attributes of a hazard. |
| tHazardAttributeType | Stores information regarding the possible hazard attribute types. |
| tHPCJobPriorityType | Stores the priority level options that can be assigned to an activity. This table is for reference only, the job priority values are actually set in HPC job priority settings.
By default, jobs will be assigned “Normal Priority” (HPCJobPriorityID = 2000) and will be initiated in the order in which they are submitted if the following conditions are met:
- Sufficient capacity is available
- There are no other “High Priority” jobs waiting
- The job has been scheduled to run “immediately” – or –
- The date and time, if the job is scheduled, is after the user-selected run date and time if it was scheduled to run in the future
Jobs with “Top Priority” (HPCJobPriorityID = 4000) will be initiated if and when:
- Sufficient capacity is available
- There are no other “Top Priority” jobs waiting
- The job has been scheduled to run “immediately” – or –
- The date and time, if the job is scheduled, is after the user-selected run date and time if it was scheduled to run in the future
Jobs with “High Priority” (HPCJobPriorityID = 3000) will be immediately initiated if and when:
- Sufficient capacity is available
- There are no other “High Priority” jobs that were previously submitted and waiting
- The job has been scheduled to run “immediately” – or –
- The date and time, if the job is scheduled, is after the user-selected run date and time if it was scheduled to run in the future
Jobs with “Low Priority” (HPCJobPriorityID = 1000) will be initiated if and when:
Jobs that are already running will not be stopped and re-queued to start a higher priority job that is waiting. |
| tIBHSFortified | Stores codes that represent the level of certification per the Institute for Business and Home Safety, which defines a structure's ability to withstand load resistance.
The codes are used in the tLocFeature Table. |
| tImpactRegionPerilSet | Stores the possible groups of geographic areas impacted by specific peril sets identified by the Marginal Impact analysis options. |
| tImpactRegionPerilSetXref | System reference table used to determine the possible geographic areas impacted by specific peril sets. This table is not human-readable. |
| tImportType | Stores the possible import types. |
| tIndustryConstruction | Stores the possible the industry construction types. |
| tIndustryLineOfBusiness | Stores the possible the industry Line of Business types. |
| tIndustryOccupancy | Stores the possible the industry occupancy types. |
| tInjuryType | Stores codes that represent types of injuries. |
| tIntensityAttribute | Stores information about the intensity attributes that may be used during a hazard analysis. |
| tIntensityAttributeType | Stores parameter options for the intensity attribute. |
| tInternalPartition | Stores codes that represent types of interior walls.
The codes are used in the tLocFeature Table. |
| tISOConstruction | Stores ISO construction class information. |
| tISValue | Stores codes that represent measurements of the total seismic performance of a building. The measurements account for all characteristics that affect the response of a building to an earthquake.
The codes are used in the tLocFeature Table. |
| tLandmarkType | Stores the possible landmark types that are used during the Geospatial analysis. |
| tLargeMissile | Stores codes that indicate the presence of large missiles within 100 feet of a structure.
The codes are used in the tLocFeature Table. |
| tLattice | Stores codes that represent types of lattices.
The codes are used in the tLocFeature Table. |
| tLayerConditionType | Stores codes that indicate whether a layer is associated with a sublimit or a sub-sublimit. |
| tLicenseModule | Stores information used to identify the analysis modules that are available for licensing. |
| tLicenseRegion | Store the geographic regions that are available for licensing. |
| tLicenseRegionCountryXref | System reference table used to determine the geographic regions that are available for licensing |
| tLimitType | Stores codes that represent types of location limits. |
| tLiquefactionPotential | Stores the possible potential of liquefaction occurring. |
| tLossCostType | Stores the lost cost options for a non-catastrophe loss analysis. |
| tLossExcludedExposureType | Stores codes that specify why an exposure is excluded from a loss calculation. Touchstone uses the codes to generate the AIR Modeled Exposure Statistics Summary report. |
| tLossLevelRisk | Stores the potential levels of loss, which are portrayed as a percentage range. |
| tLossModEventFilterOption | Stores codes used to determine whether an event filter applies to a loss modification template. |
| tLossModGeographyOption | Stores codes used to determine whether a geographic filter applies to a loss modification template. |
| tLossTemplateType | Stores the types of loss templates. |
| tLossWidgetFlagType | Stores loss widget types used for underwriting. |
| tMainPerilSubPerilXref | System reference table that stores information about the sub-perils that are associated with a primary peril set.
For example, the following sub-perils are associated with MainPerilSetCode "4" (earthquake):
- 4 (earthquake)
- 8 (fire following)
- 12 (earthquake shake, fire following)
- 128 (sprinkler leakage)
- 8192 (tsunami)
- 8196 (earthquake shake, tsunami)
- 8200 (fire following, tsunami)
- 8204 (earthquake shake, fire following, tsunami)
- 139404 (earthquake shake, fire following, tsunami, sprinkler leakage, and landslide)
|
| tManned | Stores codes that indicate whether an offshore platform is manned or unmanned.
The codes apply only to offshore locations. |
| tMinMaxDeductibleType | Stores codes that represent minimum maximum deductible types for location terms. |
| tMinMaxLogic | Stores codes for Stores codes for minimum maximum policy logic types used in layer and sublimit terms. |
| tModel | Stores information about the models that are available in Touchstone. |
| tModelCombinedPeril_Xref | Stores the peril set codes that correspond to each model. |
| tModelCountryXref | System reference table used to determine the countries that are covered by the model. |
| tModelCTGeoLevelMapping | Stores information how geocode levels are aggregated for each model.
Touchstone uses the information for company loss file (CLF) exports of detailed loss data for CATRADER. |
| tModelGeographyXref | Stores the geographic location identifiers that correspond to each model. |
| tMultiplierUnit | Stores codes that represent units or orders of magnitude for currency. |
| tMultiStoryHall | Stores codes that indicate the presence of multi-story halls in a building.
The codes are used in the tLocFeature Table. |
| tNonCatPerilGroup | Stores the ISO peril groups. These are applicable for commercial, non-catastrophe analyses only. |
| tObjectBUDefinition | Stores the options that define how the map layer wizard retrieves objects associated with a business unit.
Touchstone uses the options to manage custom map layers. |
| tObjectContext | Stores codes that represent user modes. |
| tObjectContextCombination | Stores possible combinations of user modes. |
| tObjectType | A generic table to hold objects like templates and widgets which are added through the object management screen in administration console. |
| tOccLimitType | Stores the limit types that you can apply to layers and sublimits. |
| tOrnamentation | Stores codes that indicate the amount of decorative elements attached to the exterior of a building.
The codes are used in the tLocFeature Table. |
| tOutputDetailedAAL | Stores information regarding the possible targets to which the Average Annual Loss can apply. |
| tOutputGroupBy | Stores information regarding the categorization (grouping) of output. This table specifies how results can be aggregated before persisting into the database. |
| tOutputTable | Stores the database tables where the output is stored. |
| tOutputTableType | Stores the possible output table types to which the output is written. |
| tOutputType | Stores the possible types of output for each analysis type. |
| tOutputTypeTableXref | System reference table used to associate the output type tables during a loss analysis. |
| tOutputTypPerspectiveXref_NGM | System reference table that stores the financial perspective codes that correspond to each output table type. |
| tPeril | Stores codes that represent the perils supported by the application. |
| tPerilSet | Stores codes that represent the perils sets supported by the application. |
| tPerilSetXref | System reference table used to determine the individual perils that are associated with each peril set. This table is used extensively for geospatial analytics. |
| tPermissionType | Stores the types of permissions that users may have for global objects. |
| tPounding | Stores codes that indicate the distance between two structures. If the distance is not sufficiently long, the two structures may collide during earthquake shaking.
The codes are used in the tLocFeature Table. |
| tPreferredExposureType | Stores the preferred exposure types. |
| tProjectPhase | Stores codes that represent project phases, which indicate stages of construction.
The codes are used in the tLocFeature Table. |
| tPublicProtectionClass | Stores Public Protection Classification (PPC) codes.
ISO analyzes community data (for example, fire department, water supply, or emergency communications system data) and assigns a Public Protection Classification (PPC). PPCs range from 1 to 10. Class 1 generally represents superior fire protection, and Class 10 indicates that the area's fire suppression program does not meet ISO's minimum criteria.
The codes are used in the tLocFeature Table. |
| tRedundancy | Stores codes that indicate the presence of multiple lateral load resisting elements in a building.
The codes are used in the tLocFeature Table. |
| tReinsTargetType | Stores codes that represent types of targets associated with the reinsurance contract. |
| tReinsuranceUNICEDELOB | Stores the mappings between UNICEDE/2 lines of business (LOBs) and LOBs supported in Touchstone Re.
Touchstone uses the mappings when a user exports UNICEDE/2 data and associates the data to a company in Touchstone Re. For more information, see the Touchstone online help. |
| tReinsuranceUNICEDEUpgradeMapping | Stores mappings between lines of business in previous versions of the UNICEDE/2 specification and the corresponding lines of business in the current version of the specification. |
| tRelativeRisk | Stores the potential levels of risk, portrayed as a percentage range |
| tResultGroupBy | Stores the possibly categorization (grouping) types for Data Quality analysis results. |
| tResultTemplate | Stores the association between output types and the results. |
| tResultTemplateFilterAttributeXRef | System reference table used to determine the filter attributes that are applied to the results. |
| tResultViewBy | Stores information identifying the options for viewing results in Touchstone. |
| tRetrofit | Stores codes that represent types of retrofitting.
The codes are used in the tLocFeature Table. |
| tReverseGeocodingType | Stores codes that represent the types of reverse geocoding algorithms supported in Touchstone. |
| tRingCriteria | Stores the types of exposures that Touchstone can accumulate in a ring during a geospatial analysis. |
| tRiskMeasure | Stores the possible replacement value types available for use in the Geospatial analysis. |
| tRoofAnchorage | Stores codes that represent types of anchors used to secure a roof support system to the walls of a building.
The codes are used in the tLocFeature Table. |
| tRoofAttachedStructure | Stores codes that represent types of mechanical and other equipment that is attached to the roof of a building.
The codes are used in the tLocFeature Table. |
| tRoofCover | Stores codes that represent types of materials used for covering the roof of a building.
The codes are used in the tLocFeature Table. |
| tRoofCoverAttach | Stores codes that represent types of connections used to secure the roof covering to the roof deck.
The codes are used in the tLocFeature Table. |
| tRoofDeck | Stores codes that represent materials used to construct the roof deck of a building.
The codes are used in the tLocFeature Table. |
| tRoofDeckAttach | Stores codes that represent types of connections used to secure the roof deck of a building to the underlying roof support system.
The codes are used in the tLocFeature Table. |
| tRoofGeometry | Stores codes that represent roof shapes
The codes are used in the tLocFeature Table. |
| tRoofHailImpactResistance | Stores codes that represent a roof's level of resistance to damage from hail impact.
The codes are used in the tLocFeature Table. |
| tRoofPitch | Stores codes that represent roof pitch angles, which determine the slope of the roof.
The codes are used in the tLocFeature Table. |
| tSalvagePotential | Stores potential damage level associated with each salvage potential code.
This table contains information to evaluate the potential loss and the corresponding damage level to determine the total loss for policy conditions. |
| tScriptType | Stores information regarding the different script types that can be written to tScript Table in the AIRDBAdmin Database. These scripts are used to dynamically create databases. |
| tSealOfApproval | Stores codes that represent types of professional engineering attention given to the design of a structure.
The codes are used in the tLocFeature Table. |
| tSEQUELImpactAirGOMArea | Stores information about the support codes for Gulf of Mexico (GOM) with area code and their corresponding AIR specific sequential identifier. |
| tSEQUELImpactMMSData | Stores information about the SEQUELImpact Offshore structure including the type and number of structures.
For internal use only. |
| tSEQUELImpactSubPerilGroupingXRef | Stores codes, descriptions, and groupings of the peril codes generated in Touchstone. |
| tServiceEquipmentProtection | Stores codes that indicate regarding whether the service equipment at a location is protected from flood.
The codes are used in the tLocFeature Table. |
| tShapeIrregularity | Stores codes that represent types of structural irregularity for a building.
The codes are used in the tLocFeature Table. |
| tShortColumn | Stores codes that indicate the presence of a short column in a building.
The codes are used in the tLocFeature Table. |
| 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. |
| tSLWindStormFrequency | Stores the possible frequencies in which wind storms results in property damage. Used during the Hazard analysis. |
| tSmallDebris | Stores codes that indicate the presence of small debris within 200 meters of a structure.
The codes are used in the tLocFeature Table. |
| tSoftStory | Stores codes that indicate the presence of any structural weaknesses.
The codes are used in the tLocFeature Table. |
| tSoilType | Stores the soil types. |
| tSpatialAnalysisField | System reference table that stores information regarding the attributes that are available for browsing or required for Geospatial analytics. |
| tSpatialClusterGroup | Stores the possible Geospatial map cluster group resolution from a Geospatial analysis. |
| tSpatialDataSetBucketType | Stores information on the available bucket types for each spatial dataset, into which the results are grouped |
| tSpatialDataSetSource | Stores information regarding the source of the data set used during a Geospatial analysis. |
| tSpatialDataSetType | Stores information regarding the types of data sets available for use during a Geospatial analysis. |
| tSpatialFieldType | Stores the field type to which the Geospatial result column/attributes belong. |
| tSpatialQueryType | Stores information regarding the spatial data that is set-up in the Geospatial tables. |
| tSpatialReservedColumn | Stores information regarding the spatial columns that are reserved and, therefore, cannot be duplicated in spatial dataset imports. |
| tSpatialRounding | Stores information regarding latitude/longitude rounding, which is calculated for map cluster display during a Geospatial analysis. |
| tSpecialConstruction | Stores codes that represent types of earthquake-resistant system types.
The codes are used in the tLocFeature Table. |
| tSpecieStorage | Stores code that represent types of storage used in special construction structures. |
| tSprinklerType | This table contains the sprinkler identifier for each sprinkler type. |
| tSSDepth | Stores the possible measurement ranges used to define the storm surge depth. |
| tStatus | Stores codes that represent the status of objects in the applicable tables. |
| tStepTriggerType | Stores the supported trigger types for step functions. |
| tSTStormOption | Stores the weather options included as part of the Severe Storm model. |
| tSubmitStatus | Stores the supported contract submission status options. |
| tTableAlias | Stores information about the table alias that is defined on each exposure object for exposure view filtering. |
| tTallOneStory | Stores codes that represent the height of a one story building.
The codes are used in the tLocFeature Table. |
| tTank | Stores codes that indicate the presence of storage tanks in a building.
The codes are used in the tLocFeature Table. |
| tTerrain | Stores the surrounding terrain options. |
| tTerrainRoughness | Stores codes that represent the condition (or categorization) of the terrain surrounding a building.
The codes are used in the tLocFeature Table. |
| tTerrorismOption | Stores the terrorism event types included as part of the Terrorism model. |
| tTimeOfShift | Stores codes that represent types of shift definitions. |
| tTornadoFrequency | Stores the possible frequencies in which tornadoes results in property damage. Used during the Hazard analysis. |
| tTorsion | Stores codes that represent the layout of the structural elements in a building that may lead to torsional loads.
The codes are used in the tLocFeature Table. |
| tTransitionInSRC | Stores codes that indicate whether the transition from steel-reinforced concrete (SRC) to reinforced concrete (RC) in the columns of a building with SRC construction is smooth.
The codes are used in the tLocFeature Table. |
| tTransverseFrameType | Stores codes that represent types of transverse framing used to brace offshore platform legs. |
| tTreeExposure | Stores codes that indicate the presence of trees. The codes are used to identify the tree hazard around a structure.
The codes are used in the tLocFeature Table. |
| tTriggerType | Stores the supported trigger types, which are used to determine how reinsurance contracts are applied. |
| tUNICEDE2AreaTag | Stores information regarding geographic Area types that can be used in UNICEDE/2. This information is used to enable the use of UNICEDE/2 areas types in Touchstone. |
| tUNICEDE2CountryAreaTagXref | System reference table used to identify the CATRADER countries that can be used in UNICEDE/2. This information is used to enable the use of UNICEDE/2 countries codes in Touchstone. |
| tUNICEDE2CountryLOBXref | System reference table used to identify the Line of Business by country that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business by country codes in Touchstone. |
| tUNICEDE2Coverage | Stores information regarding coverage types that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 coverage type codes in Touchstone. |
| tUNICEDE2CoverageLOBXref | System reference table used to identify the Line of Business by coverage that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business by coverage codes in Touchstone. |
| tUNICEDE2LineofBusiness | Stores information regarding Line of Business types that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business type codes in Touchstone. |
| tUnit | Stores the supported units of measure. |
| tUnitConversion | Stores the ratio needed to convert from one distance measurement unit type to another, such as feet to meters. |
| tUpgradeLog | Stores information about upgrade scripts. |
| tUserConstruction | Stores the supported user-supplied construction class codes. |
| tUserConstructionScheme | Stores the supported sources (vendors) of the construction class codes. |
| tUserGroupType | Stores the possible group types to which a user account can be assigned. |
| tUserOccupancy | Stores the supported user-supplied occupancy class codes. |
| tUserOccupancyScheme | Stores the supported sources (vendors) of the occupancy class codes. |
| tValidationError | Stores import validation error codes, validation rules, and error messages. When a validation error occurs, the error is written to the import log file using the following format: ERROR CODE | Contract ID: XXX Location ID XXX | Summary Message. |
| tValidationErrorType | Stores the possible types of validation errors. |
| tValidatorMatch | Stores the possible address validation match levels that can be attained via the geocoding process. |
| tVulnerabilitySetFileType | Stores codes that represent the type of vulnerability set files in Touchstone. |
| tWall | Stores codes that represent types of materials used for the external walls of a building.
The codes are used in the tLocFeature Table. |
| tWallAttachedStructure | Stores codes that represent types of structures that may be attached to a primary building.
The codes are used in the tLocFeature Table. |
| tWallSiding | Stores codes that represent types of siding used for weather protection on the external walls of a building.
The codes are used in the tLocFeature Table. |
| tWaterHeater | Stores codes that indicate the presence of bracing for the water heater in a building.
The codes are used in the tLocFeature Table. |
| tWebLayerType | Stores codes that represent the types of map layers that are available on the web and that you can connect to from the Touchstone Administration Console. |
| tWelding | Stores codes that indicate whether welding occurs within a building.
The codes are used in the tLocFeature Table. |
| tWetFloodProofing | Stores codes that represent types of protection systems for wet flood in a location.
The codes are used in the tLocFeature Table. |
| tWidgetType | Stores the widget types. |
| tWindowProtection | Stores codes that represent types of protection systems used for the windows of a building.
The codes are used in the tLocFeature Table. |
| tZoneDefinitionType | Stores information used to identify how zone boundaries are defined. |
| xtLandmark | Stores geographic information used to define the exact location of landmarks for display on a map. For example, the mapping program refers to the area details stored within this table to place Boston Logan Airport at the appropriate location on a map. |
