CEDE 9.0 Database Reference
tCountryPerilXref Table
AIRReference Database : tCountryPerilXref Table
Description
System reference table used to determine the perils that are associated with a country.
Properties
Creation Date7/24/2012 12:08 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows272
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key 

Code that represents the peril set. 

For a complete list of codes, see tPerilSet Table.

int4   
 

Code for the combined peril set that is available for use in the country.

For a complete list of codes, see tPerilSet Table.

int4   
Objects that tCountryPerilXref depends on
 Database ObjectObject TypeDescriptionDep Level
tPerilSet tabletPerilSetTable

Stores codes that represent the perils sets supported by the application.

1
See Also

Related Objects

AIRReference Database