tResultGroupBy Table

Description

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

Properties

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	ResultGroupByCode	Code that represents the "group-by" categorization type. -1 = No Group 1 = Country 2 = Area 3 = Sub Area 4 = Postal 5 = Location 6 = Location, Rule 7 = Exposure View 8 = Exposure Set 9 = Policy 10 = Policy, Rule 11 = Rule Type 12 = Rule Category 13 = Rule 14 = Default 15 = Summary 16 = Line of Business 17 = Construction 18 = Occupancy 19 = Area, Occupancy 20 = Sub Area, Occupancy 21 = Location, Terms 22 = Country, Occupancy 1001 = TC - Wind 1002 = SS - Severe Storm 1004 = EQ - Shake 1008 = EQ - Fire Following 1016 = Flood 1032 = Terrorism 1064 = SS - Winter Storm 1128 = EQ - Sprinkler Leakage 1256 = TC - Storm Surge 1512 = Wildfire	int	4
	ResultGroupBy	Name of the "group-by" categorization type. Corresponds to the code in ResultGroupByCode.	varchar	200

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

ResultGroupByCode

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

int

ResultGroupBy

Name of the "group-by" categorization type.

Corresponds to the code in ResultGroupByCode.

varchar

200

Objects that depend on tResultGroupBy

Database Object	Object Type	Description	Dep Level
tDQRuleSetType	Table	Stores the primary rule sets that can be applied during a Data Quality analysis.	3
tHazardAttribute	Table	Stores the possible the attributes of a hazard.	3
tIntensityAttribute	Table	Stores information about the intensity attributes that may be used during a hazard analysis.	3
tOutputType	Table	Stores the possible types of output for each analysis type.	2
tOutputTypeTableXref	Table	System reference table used to associate the output type tables during a loss analysis.	3
tResultTemplate	Table	Stores the association between output types and the results.	1
tResultTemplateFilterAttributeXRef	Table	System reference table used to determine the filter attributes that are applied to the results.	2
tResultViewBy	Table	Stores information identifying the options for viewing results in Touchstone.	1