Touchstone 4.0 Database Documentation
tLossModTemplateRule Table
Description

Used for a Loss analysis, this table stores information about the custom, user-defined rules (filter) that identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key TemplateRuleSIDUnique system-generated sequential identifier for the loss modification template rule record.Integer4   
 LossModTemplateSID

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

For a complete list of records, see tLossModTemplate Table.

Integer4   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 FinancialPerspectiveCode

Code that represents the financial perspectives.

For a complete list of codes, see tFinancialPerspective Table.

VarChar10  
 FactorThe value that the Loss analysis engine uses to increases or decreases the Ground-Up losses.Numeric9 (9,4)  
 RowTimeStampUsed for time stamping.Binary8  
 LOBSQLStringSQL representation of the Line of Business.LongVarChar16  
 LOBExpressionXML string that defines the Line of Business. Used internally by Touchstone.Xml16  
 SortOrderReserved for future use.Integer4 
((0))
 
 AppliesToCoverageThe coverage (A, B, C, and D) used as a filter in the rule definition.VarChar4  
 AdminBoundarySID

Unique system-generated sequential identifier for the custom administrative boundary record. This boundary is used as a filter in the rule definition.

For a complete list of records, see tAdminBoundary Table.

Integer4  
 YearBuiltYear the structure was built.SmallInt2  
 StoriesNumber of stories in the structure.SmallInt2  
 ContractIDSQLStringSQL representation of the contract identifier.LongVarChar16  
 LocationIDSQLStringSQL representation of the location identifier.LongVarChar16  
Check Constraints
NameDescriptionExpression
CKC_SORTORDER_TLOSSMODTEMPLATERULE 
([SortOrder]>=(0))
Objects that depend on tLossModTemplateRule
 Database ObjectObject TypeDescriptionDep Level
tLossModTemplateRuleConstructionCode tabletLossModTemplateRuleConstructionCodeTable

Used for a Loss analysis, this table stores information about the construction class filter in the rule definition.

These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

1
tLossModTemplateRuleOccupancyCode tabletLossModTemplateRuleOccupancyCodeTable

Used for a Loss analysis, this table stores information about the occupancy class filter in the rule definition.

These custom, user-defined rules identify the Ground-Up losses to which the Loss analysis engine applies the specified loss modification factor. The engine applies the factor to losses from the events that satisfy the rules.

1
tLossModTemplateRuleSetEventParameterXref tabletLossModTemplateRuleSetEventParameterXrefTableSystem reference table used  to identify to look-up template rules and event rule set associations.1
Objects that tLossModTemplateRule depends on
 Database ObjectObject TypeDescriptionDep Level
tAdminBoundary tabletAdminBoundaryTable

Stores information about the administrative boundaries available in Touchstone.

Detailed information about the administrative boundaries is available in tAdminBoundaryDetail Table

2
tLossModTemplate tabletLossModTemplateTable

Used for a Loss analysis, this table stores information about the custom, user-defined loss modification template. 

Loss modification templates allow the user to define one or more rules that direct the Loss analysis engine to apply a specified loss modification factor directly to Ground-Up losses. The characteristics of the rules are defined in dbo.tLossModTemplateRule.

The loss engine scales the entire Ground-up distribution, not just the mean loss, and applies all policy conditions to the modified losses. It does not cap the modified losses at the total insurable value (TIV). Any loss modification factor that is applied to losses from a peril applies also to losses generated by the respective sub-perils.

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