System reference table used to determine the filter attributes that are applied to the results.
Touchstone 2022 Database Reference
tResultTemplateFilterAttributeXRef Table
| Creation Date | 4/6/2012 11:47 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 146 |
| Data Space Used | 8.00 KB |
| Index Space Used | 40.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 | |||
| | FilterAttributeCode | Code that represents the filter attribute. For a complete list of codes, see tFilterAttribute Table. | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisType | Table | Stores the analysis types available in the application. | 3 |
| tExposureAttributeType | Table | Stores the possible types of exposure attributes used for the Loss analysis results options. | 3 |
| tFilterAttribute | Table | Stores the possible filters that are available for the activities | 1 |
| tOutputDetailedAAL | Table | Stores information regarding the possible targets to which the Average Annual Loss can apply. | 3 |
| tOutputType | Table | Stores the possible types of output for each analysis type. | 2 |
| tResultGroupBy | Table | Stores the possibly categorization (grouping) types for Data Quality analysis results. | 2 |
| tResultTemplate | Table | Stores the association between output types and the results. | 1 |
| tResultViewBy | Table | Stores information identifying the options for viewing results in Touchstone. | 2 |