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 Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventRuleSetSID | Unique system-generated sequential identifier for the event rule set record. | int | 4 | |||
| LossModTemplateSID | Unique system-generated sequential identifier for the loss modification template record. For a complete list of records, see tLossModTemplate Table. | int | 4 | ||||
| EventRuleSetName | Name of the event rule set. | varchar | 255 |  | |||
| SQLString | SQL representation of the filter conditions. | varchar | 16 | ||||
| Expression | XML string that defines the filter conditions. Used internally by Touchstone. | xml | 0 | ||||
| RowTimeStamp | Used for time stamping. | timestamp | 8 | ||||
| SortOrder | Reserved for future use. | int | 4 | ((0)) |
| Name | Description | Expression |
|---|---|---|
| ck_tLossModTemplateRuleSetEventParameter_SortOrder | ([SortOrder]>=(0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tLossModTemplateRuleSetEventParameterXref | Table | System reference table used to identify to look-up template rules and event rule set associations. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tLossModTemplate | Table | 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. | 1 |