Touchstone 2022 Database Reference
tResultViewBy Table
AIRReference Database : tResultViewBy Table
Description

Stores information identifying the options for viewing results in Touchstone.

Properties
Creation Date4/5/2012 1:35 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows122
Data Space Used8.00 KB
Index Space Used56.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultViewByCode

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

  • 1 = Score Results by Geography
  • 2 = Score Results by Policy
  • 3 = Geography
  • 4 = Policy
  • 5 = Rule
  • 6 = Geography
  • 7 = Policy
  • 8 = Rule
  • 9 = Results by Coverage and Risk Count
  • 10 = Results by Line of Business and Risk Count
  • 11 = Results by Construction Type and Risk Count
  • 12 = Results by Occupancy Type and Risk Count
  • 13 = Results by Cov, LOB, Con, Occ and Risk Count
  • 14 = Results by Cov, LOB and Risk Count
  • 15 = Average Replacement Value
  • 16 = Construction Mix Comparison
  • 17 = Occupancy Mix Comparison
  • 18 = Market Share
  • 23 = Dashboard Summary
  • 24 = Distribution of Total Rep Value by Geography
  • 25 = Distribution of Rep Value by Coverage Type
  • 26 = Distribution of Rep Value by Geocode Match
  • 27 = Distribution of Bldg Rep Value
  • 28 = Distribution of Rep Value by Occupancy
  • 29 = Distribution of Rep Value by Construction
  • 30 = Distribution of Rep Value by Year Built
  • 31 = Distribution of Rep Value by Stories
  • 32 = Proportion of Known to Unknown Secondary Risk Characteristics
  • 33 = Number of Contracts per Reinsurance Type
  • 34 = Percentage of Data Containing Known Attributes
  • 35 = Most Frequently Observed Value
  • 36 = Result Summary
  • 37 = Results by Coverage
  • 38 = Results by Construction
  • 39 = Number of Contracts by Limit Type
  • 40 = Distribution of Time Element
  • 41 = Distribution of Total Replacement Value by User LOB
  • 42 = Distribution of Total Replacement Value by Peril
  • 43 = Distribution of Total Replacement Value by Status
  • 44 = Distribution By Base Risk
  • 45 = Distribution By Overall Risk
  • 46 = Geography
  • 47 = Distribution By Data Quality
  • 48 = Consistency - Result Summary
  • 101 = Event Loss by Portfolio
  • 102 = Event Loss by LOB
  • 103 = Event Loss by Geography
  • 104 = Event Loss by Geography and Contract
  • 105 = Event Loss by Geography and LOB
  • 106 = Event Loss by Geography and Coverage
  • 107 = Event Loss by Treaty
  • 108 = Average Annual Loss by Contract
  • 109 = Average Annual Loss by LOB
  • 110 = Average Annual Loss by Location
  • 111 = Exposure and AAL by Contract
  • 112 = Exposure and AAL by LOB
  • 113 = Exposure and AAL by Location
  • 114 = Exposure and AAL by Geography
  • 115 = Event Accumulation Results Overview
  • 116 = Contributing Contracts
  • 117 = Contributing Layers
  • 118 = Contributing Locations
  • 119 = Damage Ranges
  • 120 = Hazard Results
  • 121 = Distribution of Number of Employees
  • 122 = Annual EP Detail
  • 123 = Event Loss by Location
  • 124 = Event Loss by Layer
  • 125 = Event Loss by Contract and Coverage
  • 126 = Event Loss by Contract
  • 127 = Event Loss by Geography and Injury
  • 128 = Hazard Intensity
  • 129 = Comparative Event Loss by Portfolio
  • 130 = Comparative Average Annual Loss by Contract
  • 131 = Comparative Average Annual Loss by LOB
  • 132 = Comparative Average Annual Loss by Contract and LOB
  • 133 = Comparative Average Annual Loss by Geography
  • 134 = Comparative Annual EP Detail
  • 135 = Comparative Average Annual Loss by Location
  • 136 = Event Loss by Contract User-Defined Field 1
  • 137 = Event Loss by Contract User-Defined Field 2
  • 138 = Event Loss by Contract User-Defined Field 3
  • 139 = Event Loss by Contract User-Defined Field 4
  • 140 = Event Loss by Contract User-Defined Field 5
  • 141 = Average Annual Loss by Contract User-Defined Field 1
  • 142 = Average Annual Loss by Contract User-Defined Field 2
  • 143 = Average Annual Loss by Contract User-Defined Field 3
  • 144 = Average Annual Loss by Contract User-Defined Field 4
  • 145 = Average Annual Loss by Contract User-Defined Field 5
  • 146 = Event Loss by Contract, Geography, and Layer
  • 147 = Event Loss by Location User-Defined Field 1
  • 148 = Event Loss by Location User-Defined Field 2
  • 149 = Event Loss by Location User-Defined Field 3
  • 150 = Event Loss by Location User-Defined Field 4
  • 151 = Event Loss by Location User-Defined Field 5
  • 152 = Average Annual Loss by Location User-Defined Field 1
  • 153 = Average Annual Loss by Location User-Defined Field 2
  • 154 = Average Annual Loss by Location User-Defined Field 3
  • 155 = Average Annual Loss by Location User-Defined Field 4
  • 156 = Average Annual Loss by Location User-Defined Field 5
  • 200 = Annual EP Detail (Aggregate Portfolio)
  • 201 = Event Distribution (Aggregate Program)
  • 202 = Summary EP (Aggregate Program)
  • 203 = Summary EP by Peril (Aggregate Program)
  • 204 = Summary EP by Zone (Aggregate Program)
  • 205 = Summary EP by Zone/Peril (Aggregate Program)
  • 206 = Event Distribution (Aggregate Portfolio)
  • 207 = Aggregate and Occurrence Treaty Loss (Aggregate Portfolio)
  • 208 = Summary EP (Aggregate Portfolio)
  • 209 = Summary EP by Peril (Aggregate Portfolio)
  • 210 = Summary EP by Zone (Aggregate Portfolio)
  • 211 = Summary EP by Zone/Peril (Aggregate Portfolio)
  • 212 = Annual Distribution Summary by Treaty
  • 213 = Historical Losses by Treaty
  • 214 = RDS Losses by Treaty
  • 215 = Annual EP Detail (Aggregate Portfolio)
  • 216 = Event Loss by Zone
  • 217 = Event Loss by Zone and Contract
  • 218 = Event Loss by Contract, Zone, and Layer
  • 219 = Event Loss by Zone and LOB
