System reference table used to determine the perils that are associated with a country.
Touchstone Re 2022 Database Reference
tCountryPerilXref Table
| Creation Date | 7/24/2012 12:08 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 272 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | |||
| | MainPerilSetCode | Code that represents the peril set. For a complete list of codes, see tPerilSet Table. | int | 4 | |||
| CombinedPerilSetCode | Code for the combined peril set that is available for use in the country. For a complete list of codes, see tPerilSet Table. | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tPerilSet | Table | Stores codes that represent the perils sets supported by the application. Additional peril sets used by Touchstone Re are listed in tPerilSetCombined Table. | 1 |