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.
| 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 | |
|---|---|---|---|---|---|---|---|
 | TemplateRuleSID | Unique system-generated sequential identifier for the loss modification template rule 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 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils. For a complete list of codes, see tPerilSet Table. | int | 4 |  | |||
| FinancialPerspectiveCode | Code that represents the financial perspectives. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | | |||
| Factor | The value that the Loss analysis engine uses to increases or decreases the Ground-Up losses. | decimal | 9 (9,4) | | |||
| RowTimeStamp | Used for time stamping. | timestamp | 8 | | |||
| LOBSQLString | SQL representation of the Line of Business. | varchar | 8000 | | |||
| EventFilter | XML string that defines the events to include in the rule definition. | xml | 0 | | |||
| SortOrder | Reserved for future use. | int | 4 | ((0)) | |||
| AppliesToCoverage | The coverage (A, B, C, and D) used as a filter in the rule definition. | varchar | 4 | | |||
| AdminBoundarySID | Unique system-generated sequential identifier for the custom administrative boundary record. This boundary is used as a filter in the rule definition. For a complete list of records, see tAdminBoundary Table. | int | 4 | | |||
| YearBuilt | Year the structure was built. | varchar | 8000 | | |||
| Stories | Number of stories in the structure. | varchar | 8000 | | |||
| ContractIDSQLString | SQL representation of the contract identifier. | varchar | 8000 | | |||
| LocationIDSQLString | SQL representation of the location identifier. | varchar | 8000 | | |||
| LocationUserDefined1 | The location user-defined field 1 to include in the rule definition. | varchar | 8000 | | |||
| ConstructionCode | Codes that represent the construction types to include in the rule definition. For a complete list of codes, see tAIRConstruction Table. | varchar | 8000 | | |||
| OccupancyCode | Codes that represent the occupancy types to include in the rule definition. For a complete list of codes, see dbo.tAIROccupancy Table. | varchar | 8000 | | |||
| GeographySID | Unique system-generated identifier for the geographic record to include in the rule definition. For a complete list of records, see tGeography Table. | int | 4 | | |||
| CountryCode | ISO 2-character codes for the countries to include in the rule definition. For a complete list of codes, see tCountry Table. | varchar | 15 | | |||
| CRESTAName | Names of the CRESTAs to include in the rule definition. For a complete list of codes, see tGeography Table. | varchar | 255 | | |||
| AreaName | Names of the areas to include in the rule definition. | varchar | 255 | | |||
| SubareaName | Names of the subareas to include in the rule definition. | varchar | 255 | | |||
| PostalCode | Postal codes to include in the rule definition. For a complete list of codes, see tGeography Table. | varchar | 15 | |
| Name | Description | Expression |
|---|---|---|
| ck_tLossModTemplateRule_SortOrder | ([SortOrder]>=(0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | 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. | 1 |
| 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. | 1 |
| 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 | |
|---|---|---|---|---|
| tAdminBoundary | Table | Stores information about the administrative boundaries available in Touchstone. Detailed information about the administrative boundaries is available in tAdminBoundaryDetail Table. | 1 |
| 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 |