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 Date	4/4/2022 3:02 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

Column Name	Description	Datatype	Length	Default
LossModTemplateSID	Unique system-generated sequential identifier for the loss modification template record.	int	4
BusinessUnitSID	Unique system-generated sequential identifier for the business unit record.	int	4
LossModTemplateName	Name of the loss modification template.	varchar	255
LossModTemplateNotes	User-provided notes regarding the loss modification template.	varchar	2000
Author	Name of the person who created the loss modification template.	varchar	255
DateCreated	Date and time when the loss modification template was created.	datetime	4
ModifiedBy	Name of the person who last modified the loss modification template.	varchar	255
DateUpdated	Date and time when the loss modification template was last modified.	datetime	4
RowTimeStamp	Used for time stamping.	timestamp	8
SortOrder	Reserved for future use.	int	4	((0))
IsValid	Indicates whether the loss modification template is valid. 1 = Yes (valid) 0 = No (not valid)	bit	1	((0))
TemplateVersion	Version of the loss modification template.	varchar	10
LossModGeographyOptionCode	Indicates the type of the geographic filter included in the template rule definition. 0 = None 1 = AdminBoundarySID 2 = GeographySID	smallint	2
LossModEventFilterOptionCode	Indicates the type of the event filter included in the template rule definition. 0 = None 1 = Event parameter 2 = Event list 3 = Event parameter and event list	smallint	2

Check Constraints

Name	Description	Expression
ck_tLossModTemplate_SortOrder		([SortOrder]>=(0))

Objects that depend on tLossModTemplate

Database Object	Object Type	Description	Dep Level
tLossModTemplateRule	Table	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	Table	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.	2
tLossModTemplateRuleOccupancyCode	Table	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.	2
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.	1
tLossModTemplateRuleSetEventParameterXref	Table	System reference table used to identify to look-up template rules and event rule set associations.	2

Related Objects

AIRUserSetting Database