Touchstone 4.0 Database Documentation
tCustomLossCostTemplateRule Table
Description

Used for a Non-Catastrophe analysis, this table stores information about the custom, user-defined loss cost calculator that the loss analysis engine uses instead of the calculations provided by ISO's Loss Cost Calculator. 

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 the adjustment 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 CustomLossCostTemplateSID

Unique system-generated sequential identifier for the custom, user-defined loss cost template record.

Integer4   
Primary Key CustomLossCostTemplateRuleSIDUnique system-generated sequential identifier for the custom, user-defined loss cost 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  
 SubareaCode

Subarea 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  
 Factor

Value of the loss costs adjustment factor.

The loss analysis engine applies the rules to locations after calculating the loss costs, adjusting the number up or down by this factor when there is a matching rule that applies.

Double9  
Objects that tCustomLossCostTemplateRule 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.