Stores codes, descriptions, and groupings of the peril codes generated in Touchstone.
CEDE 9.0 Database Reference
tSEQUELImpactSubPerilGroupingXRef Table
| Creation Date | 10/20/2020 10:10 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 14 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
 | SubPerilGroupingSID | Represents a unique sequential identifier associated with the sub peril for grouping peril codes. | int | 4 | |||||||||||||||||||||||||||||||||
| TouchstonePerilCode | Code that represents the peril codes generated in Touchstone.
| char | 3 | ||||||||||||||||||||||||||||||||||
| PerilGroup | Represents the group in which the Touchstone peril codes are organized.
| varchar | 1024 | ||||||||||||||||||||||||||||||||||
| Description | Name of the Touchstone peril code.
| varchar | 1024 |  | |||||||||||||||||||||||||||||||||
| WriteToTSAs | Represents the description of the peril code in Touchstone. | varchar | 1024 | |