tOutputType Table

Touchstone 2022 Database Reference

tOutputType Table

Collapse All

AIRReference Database : tOutputType Table

Description

Stores the possible types of output for each analysis type.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	90
Data Space Used	8.00 KB
Index Space Used	40.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	OutputTypeCode	Code that represents the output type. AMB = Validate: Rating Agency Reports (A.M. Best) AUG = Augment: Update CEDE = Company and Net Retained Aggregate Loss CLOBOCC = Exposure Summary by Country LOB Occupancy CLUSTER = Exposure Summary build Location ClusterCache CMPLOSS_1 = Comparative Portfolio Event Loss CMPLOSS_2 = Comparative Geography Event Loss/LocationAAL CMPLOSS_3 = Comparative LOB Event Loss CMPLOSS_4 = Comparative LOB, Geography Event Loss/LocationAAL CMPLOSS_5 = Comparative Contract/LOB Event Loss CMPLOSS_6 = Comparative Contract/LOB, Geography Event Loss/LocationAAL CON = Contract Event Loss CONGEOL = Contract Geography Event Loss CONGEOLYR = Contract Geography Event Loss CONSTR = Exposure Summary by Construction COV = Exposure Summary by Coverage COVBAND = Exposure Summary by Coverage Band CT = Exposure Summary Control Total DVA = Validate: Validation EA = Exposure Attribute Event Loss EAGEOL = Exposure Attribute Geography Event Loss ECA_0 = Exposure Concentration with SaveByAccumulator only option ECA_1 = Exposure Concentration with SaveByContract only option ECA_2 = Exposure Concentration with SaveByLocation only option ECA_3 = Exposure Concentration with SaveByContract and SaveByLocation options ECA_4 = Exposure Concentration with SaveByLayer only option ECA_5 = Exposure Concentration with SaveByContract and SaveByLayer options ECA_6 = Exposure Concentration with SaveByLayer and SaveByLocation options ECA_7 = Exposure Concentration with all 3 options: SaveByContract, SaveByLayer and SaveByLocation ECA_8 = Exposure Concentration with SaveByAccumulator only option + SaveLocTerm ECA_9 = Exposure Concentration with SaveByContract only option + SaveLocTerm ECA_10 = Exposure Concentration with SaveByLocation only option + SaveLocTerm ECA_11 = Exposure Concentration with SaveByContract and SaveByLocation options + SaveLocTerm ECA_12 = Exposure Concentration with SaveByLayer only option + SaveLocTerm ECA_13 = Exposure Concentration with SaveByContract and SaveByLayer options + SaveLocTerm ECA_14 = Exposure Concentration with SaveByLayer and SaveByLocation options + SaveLocTerm ECA_15 = Exposure Concentration with all 3 options: SaveByContract, SaveByLayer and SaveByLocation + SaveLocTerm ECA_16 = Exposure Concentration with SaveByAccumulator only option + SaveLayerTerm ECA_17 = Exposure Concentration with SaveByContract only option + SaveLayerTerm ECA_18 = Exposure Concentration with SaveByLocation only option + SaveLayerTerm ECA_19 = Exposure Concentration with SaveByContract and SaveByLocation options + SaveLayerTerm ECA_20 = Exposure Concentration with SaveByLayer only option + SaveLayerTerm ECA_21 = Exposure Concentration with SaveByContract and SaveByLayer options + SaveLayerTerm ECA_22 = Exposure Concentration with SaveByLayer and SaveByLocation options + SaveLayerTerm ECA_23 = Exposure Concentration with all 3 options: SaveByContract, SaveByLayer and SaveByLocation + SaveLayerTerm ECA_24 = Exposure Concentration with SaveByAccumulator only option + SaveLocTerm + SaveLayerTerm ECA_25 = Exposure Concentration with SaveByContract only option + SaveLocTerm + SaveLayerTerm ECA_26 = Exposure Concentration with SaveByLocation only option + SaveLocTerm + SaveLayerTerm ECA_27 = Exposure Concentration with SaveByContract and SaveByLocation options + SaveLocTerm + SaveLayerTerm ECA_28 = Exposure Concentration with SaveByLayer only option + SaveLocTerm + SaveLayerTerm ECA_29 = Exposure Concentration with SaveByContract and SaveByLayer options + SaveLocTerm + SaveLayerTerm ECA_30 = Exposure Concentration with SaveByLayer and SaveByLocation options + SaveLocTerm + SaveLayerTerm ECA_31 = Exposure Concentration with all 3 options: SaveByContract, SaveByLayer and SaveByLocation + SaveLocTerm + SaveLayerTerm EDSR = Validate: Summary EXPORT = Excluded Contracts EXRPORT = Reference Portfolio Excluding Expiring Contracts GEO = Exposure Summary by Geography GEOL = Geography Event Loss GEOM = Exposure Summary by GeoMatchLevel HAZEQ = Earthquake hazard profile HAZEX = Exposure Attribute Hazard Profile HAZFL = Flood hazard profile HAZIT = Hazard Intensity HAZITA = Hazard Intensity Analysis HAZTC = Hurricane hazard profile HAZTR = Terrorism hazard profile HAZTS = Severe thunderstorm hazard profile HAZWS = Winter storm hazard profile IDB = Benchmark: Industry Benchmark IDR = Benchmark: Industry Exposure LIMIT = Exposure Summary by Limit Type LOC = Location Event Loss LYR = Layer Event Loss LYRGEOL = Layer Event Loss, Geography Event Loss MIMPACT = Marginal Impact NPORT = Target Contract OCCUP = Exposure Summary by Occupancy PERIL = Exposure Summary by Peril PIMPACT = Updated Reference Portfolio Impact PORT = Polio Event Loss REI = Exposure Summary by Reinsurance Type REIA = Contract and Final Net Aggregate Loss RPORT = Reference Portfolio SCR = Benchmark:Scoring SECOND = Exposure Summary by Secondary Risk Characteristics STATUS = Exposure Summary by Submit Status STOR = Exposure Summary by Stories TE = Exposure Summary by Time Element ULOB = Exposure Summary by UserLineOfBusiness YEAR = Exposure Summary by Year Built	varchar	10
	AnalysisTypeCode	Code that represents the analysis types that can be performed in Touchstone. For a complete list of codes, see tAnalysisType Table.	varchar	10
	OutputType	Name of the output type. Corresponds to the code in OutputTypeCode.	varchar	255
	Description	Description of the output type.	varchar	1024
	DefaultResultViewByCode	Code that represents the Default result view. This field is used by a Data Quality analysis only. For a complete list of codes, see tResultViewBy Table.	int	4

Objects that depend on tOutputType

	Database Object	Object Type	Description	Dep Level
	tDQRuleSetType	Table	Stores the primary rule sets that can be applied during a Data Quality analysis.	1
	tHazardAttribute	Table	Stores the possible the attributes of a hazard.	1
	tIntensityAttribute	Table	Stores information about the intensity attributes that may be used during a hazard analysis.	1
	tOutputTypeTableXref	Table	System reference table used to associate the output type tables during a loss analysis.	1
	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

Objects that tOutputType depends on

	Database Object	Object Type	Description	Dep Level
	tAnalysisType	Table	Stores the analysis types available in the application.	1
	tExposureAttributeType	Table	Stores the possible types of exposure attributes used for the Loss analysis results options.	2
	tOutputDetailedAAL	Table	Stores information regarding the possible targets to which the Average Annual Loss can apply.	2
	tResultGroupBy	Table	Stores the possibly categorization (grouping) types for Data Quality analysis results.	2
	tResultViewBy	Table	Stores information identifying the options for viewing results in Touchstone.	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.