Stores the association between output types and the results.
Touchstone 2022 Database Reference
tResultTemplate Table
Stores the association between output types and the results.
| Creation Date | 2/16/2011 6:00 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 321 |
| Data Space Used | 160.00 KB |
| Index Space Used | 64.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | OutputTypeCode | Code that represents the output type. For a complete list of codes, see tOutputType Table. | varchar | 10 | |||
| | ResultViewByCode | Code that represents the ways in which results can be viewed. For a complete list of codes, see tResultViewBy Table. | int | 4 | |||
| | ResultGroupByCode | Code that represents the ways in which results can be grouped. For a complete list of codes, see tResultGroupBy Table. | int | 4 | |||
| ResultColumnsList | List of table columns to be included in the results set. | varchar | 4000 |  | |||
| ResultColumnLabels | Labels for the table columns in ResultColumnLabels. These are used to properly label the columns on the user interface. | varchar | 1000 | | |||
| ResultGroupByList | List of table columns that determine how the results are grouped. | varchar | 1000 | | |||
| ResultName | Name of the results/report. | varchar | 255 | | |||
| DisplayOrder | Number that determines the order the results/reports are displayed on the user interface. | tinyint | 1 | | |||
| SortBy | Defines the calculation used to determine the Data Quality Uncertainty value. For additional information about calculating the Data Quality Uncertainty score, see the ScoreDQU column in tRRRR_DQ_SCR_ResultDetail Table. | varchar | 4000 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tResultTemplateFilterAttributeXRef | Table | System reference table used to determine the filter attributes that are applied to the results. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tAnalysisType | Table | Stores the analysis types available in the application. | 2 |
| tExposureAttributeType | Table | Stores the possible types of exposure attributes used for the Loss analysis results options. | 2 |
| tOutputDetailedAAL | Table | Stores information regarding the possible targets to which the Average Annual Loss can apply. | 2 |
| tOutputType | Table | Stores the possible types of output for each analysis type. | 1 |
| tResultGroupBy | Table | Stores the possibly categorization (grouping) types for Data Quality analysis results. | 1 |
| tResultViewBy | Table | Stores information identifying the options for viewing results in Touchstone. | 1 |