Touchstone 4.0 Database Documentation
tLossModTemplate Table
Description

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.

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 LossModTemplateSIDUnique system-generated sequential identifier for the loss modification template record.Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4  
 LossModTemplateNameName of the loss modification template.VarChar255  
 LossModTemplateNotesUser-provided notes regarding the loss modification template.VarChar2000  
 AuthorName of the person who created the loss modification template.VarChar255  
 DateCreatedDate and time when the loss modification template was created.DBTimeStamp4  
 ModifiedByName of the person who last modified the loss modification template.VarChar255  
 DateUpdatedDate and time when the loss modification template was last modified.DBTimeStamp4  
 RowTimeStampUsed for time stamping.Binary8   
 SortOrderReserved for future use.Integer4 
((0))
 
 IsValid

Indicates whether the loss modification template is valid.

  • 1 = Yes (valid)
  • 0 = No (not valid)
Boolean1 
((0))
 
 TemplateVersionVersion of the loss modification template.VarChar10  
Check Constraints
NameDescriptionExpression
CKC_SORTORDER_TLOSSMODTEMPLATE 
([SortOrder]>=(0))
Objects that depend on tLossModTemplate
 Database ObjectObject TypeDescriptionDep Level
tLossModTemplateRule tabletLossModTemplateRuleTable

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.

1
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
tLossModTemplateRuleSetEventParameter tabletLossModTemplateRuleSetEventParameterTable

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.

1
tLossModTemplateRuleSetEventParameterXref tabletLossModTemplateRuleSetEventParameterXrefTableSystem reference table used  to identify to look-up template rules and event rule set associations.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.