| Table | Description |
|---|
| tAnalysisExposureView | Stores information about exposure views used as analysis targets and the filters used to create the exposure views. |
| tAnalysisExposureViewDefinition | Stores the exposure set(s) included in each exposure view used as an analysis target. |
| tAnalysisReinsAppliesToGeo | Stores information about the geographic areas to which reinsurance treaties are applied. |
| tAnalysisReinsurance | Stores information about any reinsurance treaties applied during analyses. |
| tAnalysisResult | Contains general information about the analyses that produced the results.
The table includes one row for each analysis in the database, regardless of the analysis type (Loss, Loss Grouping, Catastrophe Excess of Loss, or Marginal Impact). |
| tAnalysisTarget | Stores information about the target of each analysis.
A detailed loss analysis has one analysis target: an exposure view.
A marginal impact analysis has two analysis targets: the reference portfolio and the new portfolio or policy to assess.
A loss group analysis has two or more analysis targets: the loss result sets or loss groups to combine. |
| tClusterCacheResolution | Stores the cluster cache resolution information required for a Geospatial analysis. |
| tDbHistory | Stores information about any packages applied to the database. |
| tDBVersion | Defines the version of the database. |
| tDQ_AMB_25I | Stores information for A.M. Best reports, such as the TIV percent, value, and count data of known attributes by personal property, commercial property, and worker's compensation.
For the A.M. Best reports of "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation, see tDQ_AMB_25K Table. |
| tDQ_AMB_25K | Stores information for A.M. Best reports, such as the "Most Frequency Observed Value" by personal property, commercial property, and worker's compensation.
For the A.M. Best reports of TIV percent, value, and count data of known attributes by personal property, commercial property, and worker's compensation, see tDQ_AMB_25I Table. |
| tDQAnalysisResultStatistics | Stores the statistical information for the Data Quality analysis. |
| tDQAUGExcludedLocations | Stores the excluded locations filter list that is used by the user interface. |
| tDQAUGPrePostSummaryCoverage | Stores pre- and post-summary coverage data. The data stored is used as part of the Data Quality - Augmentation PDF reports. |
| tEXPS_ByConstruction | Stores the data displayed on the Exposure Summary Dashboard when "Construction Type - Distribution of Replacement Values by Construction" is selected from the View Options. |
| tEXPS_ByCountryLOBOccupancy | Stores the data displayed on the Exposure Summary Dashboard when “LOB- Distribution of Replacement value by User Line of Business” option is selected from the View Options. |
| tEXPS_ByCoverage | Stores the data displayed on the Exposure Summary Dashboard when "Coverage Type - Distribution of Replacement Values by Coverage Type" is selected from the View Options. |
| tEXPS_ByCoverageBand | Stores the data displayed on the Exposure Summary Dashboard when “Coverage Type – Distribution of Replacement Value by Coverage Type” is selected from the View Options. |
| tEXPS_ByEmployee | Stores the data displayed on the Exposure Summary Dashboard when "Distribution of Number of Employees" is selected from the View Options. |
| tEXPS_ByGeography | A support table that contains the unique set of all geographies for anExposure Summary. Reserved for future use. |
| tEXPS_ByGeoMatchLevel | Stores the data displayed on the Exposure Summary Dashboard when "Geocode Match Level- Distribution of Replacement Values by Geocode Match Level" is selected from the View Options. |
| tEXPS_ByOccLimitType | Stores the data displayed on the Exposure Summary Dashboard when "Limit Type Distribution" is selected from the View Options. |
| tEXPS_ByOccupancy | Stores the data displayed on the Exposure Summary Dashboard when "Occupancy Type- Distribution of Replacement Values by Occupancy" is selected from the View Options. |
| tEXPS_ByPeril | Stores the data displayed on the Exposure Summary Dashboard when "Peril - Distribution of Replacement Values by Peril" is selected from the View Options. |
| tEXPS_BySecondaryRisk | Stores the data displayed on the Exposure Summary Dashboard when "Proportion of Known to Unknown Secondary Characteristics" is selected from the View Options. |
| tEXPS_ByStories | Stores the data displayed on the Exposure Summary Dashboard when "# Stories - Distribution of Replacement Values by Stories" is selected from the View Options. |
| tEXPS_BySubmitStatus | Stores the data displayed on the Exposure Summary Dashboard when "Status - Distribution of Replacement Values by Status" is selected from the View Options. |
| tEXPS_ByTimeElementBand | Stores the data displayed on the Exposure Summary Dashboard when "Per Diem- Distribution of Replacement Values by Per Diem Time Element" is selected from the View Options. |
| tEXPS_ByUserLineOfBusiness | Stores the data displayed on the Exposure Summary Dashboard when "LOB - Distribution of Replacement Values by User Line of Business" is selected from the View Options. |
| tEXPS_ByYearBuilt | Stores the data displayed on the Exposure Summary Dashboard when "Year Built - Distribution of Replacement Values by Year Built" is selected from the View Options. |
| tEXPS_ControlTotal | Stores the data displayed on the Exposure Summary Dashboard when "Peril-Distribution of Replacement Values by Peril" is selected from the View Options. |
| tEXPS_LOSSExcludedControlTotal | Stores information about locations that Touchstone excluded from a loss analysis. Touchstone uses this information to generate the AIR Modeled Exposure Statistics Summary report. |
| tEXPS_ReinsuranceType | Stores the data displayed on the Exposure Summary Dashboard when "Number of Contracts by Reinsurance Type" is selected from the View Options. |
| tLossAnalysisAdditionalOption | Stores information about the additional options for each loss analysis. |
| tLossAnalysisCustomFrequencyInfo | This table stores the custom frequency identifiers such as the type of event, custom catalog model code, and the unique sequential identifier associated with a detailed loss analysis.
This table is generated only when you run a detailed loss analysis with custom event frequency. |
| tLossAnalysisCustomFrequencySet | Stores information about the catalogs that contain custom, user-defined event footprints and the associated detailed loss anaysis. |
| tLossAnalysisCustomFrequencySetXref | Stores information about the unique sequential identifier of the result associated with the custom event frequency set analysis. |
| tLossAnalysisDemandSurgeOption | Stores information about the demand surge curves applied during detailed loss analyses.
If an analysis does not include demand surge, the table does not include a row for the analysis. |
| tLossAnalysisEarthquakeOption | Stores information about the earthquake options applied during detailed loss analyses.
If the earthquake peril is not included in a given analysis, the table does not include a row for the analysis. |
| tLossAnalysisFloodOption | Stores information about the custom flood zones included in detailed loss analyses. |
| tLossAnalysisOption | Stores the general options used to generate each set of detailed loss analysis results. |
| tLossAnalysisPerilSetULOBOption | Stores the peril set options used to generate each set of detailed loss analysis results. |
| tLossAnalysisSTStormOption | Stores the severe thunderstorm peril options used to generate each set of detailed loss analysis results.
If severe thunderstorm is included in an analysis, the table includes one or more rows for the analysis that indicate the categories of storm events that were included or excluded. |
| tLossAnalysisTerrorismOption | Stores the terrorism peril options used to generate each set of detailed loss analysis results.
If terrorism is included in an analysis, the table includes one or more rows for the analysis that indicate the categories of terrorist events that were included or excluded. |
| tLossAnalysisZoneOption | Stores information about the zone sets used to generate each set of detailed loss analysis results.
If you save results by zone during an analysis, Touchstone creates one or more rows for the analysis that indicate the zone sets you specified, whether you saved summary exceedance probability (EP) results by each combination of zone and peril, and whether you saved annual EP values by zone. |
| tRRRR_CLSH_ContractSummary | Stores statistical information about the contracts that are affected by the clash underwriting analysis. |
| tRRRR_CLSH_LocationByContract | Stores statistical information about the locations (within the contract) that are affected by the clash underwriting analysis. |
| tRRRR_CLSH_LocationByPortfolio | Stores statistical information about the locations (within the portfolio) that are affected by the clash underwriting analysis. |
| tRRRR_CMPLOSS_AnnualEPKey | Stores annual exceedance probability losses to be used a Comparative Loss analysis. This table is created for each comparative Loss analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results. |
| tRRRR_CMPLOSS_ContractKey | Stores information about the contracts used during the Comparative Loss analysis. |
| tRRRR_CMPLOSS_EventKey | Stores information about the events used during the Comparative Loss analysis. |
| tRRRR_CMPLOSS_GeoKey | Stores information about the location used during the Comparative Loss analysis. |
| tRRRR_CMPLOSS_LOBKey | Stores information about the Line of Business used during the Comparative Loss analysis. |
| tRRRR_DQ_AUG_ConsistencyResultSummary | Stores information regarding the number/percent of locations and replacement values that were in violation of each rule during the Data Quality - Augmentation analysis. |
| tRRRR_DQ_AUG_PrePostCharacteristics | Stores pre- and post- augmentation information. |
| tRRRR_DQ_AUG_ResultDetail | Report detail results for the Data Quality - Augmentation reports. |
| tRRRR_DQ_AUG_ResultDetailAggregate | Stores detailed summary results for the Data Quality - Augmentation reports. |
| tRRRR_DQ_AUG_ResultSummary | Stores summary results for the Data Quality - Augmentation reports. Contains augmentation values for display in report summary frame. |
| tRRRR_DQ_AUG_ResultValues | Defines actual values referenced by the augmentation rules. Stores both user and industry value for easy comparison and augmentation. Referenced by the tRRRR_DQ_AUG_ResultDetail Table to provide multiple values per location. Each location affected by the augmentation should have an ISOBIN record within this table to keep track of the augmentation data source. |
| tRRRR_DQ_DVA_ResultDetail | Stores result details for the Data Quality - Validation reports. Each table contains detail data for one report and every location in the report is represented by a record. See tRRRR_DQ_DVA_Violations Table to review the multiple rule violations for each location record. |
| tRRRR_DQ_DVA_ResultDetailAggregate | Stores the aggregate results for the Data Quality - Validation reports. |
| tRRRR_DQ_DVA_ResultDetailTerms | Stores detailed term result for the Data Quality - Validation reports. |
| tRRRR_DQ_DVA_ResultSummary | Stores summary results for the Data Quality - Validation reports. Each table contains summary data for one report. Records contain Data Quality - Validation values that are pre-aggregated to the format for display in report summary frame. |
| tRRRR_DQ_DVA_Violations | Stores all Data Quality - Validation rule violations for each location record in tRRRR_DQ_DVA_ResultDetail Table. Each single table contains detail data for one report and each row represents a failed rule for specific location. The ViolationDescription attribute combines the information from rule and rule set for easy access. (For example "RV A is less than 50000") |
| tRRRR_DQ_IDB_ResultDetail | Stores report details for the Data Quality - Industry Data Benchmark reports. |
| tRRRR_DQ_IDB_ResultSummary | Stores summary results for the Data Quality - Industry Data Benchmark reports. |
| tRRRR_DQ_IDR_ResultSummary | Stores summary results for the Data Quality - Industry Data Review reports. |
| tRRRR_DQ_SCR_ResultDetail | Stores result details for the Data Quality - Scoring reports. Each single table contains detail data for one report. |
| tRRRR_DQ_SCR_ResultSummary | Stores summary results for the Data Quality - Scoring reports. |
| tRRRR_EC_ByAccumulator | Stores the results of the Geospatial Accumulation analysis. An Accumulation analysis determines the accumulation of risk in peril-specific high risk areas. One or more of the properties in this table can be accumulated, such as location, risk, replacement value, and loss. |
| tRRRR_EC_ByContract | Stores the results of the Geospatial analysis at the contract-level. |
| tRRRR_EC_ByLayer | Stores the results of the Geospatial analysis at the layer-level. |
| tRRRR_EC_ByLocation | Stores the results of the Geospatial analysis at the latitude/longitude location-level. |
| tRRRR_EC_ByReinsurance | Stores information about the reinsurance program that is applicable to a given Accumulator and Peril combination. |
| tRRRR_EC_ClusterBoundingBox | Used for optimizing the Spatial Cube data. Reserved for internal use only. |
| tRRRR_EC_DimAccumulator | Stores information about each accumulation object. tRRRR_EC_ByAccumulator Table refers to the data in this parent table. |
| tRRRR_EC_DimContract | Stores attributes associated with each contract. These attributes are displayed on the user interface together with data from table tRRRR_EC_ByContract Table. |
| tRRRR_EC_DimLayer | Stores information about each layer defined for an analysis. tRRRR_EC_ByLayer Table refers to the data in this parent table. |
| tRRRR_EC_DimLocation | Stores attributes associated with each location included in the analysis. These attributes are displayed on the user interface along with data from tRRRR_EC_ByLocation Table. |
| tRRRR_EC_DimReinsurance | Stores reinsurance program attributes such as its ID and type. tRRRR_EC_ByReinsurance Table refers to the data in this parent table. |
| tRRRR_EC_DimSubAccumulator | Stores information about each sub-accumulation object. A sub-accumulation object is a concentric ring that is assigned a peril-specific damage ratio. All locations that lie within this ring are analyzed together as a single group. |
| tRRRR_EC_MappingLocationSubAccumulator | Stores the mapping between the locations and sub-accumulators included in a geospatial analysis. You can join this table to the tRRRR_EC_ByLocation Table and dbo.tRRRR_EC_DimSubAccumulator Table to view losses by location and sub-accumulator. |
| tRRRR_HAZ_AttributeSummary | Stores attribute-specific summary loss results from a Hazard analysis. |
| tRRRR_HAZ_Detail | Stores basic information about the results of a hazard analysis. |
| tRRRR_HAZ_Intensity | Stores detailed hazard information for events that cause loss to specific locations during a hazard analysis. |
| tRRRR_IMPACT_AnnualEPSummary | Stores annual exceedance probability summary losses for a marginal impact assessment. |
| tRRRR_IMPACT_Deterministic | Stores losses for the realistic disaster scenarios (RDS) events included in a marginal impact analysis. |
| tRRRR_IMPACT_TopImpact | Stores the ten highest losses in a marginal impact analysis. |
| tRRRR_LOSS_AnnualEP | Stores annual exceedance probability losses for an analysis. This table is created for each Loss analysis. By default, for each year in the analysis that experienced loss, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEP_ByModel | Stores annual exceedance probability losses by model. This table is created for each analysis. By default, for each year in the analysis that experienced loss for a specified model, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEP_ByPeril | Stores annual exceedance probability losses by peril. This table is created for each analysis. By default, for each year in the analysis that experienced loss for a specified peril, the table will contain at most one Aggregate row and one Occurrence row per financial perspective for the Standard EP curve. But if losses for a particular financial perspective in that year were 0, no row is generated. The table may contain additional rows if the user requests additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEP_ByPerilByZone | Stores annual exceedance probability losses for one analysis by each combination of peril and zone.
Touchstone creates one table for each analysis that included Zones by Peril as an output option. By default, for each combination of year, peril, and geographic zone that generated losses, the table contains at most one row for aggregate losses and one row for occurrence losses for each financial perspective for the standard EP curve. Touchstone may create more rows if you request additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEP_ByZone | Stores annual exceedance probability losses for one analysis by zone.
Touchstone creates one table for each analysis that included Zone as an output option. By default, for each combination of year and geographic zone that generated losses, the table contains at most one row for aggregate losses and one row for occurrence losses for each financial perspective for the standard EP curve. Touchstone may create more rows if you request additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEPSummary | Stores annual exceedance probability summary losses for one analysis.
Touchstone creates one table for each analysis. By default, the table contains rows for each financial perspective included in the analysis and rows for the corresponding aggregate EP, occurrence EP, aggregate TVAR, and occurrence TVAR. Touchstone may create more rows if you request additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEPSummary_ByPerilByZone | Stores annual exceedance probability summary losses for one analysis by each combination of peril and zone.
Touchstone creates one table for each analysis that included Zones by Peril as an output option. By default, the table contains rows for each financial perspective included in the analysis and rows for the corresponding aggregate EP, occurrence EP, aggregate TVAR, and occurrence TVAR. Touchstone may create more rows if you request additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEPSummary_ByPerilModel | Stores annual exceedance probability summary losses for both peril and model. This table is created for each analysis. By default, the table will contain rows for each financial perspective for which results are saved, one row each for aggregate EP, occurrence EP, aggregate TVAR, and occurrence TVAR. The table may contain additional rows if the user requests additional EP curves for subsets of the results. |
| tRRRR_LOSS_AnnualEPSummary_ByZone | Stores annual exceedance probability summary losses for one analysis by zone.
Touchstone creates one table for each analysis that included Zone as an output option. By default, the table contains rows for each financial perspective included in the analysis and rows for the corresponding aggregate EP, occurrence EP, aggregate TVAR, and occurrence TVAR. Touchstone may create more rows if you request additional EP curves for subsets of the results. |
| tRRRR_LOSS_ByContract | Stores contract-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Contract" in the analysis Output Options. |
| tRRRR_LOSS_ByContractByTreaty | Stores the reinsurance results by contract from a detailed loss analysis. This table is created when the user specifies "Save Loss By Contract" and selects a treaty type in the analysis Output Options. |
| tRRRR_LOSS_ByContractGeo | Stores contract geography-level loss results from a detailed Loss analysis. This table is created when a user specifies Contract and Geography in the Save Loss By area of the Output Options pane. |
| tRRRR_LOSS_ByContractGeoLayer | Stores losses for each contract, geography, and layer combination included in a detailed loss analysis. This table is created when a user specifies Layer and Geography in the Save Loss By area of the Output Options pane. |
| tRRRR_LOSS_ByContractSummary | Stores summary losses for one detailed loss analysis by contract.
Touchstone creates one table for each analysis that includes Contract Summary as an output option. |
| tRRRR_LOSS_ByContractZone | Stores event losses for one detailed loss analysis by each combination of contract and zone.
Touchstone creates one table for each analysis that includes Contract and Zone as output options. |
| tRRRR_LOSS_ByContractZoneLayer | Stores event losses for one detailed loss analysis by each combination of contract, zone, and layer.
Touchstone creates one table for each contract analysis that includes Contract, Zone, and Layer as output options. |
| tRRRR_LOSS_ByEvent | Stores event-level loss results from a detailed Loss analysis. This tables is created for every loss analysis. |
| tRRRR_LOSS_ByExposureAttribute | Stores loss results by event attribute from a detailed Loss analysis. |
| tRRRR_LOSS_ByExposureAttributeGeo | Stores the exposure’s results by geographic attribute from a detailed loss analysis. This table is created when the user specifies "Save Loss By Line of Business and Geography" in the analysis Output Options. |
| tRRRR_LOSS_ByExposureAttributeZone | Stores event losses for one detailed loss analysis by each combination of exposure attribute and zone.
Touchstone creates one table for each analysis that includes Line of Business and Zone as output options. |
| tRRRR_LOSS_ByGeo | Stores geography-level loss results from a detailed Loss analysis. This table is created when the user selects a geographic area from the "Geography" drop-down box in the analysis Output Options. |
| tRRRR_LOSS_ByGeoPerilAAL | Stores the average annual loss results, at the peril- and geography-level, from a detailed Loss analysis. This table is created when the user selects "Save Loss By Peril" and also selects a geographic area from the "Geography" drop-down box in the analysis Output Options. |
| tRRRR_LOSS_ByLayer | Stores layer-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Layer" in the analysis Output Options. |
| tRRRR_LOSS_ByLayerByFacultative | Stores the reinsurance results by layer from a detailed loss analysis. This table is created when the user specifies "Save Loss By Layer" and selects Facultative reinsurance type in the analysis Output Options. |
| tRRRR_LOSS_ByLayerByTreaty | Stores the reinsurance results by layer by treaty from a detailed loss analysis. This table is created when the user specifies "Save Loss By Layer" and selects a treaty type in the analysis Output Options. |
| tRRRR_LOSS_ByLocation | Stores location-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Location" in the analysis Output Options. |
| tRRRR_LOSS_ByLocationByFacultative | Stores the reinsurance results by location from a detailed loss analysis. This table is created when the user specifies "Save Loss By" and selects Facultative reinsurance type in the analysis Output Options. |
| tRRRR_LOSS_ByLocationByTreaty | Stores the reinsurance results by location from a detailed loss analysis. This table is created when the user specifies "Save Loss By Location" and selects a reinsurance treaty type in the analysis Output Options. |
| tRRRR_LOSS_ByLocationPerilAAL | Stores average annual loss results, at the peril- and location-level, from a detailed Loss analysis. This table is created when the user specifies both "Save Loss By Peril" and "Save Loss By Location" in the analysis Output Options. |
| tRRRR_LOSS_ByLocationSummary | Stores summary losses for one detailed loss analysis by location.
Touchstone creates one table for each analysis that includes Location Summary as an output option. |
| tRRRR_LOSS_ByMAOL | Stores Maximum Any One Life (MAOL) loss results from a detailed Loss analysis. This table is created when the user selects MAOL in the analysis Output Options. |
| tRRRR_LOSS_ByMAOLGeo | Stores Maximum Any One Life (MAOL) and geographic loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Geography" and selects MAOL in the analysis Output Options. |
| tRRRR_LOSS_ByReinsurance | Stores the reinsurance treaty loss results from a detailed loss analysis. This table is created when the user specifies any reinsurance type in the analysis Output Options. |
| tRRRR_LOSS_ByReinsuranceExposureAttribute | Stores the reinsurance results by exposure attribute from a detailed loss analysis. This table is created when the user specifies "Save Loss By Geography" and selects any reinsurance type in the analysis Output Options. |
| tRRRR_LOSS_ByReinsuranceExposureAttributeGeo | Stores the reinsurance results by exposure attribute from a detailed loss analysis. This table is created when the user specifies "Save Loss By Line of Business and Geography" and selects any reinsurance type in the analysis Output Options. |
| tRRRR_LOSS_ByReinsuranceGeo | Stores event losses for one detailed loss analysis by each combination of reinsurance program and geography.
Touchstone creates one table for each analysis that included Subarea (or a higher geographic resolution) as an output option and a reinsurance program as an analysis option. |
| tRRRR_LOSS_ByTreaty | Stores the reinsurance results by treaty from a detailed loss analysis. This table is created when the user specifies "Save Loss By Treaty" in the analysis Output Options. |
| tRRRR_LOSS_ByTreatyExposureAttribute | Stores the reinsurance results by treaty by exposure attribute from a detailed loss analysis. This table is created when the user specifies "Save Loss By Treaty By Exposure Attribute" in the analysis Output Options. |
| tRRRR_LOSS_ByTreatyExposureAttributeGeo | Stores the reinsurance results by treaty in a geographic location from a detailed loss analysis. This table is created when the user specifies "Save Loss By Treaty By Geo" in the analysis Output Options. |
| tRRRR_LOSS_ByZone | Stores event losses for one detailed loss analysis by zone.
Touchstone creates one table for each analysis that includes Zone as an output option. |
| tRRRR_LOSS_DimContract | Stores information about contracts that experienced Loss in the analysis. This dimension table is generated when losses are saved by contract or by location. |
| tRRRR_LOSS_DimCountryLOB | Stores information about a country’s Line of Business that experiences loss during a loss analysis. This dimension table is created when the user specifies "Save Loss By Line of Business" and a CLF option is selected in the analysis Output Options. |
| tRRRR_LOSS_DimEvent | Stores information about a terrorism event that experiences loss during a loss analysis. This dimension table is created when losses are saved by "Event". |
| tRRRR_LOSS_DimExposureAttribute | Stores specific exposure attribute values that were 1) used to aggregate losses and 2) experienced loss in the analysis. For example, if the loss results were saved by line of business, this table will include one row for every line of business that had a loss. The ExposureAttributeTypeCode would be ‘ULOB’, and the ExposureAttribute values would contain the names of the lines of business. This dimension table is created when losses are saved by any exposure attribute, such as Line of Business. |
| tRRRR_LOSS_DimExposureDataSource | Stores information about databases that contain exposures that have been analyzed. This dimension table is created for every Loss analysis. |
| tRRRR_LOSS_DimGeography | Stores information about each geography record that generated loss during a loss analysis. Touchstone generates the table only for analyses that a user transferred to Touchstone Re using the company loss association feature. |
| tRRRR_LOSS_DimLayer | Stores information about layers that experienced loss in the analysis. This dimension table is created when losses are saved by layer. |
| tRRRR_LOSS_DimLocation | Stores information about locations that experienced loss in the analysis. This dimension table is created when losses are saved by location.
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. |
| tRRRR_LOSS_DimReCurrencyExchangeRateSetConversion | Stores information about the exchange rate set that corresponds to each currency in the application.
This is a template table. |
| tRRRR_LOSS_DimReinsurance | Stores information about reinsurance treaties that incurred loss during the analysis.
You can get more information about the reinsurance treaties by joining the table to the tAnalysisReinsurance Table.
Touchstone creates one table for each analysis that included Treaty as an output option. |
| tRRRR_LOSS_DimZone | Stores information about the zones that generated losses during a detailed loss analysis.
Touchstone creates one dimension table for each analysis that included Zone as an output option. |
| tRRRR_LOSS_Stats | Stores the number of events associated with each combination of catalog type, model, and year included in a detailed loss analysis. Touchstone generates the table only for analyses that a user transfered to Touchstone Re using the company loss association feature.
During a company loss association, Touchstone writes information about a company loss file (CLF) set to the AIRCompanyLoss database and Touchstone Re associates the CLF set with a Touchstone Re company. |
| tRRRR_LOSS_ZoneStats | Stores the number of events associated with each zone included in a detailed loss analysis. Touchstone generates the table only for analyses that included zone as an output option. |
| tRRRR_TTTT_CMPLOSS_AnnualEP | Stores the deltas for the aggregate annual exceedance probability losses that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
|
| tRRRR_TTTT_CMPLOSS_AnnualEPSummary | Stores the deltas for the aggregate annual exceedance probability summary that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
|
| tRRRR_TTTT_CMPLOSS_ByEvent | Stores the deltas for the aggregate event losses that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
|
| tRRRR_TTTT_CMPLOSS_ContractLOBAAL | Stores the deltas for the aggregate average annual losses by contract LOB that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
|
| tRRRR_TTTT_CMPLOSS_GeoAAL | Stores the deltas in the aggregate average annual losses by location that are calculated during a Comparative Loss analysis.
tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
|
| 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. |
| tUpgradeOption | Stores information about database upgrades. |
