• Introduction
• Revision History for the Touchstone Re Databases
  • What's New in Touchstone Re 2022
  • What's New for Touchstone Re 2021
  • What's New for Touchstone Re 8.0
• AIRCompanyLoss Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tCLAUpgradeLog Table
        • tCLAUpgradeLogTiming Table
        • tCLEXPORT_LossAnalysisOption Table
        • tCLEXPORT_NNNN_AAAA Table
        • tCompanyLossCatalog Table
        • tCompanyLossSet Table
        • tDbHistory Table
        • tDBVersion Table
        • tNNNN_CLF_Metadata Table
        • tSIDControl Table
        • tUpgradeLog Table
• AIRDBAdmin Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tDbHistory Table
        • tDBVersion Table
        • tPackage Table
        • tPackageContent Table
        • tSIDControl Table
        • tUpgradeLog Table
        • tVersionInfo Table
• AIRExposureRe Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tAggregateExposure Table
        • tAppliesToArea Table
        • tAppliesToAreaGeoXRef Table
        • tAppliesToEventFilter Table
        • tAppliesToEventFilterGeoXRef Table
        • tAppliesToEventFilterLatLong Table
        • tAppliesToEventFilterRule Table
        • tCatBondAttributeValue Table
        • tCLFCatalog Table
        • tCompany Table
        • tCompanyCLASizes Table
        • tCompanyLossAssociation Table
        • tCompanyLossMarketShare Table
        • tCompanyUDCClassification_Xref Table
        • tDbHistory Table
        • tDBVersion Table
        • tPortfolio Table
        • tPortfolioFilter Table
        • tPortfolioReinsuranceTreaty Table
        • tProgramBusinessCategoryFactor Table
        • tReinsuraceLOBCountryOverride Table
        • tReinsuranceEPCurve Table
        • tReinsuranceEPCurveAdjustmentPoint Table
        • tReinsuranceEPCurveSet Table
        • tReinsuranceExposureAdjustmentFactor Table
        • tReinsuranceProgram Table
        • tReinsuranceProgramCoverage Table
        • tReinsuranceProgramEPAdjustment Table
        • tReinsuranceProgramEPAdjustmentPoints Table
        • tReinsuranceProgramJapanCFLRatio Table
        • tReinsuranceProgramSourceInure Table
        • tReinsuranceProgramTargetXRef Table
        • tReinsuranceTreaty Table
        • tReinsuranceTreatyReinstatement Table
        • tReinsuranceTreatySavedResults Table
        • tReinsuranceTreatyTerrorismOption Table
        • tReinsuranceTreatyUDCClassification_Xref Table
        • tSIDControl Table
        • tUpgradeLog Table
        • tUpgradeOption Table
• AIRGeography Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tAlternategeography_mapping_factors Table
        • tChinaMPCIAreaRatio Table
        • tChinaMPCIExposureRatio Table
        • tConvertCL2Country Table
        • tCountryScheme Table
        • tDbHistory Table
        • tDBVersion Table
        • tGeoCountry Table
        • tGeography Table
        • tGeoLabel Table
        • tGeoRegion Table
        • tIndiaCropGeography Table
        • tIndiaMPCICluster Table
        • tIndiaMPCIClusterSet Table
        • tIndiaMPCIFactors Table
        • tIndiaMPCIFactorSet Table
        • tReinsuranceGeographyAreaTag Table
        • tReinsuranceGeographyEMM Table
        • tReinsuranceInternalCodeMapping Table
        • tSIDControl Table
        • tUpgradeLog Table
• AIRGlobalSetting Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tDbHistory Table
        • tDBVersion Table
        • tGlobalObject Table
        • tGlobalObjectBusinessUnitXref Table
        • tGlobalZone Table
        • tGlobalZoneGeographyXRef Table
        • tGlobalZoneSet Table
        • tSIDControl Table
        • tUpgradeLog Table
