CEDE 8.0 Database Reference
tCountryILOBs Table
Description
Stores the industry lines of business (LOBs) supported for each country and peril set combination.
Properties
Creation Date12/4/2017 6:19 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3675
Data Space Used120.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 tCountryILOBIDIdentifier for the country and line of business combination.bigint8  
 CountryCode

ISO 2-character code for the country.

For a complete list of codes, see tCountry Table.

varchar15   
 CTPerilsetCodeCATRADER code that represents the peril set associated with the country and line of business combination.int4   
 INFVersionVersion of the INF file associated with the country and line of business combination.tinyint1   
 IndustryLineOfBusinesscodeCode that represents the line of business.tinyint1   
 IndustryLobOrder

Line of business order.

Used internally by the application.

tinyint1   
 InternalCountryCodeInternal identifier for the country.smallint2  
See Also

Related Objects

AIRReference Database