| Table | Description |
|---|
| 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. |
| tAdjustmentMethod | Stores codes that indicate whether the EP (exceedance probability curve) adjustments specified for a reinsurance program represent amounts or percentages. |
| tAggregateAnalysisCustomlLOBFlag | Stores codes that represent whether custom lines of business (LOBs) are enabled or disabled during aggregate loss analyses. |
| tAggregateAnalysisParticipation | Stores codes that represent reinsurance participation levels applied during aggregate loss analyses. |
| tAggregateAnalysisPLAFlag | Stores codes that represent whether user-specified EP adjustments to program losses (PLAs) are enabled during aggregate loss analyses. |
| tAggregateAnalysisResultDetail | Stores codes that represent the level of detail of aggregate loss analysis results. |
| tAggregateDataType | Stores codes that represent the types of aggregate exposure data supported by the application. |
| tAggregateDeductibleType | Stores codes that represent types of aggregate deductibles. |
| tAggregateExposureType | Stores codes that represent the types of preferred aggregate exposure data supported by the application. |
| tAggregateLimitType | Stores codes that represent types of aggregate limits. |
| tAIRProduct | Stores AIR software application (product) names. |
| tAMBestLOBMapping | Stores mapping between AM Best line of business (LOBs) supported in Touchstone Re and LOBs supported in AIR's Industry Exposure Database. |
| tAnalysisStatus | Stores analysis statuses, which are used by the analysis engine. |
| 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. |
| tAreaPerilEdit | Stores information that the application uses to determine whether users can update exposure data at the area or subarea level for each combination of country, peril, and exposure data type. |
| tAuditActionType | Stores codes that represent actions recorded in the audit history. |
| tAuditHistoryActionType | Stores codes that represent actions recorded in the audit history. |
| tAuditHistoryTargetType | Stores codes that represent the targets of auditable actions.
The target of an auditable action is an object that a user can create, update, delete, or import. |
| tAuditTargetType | Stores enumerations that represent the targets of auditable actions.
The target of an auditable action is an object that a user can create, update, delete, or import. |
| TblModelInfo | Stores model-specific area detail information for all countries. |
| tBusinessUnitType | Stores the types of business units supported by the application. |
| tCargoPacking | Stores information about the cargo packing details. |
| tCargoProtection | Stores information about the protection of cargo package. |
| 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. |
| tCLFSetFlagType | Stores codes that indicates whether a company loss file (CLF) is flagged as a system or linked CLF. |
| tCLFSubType | Stores codes that represent subtypes of company loss file (CLF) sets. |
| tCLFUpgradeDetails | Stores mappings between legacy and current UNICEDE/2 area and line of business codes. |
| tCLFUpgradeModelversion | Stores the previous and current model version number that corresponds to each mapping in tCLFUpgradeDetails Table. |
| tCompanyType | Stores codes that represent types of AM Best Imports in Touchstone Re. |
| 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. |
| 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. |
| tCopyStatus | Stores the status options for when a user copies or moves 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. |
| tCountryILOBs | Stores the industry lines of business (LOBs) supported for each country and peril set combination. |
| 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. |
| tCurrenCLFSupportedModel | Stores information about models supported for company loss files. |
| tCurrency | Stores AIR currency codes. |
| tCurrencyMapping | Stores mappings between previously and currently supported currency codes. |
| tCurrencyUnit | Stores units or orders of magnitude of currency supported in the application. |
| tCustomLOBMapping | Stores the AIR lines of business (LOBs) that you can associate with custom (administrator-defined) LOBs.
You define custom LOBs for each country in the Administration Console. You must license Custom Models and LOBs to use the custom LOB feature. |
| tCustomLOBOption | Stores the supported aggregate loss analysis options for custom lines of business (LOBs). |
| 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. |
| 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. |
| 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). |
| 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. |
| tEventFilterRuleAttributeMapping | Stores mappings between attribute filter codes that the application uses during migrations and company imports. |
| 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. |
| 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 |
| tExposureType | Stores codes that represent types of aggregate exposures. |
| tFileType | Stores the supported types of event-based adjustment factor files.
You specify event-based adjustment factors in comma-separated values (CSV) files. An event-based adjustment factor file may contain factors for each event or each combination of event, area, and line of business associated with a given model. |
| 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. |
| tFinancialPerspectiveParticipationXRef | System reference table that stores the participation level supported for each financial perspective during an aggregate loss analysis. |
| 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. |
| 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. |
| 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. |
| tInForceDateType | Stores possible in-force date types. |
| 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. |
| tLossType | Stores codes that represent sources of loss data. |
| 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)
|
| 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. |
| 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. |
| tPeril | Stores codes that represent the perils supported by the application. |
| tPerilSet | Stores codes that represent the perils sets supported by the application.
Additional peril sets used by Touchstone Re are listed in tPerilSetCombined Table. |
| tPerilSetCombined | Stores the peril set combinations used by Touchstone Re to display losses in the loss dashboard. |
| tPerilSetCombined_Model_Xref | System reference table that stores the models that correspond with each peril set combination used in Touchstone Re. |
| 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. |
| tPortfolioType | Stores the types of portfolios supported by Touchstone Re.
A portfolio is a collection of reinsurance treaties. |
| tPreferredExposureType | Stores the preferred exposure types. |
| tReinsurance_HistoricalCatalogYearRange | Stores the range of years that contain historical events in each model event catalog supported by Touchstone Re. |
| tReinsuranceCountryPerilYear | Stores information that enables Touchstone Re to determine the lines of business (LOBs) supported for a given country, peril set, and exposure year. |
| tReinsuranceExposureLOBGroup | Stores the lines of business supported for the Multiple Peril Crop Insurance (MPCI) Model for India by country, exposure type, and growing season. |
| tReinsuranceExposureLOBMapping | Stores the mappings between UNICEDE/2 lines of business (LOBs) and LOBs supported in Touchstone Re. |
| tReinsuranceExposureToIndustryLOBMap | Stores mapping between lines of business (LOBs) supported in Touchstone Re and LOBs supported in AIR's Industry Exposure Database. |
| tReinsuranceIntAreaSchemeMapping | |
| tReinsuranceLegacyAreaExposureUpgrade | Stores mappings between previously supported area schemes and currently supported area schemes. |
| tReinsuranceLOB | Stores the lines of business supported in Touchstone Re. |
| tReinsuranceLOBCountryDisplayName | Stores the line of business names that Touchstone Re displays in the user interface for countries where the display name for a given LOB is different than the default display name. |
| tReinsuranceLOBSpec | Stores the lines of business supported in Touchstone Re for each country, peril, and exposure type combination. |
| tReinsuranceLOBSpecCT | Stores mappings between lines of business (LOBs) supported in CATRADER company files and LOBs supported in Touchstone Re. |
| tReinsuranceModelInfo | Reserved for future use. |
| tReinsuranceOutputOptionsTableList | Stores the names of the tables that Touchstone Re creates for each set of analysis options. |
| tReinsuranceProgramType | Stores codes that represent the types of reinsurance programs supported in Touchstone Re. |
| tReinsuranceTakeUpRatesMapping | Stores information about Take-up rates for industry loss and exposure data for a reinsurance program.
Take-up rates are the percentage of insurable properties that are actually insured.
The loss files packaged in Touchstone include total insurable loss for each modeled event. To derive insured loss, AIR estimates the percentage of risks covered by peril, by line of business, and by geographic location, then apply this estimate to the insurable loss values. These estimates are called take-up rates.
Take-up rates can be entered manually in the Exposures screen, Market Shares tab or brought in from a UNICEDE file. |
| tReinsuranceType | Stores codes that represent the types of reinsurance treaties supported in the application. |
| tReinsuranceUNICEDEAreatagCountryXref | Stores information about area and country tags in the UNICEDE/2 specification for the reinsurance programs. |
| 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. |
| TReinsurenceLobCategoryCode | Stores information about the line-of-business (LOB) and the corresponding category codes. |
| tScalingMethod | Stores codes that represent the types of scaling methods that Touchstone Re uses to apply EP (exceedance probability curve) adjustments.
A scaling method dictates how Touchstone Re restores the monotonicity of an EP curve after applying program-specific EP adjustments.
For more information, see Touchstone Re Online Help on AIR's Client Portal. |
| 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. |
| 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. |
| tStatus | Stores codes that represent the status of objects in the applicable tables. |
| tSubjectAssessmentType | Stores codes that identify assessment and source reinsurance programs in Touchstone Re. |
| tSubmitStatus | Stores the supported contract submission status options. |
| tSystemUserDefinedCategory | Stores identifiers for user-defined categories supported in Touchstone Re. |
| tTSTRPCatalogMapping | Stores mappings between Touchstone event catalogs and INF files used by Touchstone Re. |
| 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. |
| tUserDefinedCategoryType | Stores codes that represents the types of user-defined categories supported by Touchstone Re. |
| tUSMPCIType | Stores codes that represent types of value associated with the Multiple Peril Crop Insurance (MPCI) Model for the United States (U.S.).
For example, Touchstone Re stores the government-specified and user-specified Standard Reinsurance Agreement (SRA) group numbers associated with each U.S. (United States) state in the tUSMPCIGroupAssignments Table. In the context of the table, the USMPCITypeCode indicates whether the group number in a given row is government specified or user specified. |
