Stores information about the databases registered with the application, for example, the exposure and results databases.
Touchstone 2022 Database Reference
tDataSource Table
Stores information about the databases registered with the application, for example, the exposure and results databases.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 5 |
| Data Space Used | 8.00 KB |
| Index Space Used | 88.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DataSourceSID | Unique system-generated sequential identifier for the database. | int | 4 | |||
| DataSourceTypeCode | Code that represents the type of the database. For a complete list of codes, see tDataSourceType Table. | varchar | 10 | ||||
| DataServerSID | Unique system-generated sequential identifier for the data server that includes the database. For a complete list of records, see tDataServer Table. | int | 4 | ||||
| DataSourceName | User-provided name of the data source that stores the exposure and result data used in the project. | varchar | 255 | ||||
| IsRegistered | Indicates whether a database is registered with the Touchstone application.
| bit | 1 |  | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the data source. | int | 4 | ((1)) | |||
| Description | User-specified description of the data source. | varchar | 4000 | | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| DBUID | Globally unique identifier for the database. | uniqueidentifier | 16 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tActivity | Table | Stores information about each activity, including the unique sequential identifiers for analyses and activities. You can use the information in the table to find analysis results. | 2 |
| tActivityHpcJob | Table | Stores information about each activity that is submitted to the HPC server. | 3 |
| tActivityOutput | Table | Stores the identifier, status, and the file path for the output of each activity. An activity can include one or more tasks. Consequently, an activity output is a logical grouping of one or more task outputs. | 3 |
| tActivityOutputDetail | Table | Stores information about the task outputs of each activity output. The application writes to the table during each task. | 4 |
| tActivityParentXref | Table | System reference table used to associate an activity to the parent activity. | 3 |
| tActivityTargetStatus | Table | Stores information about the target of each activity. | 3 |
| tAnalysis | Table | Stores information about each analysis. | 1 |
| tAnalysisFilterXRef | Table | System reference table used to the identify the filters associated with each analysis. | 2 |
| tAnalysisTargetXref | Table | System reference table used to the identify the target of each analysis. | 1 |
| tClashAnalysisOption | Table | Stores the hold options settings for a clash underwriting analysis. | 2 |
| tComparativeLossAnalysisOption | Table | Stores the values used to generate the results in a Comparative Loss analysis. | 2 |
| tComparativeLossAnalysisTargetOption | Table | Stores information regarding the target analysis in a Comparative Loss analysis. | 2 |
| tDataQualityAnalysisOption | Table | Stores information regarding the augmentation of data during a Data Quality analysis. | 2 |
| tDataQualityAnalysisOutputOption | Table | Stores the output options for a Data Quality analysis. | 3 |
| tDataSourceActivityOption | Table | Stores information about the data source created by a specific activity. A data source is a database that is registered with the Touchstone application. | 1 |
| tDQAnalysisRule | Table | Stores data relating to the rules used in a Data Quality analysis. | 5 |
| tDQAnalysisRuleSet | Table | Stores information regarding the rule sets used during a Data Quality analysis. | 4 |
| tDQAnalysisRuleSetRuleSubTypeSelected | Table | Stores information regarding the rule sub type used during the Data Quality analysis. | 5 |
| tDQAnalysisSetting | Table | Stores information regarding the analysis settings used during a Data Quality analysis. | 4 |
| tDQIndustryFilterLOB | Table | Stores the type of output of the Data Quality analysis and the Line of Business of the insured properties to include in the output results. | 4 |
| tECAAreaZoneOption | Table | Stores the zone set identifiers used during a Geospatial analysis. | 3 |
| tECACustomSaveOption | Table | Stores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use. | 3 |
| tECARingDefinition | Table | Stores information regarded the rings used during a Geospatial analysis. | 4 |
| tECARingGeoMatchLevelOption | Table | Stores information about the geocode match level achieved during the Geospatial \analysis. | 4 |
| tECARingLandmarkOption | Table | Stores information about the landmarks used during a Geospatial analysis. | 4 |
| tECARingLocationList | Table | Stores information about the locations included in the Geospatial analysis. | 4 |
| tECARingOption | Table | Stores information about the ring options selected for the Geospatial analysis. | 3 |
| tECASpatialDataSetBucketDefinition | Table | Stores information that defines the buckets used in a Geospatial analysis. A bucket is a range of attribute values that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour. | 4 |
| tECASpatialDataSetBucketDetail | Table | Stores information regarding the data set bucket used during the Geospatial analysis. A bucket is a range that is analyzed as a single entity with a single damage ratio; For example, a bucket of wind speed could be 60 – 70 miles per hour. | 5 |
| tECASpatialDataSetOption | Table | Stores information regarding the spatial data set options used during the Geospatial analysis. | 3 |
| tECASpatialEventOption | Table | Stores information regarding the events for each model to include during the Geospatial analysis. | 3 |
| tECASpatialLossOption | Table | Stores information regarding the loss analysis options used during the Geospatial analysis. | 3 |
| tExportActivityFilter | Table | Stores information about the filter attribute applied during each export. | 2 |
| tExportActivityOption | Table | Stores information about each export. | 1 |
| tExposureConcentrationAnalysisOption | Table | Stores the options used during a Geospatial analysis. | 2 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 1 |
| tExposureViewDefinition | Table | Stores information about the exposure sets that are part of the exposure view optionally with a filter. | 1 |
| tEXPSAnalysisOutputOption | Table | Stores the output options used for the Exposure Summary analysis. | 2 |
| tHazardAnalysisAttributeOption | Table | Stores information about the attributes applied during a Hazard analysis. | 3 |
| tHazardAnalysisOption | Table | Stores information regarding the options selected for a Hazard analysis. | 2 |
| tHazardAnalysisOutputOption | Table | Stores information regarding the output from a Hazard analysis. | 2 |
| tImpactAnalysisAdditionalOption | Table | Stores information regarding advanced options used during a Marginal Impact analysis. | 2 |
| tImpactAnalysisOption | Table | Stores information regarding the analysis options used during a Marginal Impact analysis. | 2 |
| tImportActivityOption | Table | Stores information about an import activity. | 1 |
| tIntensityAttributeOption | Table | Stores information regarding the intensity attribute used during a Hazard analysis. | 2 |
| tLossAnalysisAdditionalOption | Table | Stores information about the additional options for each loss analysis. | 3 |
| tLossAnalysisCustomFrequencySetXref | Table | Stores the loss analysis information associated with the custom frequency set. | 3 |
| tLossAnalysisDemandSurgeOption | Table | 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. | 3 |
| tLossAnalysisEarthquakeOption | Table | 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. | 3 |
| tLossAnalysisFloodOption | Table | Stores information about the custom flood zones included in detailed loss analyses. | 3 |
| tLossAnalysisFloodPlainOption | Table | Stores information about the source of flood plain options in detailed loss analyses. Applicable only for US Model in Touchstone. The Precipitation Flood and Inland Flood perils apply to precipitation events that cause inland flooding due to river overflow, as well as to overflow caused by inadequate drainage systems. Based on the region, user can select the flood plain options before running an analysis. | 3 |
| tLossAnalysisOption | Table | Stores information about the general options specified for each loss analysis. | 2 |
| tLossAnalysisPerilSetULOBOption | Table | Stores information about the perils and Lines of Business analyzed during the Loss analysis. The table also identifies the percentage of the loss from storm surge or precipitation flood, when applicable. | 3 |
| tLossAnalysisSTStormOption | Table | Stores information about the severe storm options using during a Loss analysis. | 3 |
| tLossAnalysisTerrorismOption | Table | Stores information about the terrorism options used during a Loss analysis. | 3 |
| tLossAnalysisVulnerabilitySetXref | Table | Stores the additional options for vulnerability set files associated with loss analyses. | 3 |
| tLossAnalysisZoneOption | Table | 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. | 3 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 1 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 1 |