System reference table used to determine the perils that are associated with a country.
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. | 1 |