tAnalysisType Table

Description

Stores the analysis types available in the application.

Properties

Columns

Column Name	Description	Datatype	Length
AnalysisTypeCode	Code that represents the analysis types that can be performed in Touchstone. AGGR_LOSS = Aggregate Loss CATLOSS = CAT Loss Treaty CLSH = Clash CLSH_TMPLT = Clash Template CMPLOSS = Comparative Loss DQ = Data Quality DQ_RPT = Data Quality Reports DQ_TMPLT = Data Quality Template EC = Geospatial ECA_TMPLT = Geospatial Analysis Template EXPS = Exposure Summary HAZ = Hazard HAZ_TMPLT = Hazard Template IMPACT = Impact Analysis LGRP = Detailed Loss Group LGRP_MOD = Modified Detailed Loss Group LOSS = Detailed Loss LOSS_MOD = Modified Detailed Loss Analysis LOSS_TMPLT = Detailed Loss Analysis Template PGM_TMPLT = Program aggregate loss analysis template PRT_TMPLT = Portfolio aggregate loss analysis template SPTL = Spatial UW_RPT = Underwriting Report	varchar	10
AnalysisType	Name of the analysis type. Corresponds to the code in AnalysisTypeCode.	varchar	40
Description	Description of the analysis type.	varchar	1024

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

AnalysisTypeCode

Code that represents the analysis types that can be performed in Touchstone.

varchar

AnalysisType

Name of the analysis type.

Corresponds to the code in AnalysisTypeCode.

varchar

Description

Description of the analysis type.

varchar

1024

Objects that depend on tAnalysisType

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