Stores information about each analysis.
Touchstone Re 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 | Not used by Touchstone Re. | 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. For a complete list of records, see tDataSource Table. | int | 4 | | |||
| ResultDataSourceName | Name of the data source that contains the analysis results. | 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 | Unique-system generated sequential identifier for the company, portfolio, or other object associated with the analysis. | int | 4 | | |||
| ContainerTypeCode | Code that specifies the type of the container. For a complete list of codes, see tContainerType Table. | 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 |
| 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 |
| tAggregateAnalysisParticipationOption | Table | Stores information about the participation option specified for each loss analysis. | 2 |
| tAggregateAnalysisTerrorismOption | Table | Stores information about the terrorism option specified for each loss analysis. | 1 |
| tAggregateLossAnalysisOption | Table | Stores information about the options specified for each loss analysis. | 1 |
| tAggregateLossAnalysisOutputOption | Table | Stores information about the output options specified for each loss analysis. | 2 |
| tAggregateLossAnalysisZoneSetXref | Table | System reference table that identifies the zone sets associated with each loss analysis. | 2 |
| tAnalysisTargetXref | Table | System reference table used to the identify the target of each analysis. | 2 |
| tLossAnalysisCustomFrequencySetXref | Table | Stores the loss analysis information associated with the custom frequency set. | 3 |
| tLossAnalysisOption | Table | Stores some of the options used during aggregate loss analyses. Touchstone Re stores additional options in tAggregateLossAnalysisOption Table. Columns that do not apply to Touchstone Re have values of null. | 2 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 3 |