tExposureAttributeType Table
Touchstone 4.0 Database Documentation
tExposureAttributeType Table

Stores the possible types of exposure attributes used for the Loss analysis results options.

Creation Date6/13/2011 7:13 PM
Text File Group
System Object
Published for Replication
Data Space Used8.00 KB
Index Space Used8.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ExposureAttributeTypeCode

Code that represents the exposure attribute type.

  • BR = Branch
  • PF = PolicyForm
  • PR = ProducerName
  • TR = Territory
  • UDF1 = UserDefined1
  • UDF2 = UserDefined2
  • UDF3 = UserDefined3
  • UDF4 = UserDefined4
  • UDF5 = UserDefined5
  • ULOB = UserLineOfBusiness
  • UW = Underwriter

Name of the exposure attribute type.

Corresponds to the code in ExposureAttributeTypeCode.

 DescriptionDescription of the exposure attribute type.VarChar1024  

Name of the table in the AIRExposure Database to which this type of data is stored.

For example, Location information is stored in the tLocation Table.

Objects that depend on tExposureAttributeType
 Database ObjectObject TypeDescriptionDep Level
tDQRuleSetType tabletDQRuleSetTypeTable

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

tHazardAttribute tabletHazardAttributeTable

Stores the possible the attributes of a hazard.

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.

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.

tResultTemplateFilterAttributeXRef tabletResultTemplateFilterAttributeXRefTableSystem reference table used to determine the filter attributes that are applied to the results.2
tResultViewBy tabletResultViewByTable

Stores information identifying the options for viewing results in Touchstone.

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.