Touchstone 4.0 Database Documentation
tLossModTemplateRuleSetEventParameter Table
Description

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.

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 EventRuleSetSIDUnique system-generated sequential identifier for the event rule set record.Integer4   
 LossModTemplateSID

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

For a complete list of records, see tLossModTemplate Table.

Integer4   
 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 
((0))
 
Check Constraints
NameDescriptionExpression
CKC_SORTORDER_TLOSSMODEVENTPARAMETER 
([SortOrder]>=(0))
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.

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.