int4   
 ResultViewBy

Value for the code.

Corresponds to the code in ResultsViewByCode.

varchar255   
 CoversCoverage

Indicates whether the View-By output includes coverage results.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversClaims

Indicates whether the View-By output includes claims count results.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversInjury

Indicates whether the View-By output includes injury results.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1 dbo.D_0 
 CoversReinsurance

Indicates whether the View-By output includes reinsurance results.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1dbo.D_0 
 Description

Description of the code.

varchar1024  
 DefaultResultGroupByCode

Code that represents the default "group-by" categorization type.

For a complete list of codes, see tResultGroupBy Table.

int4  
 ExposureAttributeTypeCode

Code that represents the exposure attribute type.

For a complete list of codes, see tExposureAttributeType Table.

varchar10  
 OutputDetailedAALCode

Code that represents the the average annual loss target type.

For a complete list of codes, see tOutputDetailedAAL Table.

varchar10  
 IsLocSumEnabled

Indicates whether the location summary is enabled for this ResultsViewBy type.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1dbo.D_0 
 IsConSumEnabled

Indicates whether the contract summary is enabled for this ResultsViewBy type.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1dbo.D_0 
 SaveByContract

Indicates whether this ResultsViewBy type can be saved by contract.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1 dbo.D_0 
 SaveByLocation

Indicates whether this ResultsViewBy type can be saved by location.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1 dbo.D_0 
 SaveByLayer

Indicates whether this ResultsViewBy type can be saved by layer.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1 dbo.D_0 
 SaveLocationTerm

Indicates whether this ResultsViewBy type can be saved by location term.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1 dbo.D_0 
 SaveLayerTerm

Indicates whether this ResultsViewBy type can be saved by layer term.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1 dbo.D_0 
 IsNonDeterministic

Indicates whether this ResultsViewBy type is non-deterministic.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
bit1  
 SaveByZone bit1 
((0))
 
 IsProgram bit1 
((0))
 
 IsPortfolio bit1 
((0))
 
Check Constraints
NameDescriptionExpression
CKC_COVERSREINSURANCE_TRESULTV 
([CoversReinsurance] IS NULL OR [CoversReinsurance]>=(0) AND [CoversReinsurance]<=(1))
CKC_ISCONSUMENABLED_TRESULTV 
([IsConSumEnabled] IS NULL OR [IsConSumEnabled]>=(0) AND [IsConSumEnabled]<=(1))
CKC_ISLOCSUMENABLED_TRESULTV 
([IsLocSumEnabled] IS NULL OR [IsLocSumEnabled]>=(0) AND [IsLocSumEnabled]<=(1))
CKC_ISNONDETERMINISTI_TRESULTV 
([IsNonDeterministic] IS NULL OR [IsNonDeterministic]>=(0) AND [IsNonDeterministic]<=(1))
Objects that depend on tResultViewBy
 Database ObjectObject TypeDescriptionDep Level
tDQRuleSetType tabletDQRuleSetTypeTable

Stores the primary rule sets that can be applied during a Data Quality analysis.

2
tHazardAttribute tabletHazardAttributeTable

Stores the possible the attributes of a hazard.

2
tIntensityAttribute tabletIntensityAttributeTableStores information about the intensity attributes that may be used during a hazard analysis.2
tOutputType tabletOutputTypeTable

Stores the possible types of output for each analysis type.

1
tOutputTypeTableXref tabletOutputTypeTableXrefTableSystem reference table used to associate the output type tables during a loss analysis.2
tResultTemplate tabletResultTemplateTable

Stores the association between output types and the results.

1
tResultTemplateFilterAttributeXRef tabletResultTemplateFilterAttributeXRefTableSystem reference table used to determine the filter attributes that are applied to the results.2
Objects that tResultViewBy depends on
 Database ObjectObject TypeDescriptionDep Level
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
tResultGroupBy tabletResultGroupByTable

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

1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.