Touchstone 4.0 Database Documentation
tOutputType Table
Description

Stores the possible types of output for each analysis type.

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

Code that represents the output type.

  • AMB = Validate: Rating Agency Reports (A.M. Best)
  • AUG = Augment: Update
  • 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
  • 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    
  • 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 = New Portfolio
  • OCCUP = Exposure Summary by Occupancy
  • PERIL = Exposure Summary by Peril
  • PIMPACT = Portfolio Impact
  • PORT = Polio Event Loss
  • REI = Exposure Summary by Reinsurance Type
  • 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
VarChar10   
 AnalysisTypeCode

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

For a complete list of codes, see tAnalysisType Table.

VarChar10   
 OutputType

Name of the output type.

Corresponds to the code in OutputTypeCode.

VarChar255  
 Description

Description of the output type.

VarChar1024  
 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.

Integer4  
Objects that depend on tOutputType
 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
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 tOutputType 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
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.