Stores information about each analysis.
Touchstone 2022 Database Reference
tAnalysis Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 16 |
| Data Space Used | 8.00 KB |
| Index Space Used | 72.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | AnalysisSID | Unique system-generated sequential identifier for the analysis record. | int | 4 | |||
| AnalysisTypeCode | Code that represents the analysis type. For a complete list of codes, see tAnalysisType Table. | varchar | 10 | ||||
| ProjectSID | Unique system-generated sequential identifier for the project record. For a complete list of records, see tProject Table. | int | 4 |  | |||
| AnalysisName | User-provided name of the analysis. | varchar | 255 | ||||
| Description | User-specified description of the analysis. | varchar | 4000 | | |||
| AnalysisStatusCode | Code that indicates the status of an analysis instance. For internal use only. You can use ActivityStatusCode in tActivity Table for determining the status of an analysis. For a complete list of codes, see tAnalysisStatus Table. | varchar | 10 | ||||
| Author | User that initiated the analysis. | varchar | 255 | | |||
| EnteredDate | Date and time when the analysis was configured. | datetime | 4 | (getutcdate()) | |||
| ResultDataSourceSID | Unique system-generated sequential identifier for the data source that contains the analysis results. The identifier is a primary key in relation to the Exposure Concentration analysis results tables in the AIRResult Database. For a complete list of records, see tDataSource Table. | int | 4 | | |||
| ResultDataSourceName | Name of the data source that contains the analysis results. The data source is either the AIRResult Database or the AIRExposureSummary database. | varchar | 255 | | |||
| ResultSID | Unique system-generated sequential identifier for the results record. | int | 4 | | |||
| CurrencyExchangeRateSetSID | Unique system-generated sequential identifier for the currency exchange rates record. For a complete list of records, see tCurrencyExchangeRateSet Table. | int | 4 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | ||||
| ExecutedDate | Date and time when the analysis was executed. | datetime | 4 | | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| CompletedDate | Date and time when the analysis results were generated. | datetime | 4 | | |||
| AdvancedJobOption | XML expression for the user-provided advanced job options used during an analysis. For internal use by Touchstone. | xml | 0 | | |||
| AnalysisUID | Unique system-generated identifier for the analysis instance. The application uses the identifier to create staging tables in the AIRWork database. | uniqueidentifier | 16 | (newid()) | |||
| SourceTemplateName | Name of the analysis template used for the analysis. | varchar | 255 | | |||
| IsTemplateCustomized | Indicates whether the user customized the template for the analysis.
| bit | 1 | | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit. | int | 4 | | |||
| RowVersion | Used for version stamping. | timestamp | 8 | ||||
| AnalysisProductVersion | Version of the product used to perform the analysis. Users can view results generated from a previous version of the application, even if the models have been updated. | varchar | 10 | ('6.0.0') | |||
| ContainerSID | Not used by Touchstone. | int | 4 | | |||
| ContainerTypeCode | Not used by Touchstone. | varchar | 15 | | |||
| EditedDate | Date and time the analysis was last edited. | datetime | 4 | |
| 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. | 1 |
| tActivityHpcJob | Table | Stores information about each activity that is submitted to the HPC server. | 2 |
| 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. | 2 |
| tActivityOutputDetail | Table | Stores information about the task outputs of each activity output. The application writes to the table during each task. | 3 |
| tActivityParentXref | Table | System reference table used to associate an activity to the parent activity. | 2 |
| tActivityTargetStatus | Table | Stores information about the target of each activity. | 2 |
| tAnalysisFilterXRef | Table | System reference table used to the identify the filters associated with each analysis. | 1 |
| 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. | 1 |
| tComparativeLossAnalysisOption | Table | Stores the values used to generate the results in a Comparative Loss analysis. | 1 |
| 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. | 1 |
| tDataQualityAnalysisOutputOption | Table | Stores the output options for a Data Quality analysis. | 2 |
| 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. | 2 |
| tDQAnalysisRule | Table | Stores data relating to the rules used in a Data Quality analysis. | 4 |
| tDQAnalysisRuleSet | Table | Stores information regarding the rule sets used during a Data Quality analysis. | 3 |
| tDQAnalysisRuleSetRuleSubTypeSelected | Table | Stores information regarding the rule sub type used during the Data Quality analysis. | 4 |
| tDQAnalysisSetting | Table | Stores information regarding the analysis settings used during a Data Quality analysis. | 3 |
| 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. | 3 |
| tECAAreaZoneOption | Table | Stores the zone set identifiers used during a Geospatial analysis. | 2 |
| tECACustomSaveOption | Table | Stores user-defined accumulators that are used in a Geospatial analysis. Reserved for future use. | 2 |
| tECARingDefinition | Table | Stores information regarded the rings used during a Geospatial analysis. | 3 |
| tECARingGeoMatchLevelOption | Table | Stores information about the geocode match level achieved during the Geospatial \analysis. | 3 |
| tECARingLandmarkOption | Table | Stores information about the landmarks used during a Geospatial analysis. | 3 |
| tECARingLocationList | Table | Stores information about the locations included in the Geospatial analysis. | 3 |
| tECARingOption | Table | Stores information about the ring options selected for the Geospatial analysis. | 2 |
| 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. | 3 |
| 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. | 4 |
| tECASpatialDataSetOption | Table | Stores information regarding the spatial data set options used during the Geospatial analysis. | 2 |
| tECASpatialEventOption | Table | Stores information regarding the events for each model to include during the Geospatial analysis. | 2 |
| tECASpatialLossOption | Table | Stores information regarding the loss analysis options used during the Geospatial analysis. | 2 |
| 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. | 1 |
| tEXPSAnalysisOutputOption | Table | Stores the output options used for the Exposure Summary analysis. | 1 |
| tHazardAnalysisAttributeOption | Table | Stores information about the attributes applied during a Hazard analysis. | 2 |
| tHazardAnalysisOption | Table | Stores information regarding the options selected for a Hazard analysis. | 1 |
| tHazardAnalysisOutputOption | Table | Stores information regarding the output from a Hazard analysis. | 1 |
| tImpactAnalysisAdditionalOption | Table | Stores information regarding advanced options used during a Marginal Impact analysis. | 1 |
| tImpactAnalysisOption | Table | Stores information regarding the analysis options used during a Marginal Impact analysis. | 1 |
| tImportActivityOption | Table | Stores information about an import activity. | 2 |
| tIntensityAttributeOption | Table | Stores information regarding the intensity attribute used during a Hazard analysis. | 1 |
| tLossAnalysisAdditionalOption | Table | Stores information about the additional options for each loss analysis. | 2 |
| tLossAnalysisCustomFrequencySetXref | Table | Stores the loss analysis information associated with the custom frequency set. | 2 |
| 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. | 2 |
| 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. | 2 |
| tLossAnalysisFloodOption | Table | Stores information about the custom flood zones included in detailed loss analyses. | 2 |
| 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. | 2 |
| tLossAnalysisOption | Table | Stores information about the general options specified for each loss analysis. | 1 |
| 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. | 2 |
| tLossAnalysisSTStormOption | Table | Stores information about the severe storm options using during a Loss analysis. | 2 |
| tLossAnalysisTerrorismOption | Table | Stores information about the terrorism options used during a Loss analysis. | 2 |
| tLossAnalysisVulnerabilitySetXref | Table | Stores the additional options for vulnerability set files associated with loss analyses. | 2 |
| 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. | 2 |
| 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. | 2 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 1 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 2 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 1 |