Touchstone 4.0 Database Documentation
tLossModTemplateRuleSetEventParameter Table

Used for a Loss analysis, this table stores information about the event parameters 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.

Creation Date5/31/2016 9:46 AM
Text File GroupPRIMARY
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EventRuleSetSIDUnique system-generated sequential identifier for the event rule set record.Integer4   

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

For a complete list of records, see tLossModTemplate Table.

 EventRuleSetNameName of the event rule set.VarChar255  
 SQLStringSQL representation of the filter conditions.LongVarChar16   
 ExpressionXML string that defines the filter conditions. Used internally by Touchstone.Xml16   
 RowTimeStampUsed for time stamping.Binary8   
 SortOrderReserved for future use.Integer4 
Check Constraints
Objects that depend on tLossModTemplateRuleSetEventParameter
 Database ObjectObject TypeDescriptionDep Level
tLossModTemplateRuleSetEventParameterXref tabletLossModTemplateRuleSetEventParameterXrefTableSystem reference table used  to identify to look-up template rules and event rule set associations.1
Objects that tLossModTemplateRuleSetEventParameter depends on
 Database ObjectObject TypeDescriptionDep Level
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.

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.