• AIRIndustry Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • TblIndustry2017 Table
        • TblIndustry2018 Table
        • TblIndustry2019 Table
        • TblIndustry2020 Table
        • TblIndustry2021 Table
        • TblOffshoreStructures Table
        • tCountryOffshore Table
        • tDbHistory Table
        • tDBVersion Table
        • tIndustry Table
        • tMultiYearMap Table
        • tReinsuranceIndustryRate Table
        • tUpgradeLog Table
• AIRProject Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tActivity Table
        • tActivityOutput Table
        • tActivityOutputDetail Table
        • tAggregateAnalysisJapanCFLOption Table
        • tAggregateAnalysisParticipationOption Table
        • tAggregateAnalysisTerrorismOption Table
        • tAggregateLossAnalysisOption Table
        • tAggregateLossAnalysisOutputOption Table
        • tAggregateLossAnalysisZoneSetXref Table
        • tAnalysis Table
        • tAnalysisTargetXref Table
        • tAuditHistory Table
        • tAuditHistoryParentObjectXRef Table
        • tDbHistory Table
        • tExposureSet Table
        • tLossAnalysisCustomFrequencySetXref Table
        • tLossAnalysisOption Table
        • tSIDControl Table
        • tUpgradeLog Table
• AIRReference Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tActivityOutputAggregation Table
        • tActivityOutputStatus Table
        • tActivityResourceType Table
        • tActivityResultStatus Table
        • tActivityStage Table
        • tActivityStatus Table
        • tActivityTargetState Table
        • tActivityTargetType Table
        • tActivityType Table
        • tActivityTypeActivityStageXref Table
        • tActivityTypeRestrictedActivityTypeXref Table
        • tAdjustmentMethod Table
        • tAggregateAnalysisCustomlLOBFlag Table
        • tAggregateAnalysisParticipation Table
        • tAggregateAnalysisPLAFlag Table
        • tAggregateAnalysisResultDetail Table
        • tAggregateDataType Table
        • tAggregateDeductibleType Table
        • tAggregateExposureType Table
        • tAggregateLimitType Table
        • tAIRProduct Table
        • tAMBestLOBMapping Table
        • tAnalysisStatus Table
        • tAnalysisTargetType Table
        • tAnalysisType Table
        • tAreaPerilEdit Table
        • tAuditActionType Table
        • tAuditHistoryActionType Table
        • tAuditHistoryTargetType Table
        • tAuditTargetType Table
        • TblModelInfo Table
        • tBusinessUnitType Table
        • tCargoPacking Table
        • tCargoProtection Table
        • tCatalogTagType Table
        • tCatalogType Table
        • tCatalogTypeFlagType Table
        • tCLFSetFlagType Table
        • tCLFSubType Table
        • tCLFUpgradeDetails Table
        • tCLFUpgradeModelversion Table
        • tCompanyType Table
        • tComponent Table
        • tContainerType Table
        • tContentDamageability Table
        • tConvertCL2Country Table
        • tCopyStatus Table
        • tCountry Table
        • tCountryCurrencyXref Table
        • tCountryILOBs Table
        • tCountryIndustryLOBXref Table
        • tCountryPerilXref Table
        • tCoverage Table
        • tCurrenCLFSupportedModel Table
        • tCurrency Table
        • tCurrencyMapping Table
        • tCurrencyUnit Table
        • tCustomLOBMapping Table
        • tCustomLOBOption Table
        • tDateFormat Table
        • tDbHistory Table
        • tDBVersion Table
        • tDemandSurgeOption Table
        • tDemandSurgeRegion Table
        • tDemandSurgeRegionGeo Table
        • tEPAnnualType Table
        • tEPCurveType Table
        • tEPTargetType Table
        • tEPType Table
        • tEventFilterHawaiiCondition Table
        • tEventFilterRuleAttribute Table
        • tEventFilterRuleAttributeMapping Table
        • tEventFilterTerrorismWeaponType Table
        • tEventSetPerilExclusion Table
        • tEventSetType Table
        • tExportStatus Table
        • tExportTargetType Table
        • tExportType Table
        • tExposureType Table
        • tFileType Table
        • tFilterAttribute Table
        • tFilterAttributeActivityTypeXref Table
        • tFilterType Table
        • tFinancialPerspective Table
        • tFinancialPerspectiveParticipationXRef Table
        • tGeoLevel Table
        • tGeoMatchLevel Table
        • tHPCJobPriorityType Table
        • tImportType Table
        • tIndustryConstruction Table
        • tIndustryLineOfBusiness Table
        • tIndustryOccupancy Table
        • tInForceDateType Table
        • tLayerConditionType Table
        • tLicenseModule Table
        • tLicenseRegion Table
        • tLicenseRegionCountryXref Table
        • tLimitType Table
        • tLossType Table
        • tMainPerilSubPerilXref Table
        • tModel Table
        • tModelCombinedPeril_Xref Table
        • tModelCountryXref Table
        • tModelCTGeoLevelMapping Table
        • tModelGeographyXref Table
        • tMultiplierUnit Table
        • tObjectBUDefinition Table
        • tObjectContext Table
        • tObjectContextCombination Table
        • tObjectType Table
        • tPeril Table
        • tPerilSet Table
        • tPerilSetCombined Table
        • tPerilSetCombined_Model_Xref Table
        • tPerilSetXref Table
        • tPermissionType Table
        • tPortfolioType Table
        • tPreferredExposureType Table
        • tReinsurance_HistoricalCatalogYearRange Table
        • tReinsuranceCountryPerilYear Table
        • tReinsuranceExposureLOBGroup Table
        • tReinsuranceExposureLOBMapping Table
        • tReinsuranceExposureToIndustryLOBMap Table
        • tReinsuranceIntAreaSchemeMapping Table
        • tReinsuranceLegacyAreaExposureUpgrade Table
        • tReinsuranceLOB Table
        • tReinsuranceLOBCountryDisplayName Table
        • tReinsuranceLOBSpec Table
        • tReinsuranceLOBSpecCT Table
        • tReinsuranceModelInfo Table
        • tReinsuranceOutputOptionsTableList Table
        • tReinsuranceProgramType Table
        • tReinsuranceTakeUpRatesMapping Table
        • tReinsuranceType Table
        • tReinsuranceUNICEDEAreatagCountryXref Table
        • tReinsuranceUNICEDELOB Table
        • tReinsuranceUNICEDEUpgradeMapping Table
        • TReinsurenceLobCategoryCode Table
        • tScalingMethod Table
        • tScriptType Table
        • tSIDControl Table
        • tStatus Table
        • tSubjectAssessmentType Table
        • tSubmitStatus Table
        • tSystemUserDefinedCategory Table
        • tTSTRPCatalogMapping Table
        • tUNICEDE2AreaTag Table
        • tUNICEDE2CountryAreaTagXref Table
        • tUNICEDE2CountryLOBXref Table
        • tUNICEDE2Coverage Table
        • tUNICEDE2CoverageLOBXref Table
        • tUNICEDE2LineofBusiness Table
        • tUnit Table
        • tUnitConversion Table
        • tUpgradeLog Table
        • tUserDefinedCategoryType Table
        • tUSMPCIType Table
