Touchstone 4.0 Database Documentation
tLossCostAdjustmentTemplateRule Table
Description

Used for a Non-Catastrophe analysis, this table stores information about the loss cost adjustment template. 

The loss analysis engine applies the rules (based on geography, construction, and occupancy) to locations after calculating the loss costs, adjusting the number up or down by this factor when there is a matching rule that applies.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LossCostAdjustmentTemplateSID

Unique system-generated sequential identifier for the loss cost adjustment template record.

Integer4   
Primary Key LossCostAdjustmentTemplateRuleSIDUnique system-generated sequential identifier for the loss cost adjustment template rule record.Integer4   
 CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15  
 AreaCode

Area code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 PostalCode

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 AIRConstructionCode

Code that represents the AIR construction class.

For a complete list of codes, see tAIRConstruction Table.

SmallInt2  
 AIROccupancyCode

Code that represents the AIR occupancy class.

For a complete list of codes, see tAIROccupancy Table.

SmallInt2  
 SubareaCode

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar15  
 CoverageTypeCode

Code that represents the coverage type. This column is applicable in when the IsLossCostTemplateEnabled column in tCoverage Table is set to 1 (yes).   

For a complete list of coverage codes, see tCoverage Table.

VarChar10  
 Factor

Value of the loss costs adjustment factor.

Double9  
Objects that tLossCostAdjustmentTemplateRule depends on
 Database ObjectObject TypeDescriptionDep Level
tLossTemplate tabletLossTemplateTable

 Stores information about the Loss analysis templates available in Touchstone. 

1
See Also

Related Objects

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