| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 1 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | DataServerSID | Unique system-generated sequential identifier of the database server record. | int | 4 | |||
| DataServerName | Name of the database server. | varchar | 255 |  | |||
| Description | User-specified description of the database server. | varchar | 4000 | | |||
| ConnectionInfo | XML expression that defines the connection information for any data sources. | xml | 0 | | |||
| DefaultMDFPath | Default path to the Database Data File (MDF). | varchar | 1024 | | |||
| DefaultLDFPath | Default path to the Transaction Log File (LDF) | varchar | 1024 | | |||
| DefaultInitalSizeData | Default initial size of a newly created database data file. Used by the exposure and results databases. | int | 4 | | |||
| DefaultInitalGrowthData | The initial growth parameter for the data file when a new database is created on the server. | int | 4 | | |||
| DefaultInitalSizeLog | The initial size of a newly created database log file. | int | 4 | | |||
| DefaultInitalGrowthLog | The initial growth parameter for the log file when a new database is created on the server. | int | 4 | | |||
| IsMaster | Indicates whether the data server is the master data server.
A master data server is the primary data server used by an application. You must specify a master data server if you create linked data servers for the Touchstone and Touchstone Re applications during the Touchstone upgrade process. | bit | 1 | ((0)) |
| 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. | 3 |
| tActivityHpcJob | Table | Stores information about each activity that is submitted to the HPC server. | 4 |
| 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. | 4 |
| tActivityOutputDetail | Table | Stores information about the task outputs of each activity output. The application writes to the table during each task. | 5 |
| tActivityParentXref | Table | System reference table used to associate an activity to the parent activity. | 4 |
| tActivityTargetStatus | Table | Stores information about the target of each activity. | 4 |
| tAnalysis | Table | Stores information about each analysis. | 2 |
| tAnalysisFilterXRef | Table | System reference table used to the identify the filters associated with each analysis. | 3 |
| tAnalysisTargetXref | Table | System reference table used to the identify the target of each analysis. | 2 |
| tClashAnalysisOption | Table | Stores the hold options settings for a clash underwriting analysis. | 3 |
| tComparativeLossAnalysisOption | Table | Stores the values used to generate the results in a Comparative Loss analysis. | 3 |
| tComparativeLossAnalysisTargetOption | Table | Stores information regarding the target analysis in a Comparative Loss analysis. | 3 |
| tDataQualityAnalysisOption | Table | Stores information regarding the augmentation of data during a Data Quality analysis. | 3 |
| tDataQualityAnalysisOutputOption | Table | Stores the output options for a Data Quality analysis. | 4 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 1 |
| 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 |
| tDQAnalysisRuleSet | Table | Stores information regarding the rule sets used during a Data Quality analysis. | 5 |
| tDQAnalysisSetting | Table | Stores information regarding the analysis settings used during a Data Quality analysis. | 5 |
| 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. | 5 |
| tECAAreaZoneOption | Table | Stores the zone set identifiers used during a Geospatial analysis. | 4 |
| tECACustomSaveOption | Table | Stores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use. | 4 |
| tECARingDefinition | Table | Stores information regarded the rings used during a Geospatial analysis. | 5 |
| tECARingGeoMatchLevelOption | Table | Stores information about the geocode match level achieved during the Geospatial \analysis. | 5 |
| tECARingLandmarkOption | Table | Stores information about the landmarks used during a Geospatial analysis. | 5 |
| tECARingLocationList | Table | Stores information about the locations included in the Geospatial analysis. | 5 |
| tECARingOption | Table | Stores information about the ring options selected for the Geospatial analysis. | 4 |
| 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. | 5 |
| tECASpatialDataSetOption | Table | Stores information regarding the spatial data set options used during the Geospatial analysis. | 4 |
| tECASpatialEventOption | Table | Stores information regarding the events for each model to include during the Geospatial analysis. | 4 |
| tECASpatialLossOption | Table | Stores information regarding the loss analysis options used during the Geospatial analysis. | 4 |
| tExportActivityFilter | Table | Stores information about the filter attribute applied during each export. | 3 |
| tExportActivityOption | Table | Stores information about each export. | 2 |
| tExposureConcentrationAnalysisOption | Table | Stores the options used during a Geospatial analysis. | 3 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 2 |
| tExposureViewDefinition | Table | Stores information about the exposure sets that are part of the exposure view optionally with a filter. | 2 |
| tEXPSAnalysisOutputOption | Table | Stores the output options used for the Exposure Summary analysis. | 3 |
| tHazardAnalysisAttributeOption | Table | Stores information about the attributes applied during a Hazard analysis. | 4 |
| tHazardAnalysisOption | Table | Stores information regarding the options selected for a Hazard analysis. | 3 |
| tHazardAnalysisOutputOption | Table | Stores information regarding the output from a Hazard analysis. | 3 |
| tImpactAnalysisAdditionalOption | Table | Stores information regarding advanced options used during a Marginal Impact analysis. | 3 |
| tImpactAnalysisOption | Table | Stores information regarding the analysis options used during a Marginal Impact analysis. | 3 |
| tImportActivityOption | Table | Stores information about an import activity. | 2 |
| tIntensityAttributeOption | Table | Stores information regarding the intensity attribute used during a Hazard analysis. | 3 |
| tLossAnalysisAdditionalOption | Table | Stores information about the additional options for each loss analysis. | 4 |
| tLossAnalysisCustomFrequencySetXref | Table | Stores the loss analysis information associated with the custom frequency set. | 4 |
| 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. | 4 |
| 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. | 4 |
| tLossAnalysisFloodOption | Table | Stores information about the custom flood zones included in detailed loss analyses. | 4 |
| 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. | 4 |
| tLossAnalysisOption | Table | Stores information about the general options specified for each loss analysis. | 3 |
| 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. | 4 |
| tLossAnalysisSTStormOption | Table | Stores information about the severe storm options using during a Loss analysis. | 4 |
| tLossAnalysisTerrorismOption | Table | Stores information about the terrorism options used during a Loss analysis. | 4 |
| tLossAnalysisVulnerabilitySetXref | Table | Stores the additional options for vulnerability set files associated with loss analyses. | 4 |
| 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. | 4 |