• AIRResultRe Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tAggregateLossAnalysisOption Table
        • tAnalysisResult Table
        • tAnalysisTarget Table
        • tDbHistory Table
        • tDBVersion Table
        • tEXPS_ByConstruction Table
        • tLossAnalysisOption Table
        • tRRRR_DQ_AUG_ResultDetail Table
        • tRRRR_LOSS_ByContractByTreaty Table
        • tRRRR_LOSS_ByLayerByFacultative Table
        • tRRRR_LOSS_ByLayerByTreaty Table
        • tRRRR_LOSS_ByLocationByFacultative Table
        • tRRRR_LOSS_ByLocationByTreaty Table
        • tRRRR_LOSS_ByReAnnualEP Table
        • tRRRR_LOSS_ByReAnnualEP_Peril Table
        • tRRRR_LOSS_ByReAnnualEP_Zone Table
        • tRRRR_LOSS_ByReAnnualEP_ZonePeril Table
        • tRRRR_LOSS_ByReAnnualEPSummary Table
        • tRRRR_LOSS_ByReAnnualEPSummary_ZonePeril Table
        • tRRRR_LOSS_ByReCompany Table
        • tRRRR_LOSS_ByReCompanyGeo Table
        • tRRRR_LOSS_ByReCompanyLOBGeo Table
        • tRRRR_LOSS_ByReCompanyLOBZone Table
        • tRRRR_LOSS_ByRePortfolio Table
        • tRRRR_LOSS_ByRePortfolioLOBGeo Table
        • tRRRR_LOSS_ByRePortfolioLOBZone Table
        • tRRRR_LOSS_ByRePortfolioNetOfPremiums Table
        • tRRRR_LOSS_ByReProgram Table
        • tRRRR_LOSS_ByReProgramGeo Table
        • tRRRR_LOSS_ByReProgramNetOfPremiums Table
        • tRRRR_LOSS_ByReProgramZone Table
        • tRRRR_LOSS_ByReSourceInuring Table
        • tRRRR_LOSS_ByReSourceInuringLOBGeo Table
        • tRRRR_LOSS_ByReTreaty Table
        • tRRRR_LOSS_ByReTreatyAAL Table
        • tRRRR_LOSS_ByReTreatyGeo Table
        • tRRRR_LOSS_ByReTreatyLOBGeo Table
        • tRRRR_LOSS_ByReTreatyLOBZone Table
        • tRRRR_LOSS_ByReTreatyNetOfPremiums Table
        • tRRRR_LOSS_ByTreaty Table
        • tRRRR_LOSS_ByTreatyExposureAttribute Table
        • tRRRR_LOSS_ByTreatyExposureAttributeGeo Table
        • tRRRR_LOSS_DimGeography Table
        • tRRRR_LOSS_DimPortfolioReinsuranceTreaty Table
        • tRRRR_LOSS_DimReCurrencyExchangeRateSetConversion Table
        • tRRRR_LOSS_DimReTreaty Table
        • tRRRR_LOSS_DimReZone Table
        • tRRRR_LOSS_DimUSMPCIIndPremium Table
        • tRRRR_LOSS_RePerfLog Table
        • tRRRR_LOSS_Stats Table
        • tRRRR_LOSS_USR_TreatyTracking Table
        • tSIDControl Table
        • tUpgradeOption Table
