Touchstone 4.0 Database Documentation
tResultTemplate Table
Description

Stores the association between output types and the results.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows214
Data Space Used136.00 KB
Index Space Used64.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OutputTypeCode

Code that represents the output type.

For a complete list of codes, see tOutputType Table.

VarChar10   
Primary Key ResultViewByCode

Code that represents the ways in which results can be viewed.

For a complete list of codes, see tResultViewBy Table.

Integer4   
Primary Key ResultGroupByCode

Code that represents the ways in which results can be grouped.

For a complete list of codes, see tResultGroupBy Table.

Integer4   
 ResultColumnsListList of table columns to be included in the results set.VarChar4000  
 ResultColumnLabels

Labels for the table columns in ResultColumnLabels.

These are used to properly label the columns on the user interface. 

VarChar1000  
 ResultGroupByList

List of table columns that determine how the results are grouped.

VarChar1000  
 ResultNameName of the results/report.VarChar255  
 DisplayOrderNumber that determines the order the results/reports are displayed on the user interface.UnsignedTinyInt1  
 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.

VarChar4000  
Objects that depend on tResultTemplate
 Database ObjectObject TypeDescriptionDep Level
tResultTemplateFilterAttributeXRef tabletResultTemplateFilterAttributeXRefTableSystem reference table used to determine the filter attributes that are applied to the results.2
Objects that tResultTemplate depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysisType tabletAnalysisTypeTableStores the various analysis types that can be performed in Touchstone.3
tExposureAttributeType tabletExposureAttributeTypeTable

Stores the possible types of exposure attributes used for the Loss analysis results options.

1
tOutputDetailedAAL tabletOutputDetailedAALTable

Stores information regarding the possible targets to which the Average Annual Loss can apply.

1
tOutputType tabletOutputTypeTable

Stores the possible types of output for each analysis type.

1
tResultGroupBy tabletResultGroupByTable

Stores the possibly categorization (grouping) types for Data Quality analysis results.

1
tResultViewBy tabletResultViewByTable

Stores information identifying the options for viewing results in Touchstone.

2
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.