• AIRUserSetting Database
  • Overview
  • Schemas
    • dbo Schema
      • Overview
      • Tables
        • tCatBondAttribute Table
        • tCurrencyExchangeRateSet Table
        • tCurrencyExchangeRateSetConversion Table
        • tCustomLOB Table
        • tDbHistory Table
        • tDBVersion Table
        • tDefaultAppliesToArea Table
        • tDefaultAppliesToAreaGeoXref Table
        • tDefaultDatabaseOption Table
        • tDefaultEnterpriseOption Table
        • tDefaultLossAnalysisOption Table
        • tDefaultTerrorismOption Table
        • tDefaultUserOption Table
        • tDemandSurge Table
        • tDemandSurgeFunction Table
        • tEventBasedAdjFactorFile Table
        • tEventBasedAdjFactorSet Table
        • tIndiaMPCICluster Table
        • tIndiaMPCIClusterSet Table
        • tIndiaMPCIFactors Table
        • tIndiaMPCIFactorSet Table
        • tModelInfo Table
        • tObject Table
        • tReinsuranceCatalog Table
        • tReinsuranceEventSet Table
        • tReinsuranceEventSetCatalogXRef Table
        • tReinsuranceEventSetMapEx Table
        • tReinsuranceIndustryRate Table
        • tReinsuranceModelPeril Table
        • tSIDControl Table
        • tUDCClassification Table
        • tUpgradeLog Table
        • tUserDefinedCategory Table
        • tUserDefinedEvxEventInfo Table
        • tUSMPCIGroupAssignments Table
        • tUSMPCIIndPremium Table
        • tUSMPCISRAInsurer Table
• Schema Diagrams