Touchstone 4.0 Database Documentation
tUNICEDE2LineofBusiness Table
Description

Stores information regarding Line of Business types that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business type codes in Touchstone.

Properties
Creation Date1/10/2012 12:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows61
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key UNICEDE2LineofBusinessCode

Code that represents the UNICEDE/2 Line of Business.

  • 6 = AUTO (Automobile)
  • 7 = VO (Villa Owners)
  • 8 = BO (Building Owners)
  • 9 = DR (Dwelling Risks)
  • 10 = SH (Summer Houses)
  • 11 = AR (Agricultural Risks)
  • 12 = CIB (Commercial & Industrial Buildings)
  • 13 = CIC (Commercial & Industrial Contents)
  • 16 = AG (Agriculture)
  • 19 = RC (Residential Contents)
  • 35 = PAL (Personal Allied Lines)
  • 36 = PFR (Personal Fire)
  • 37 = PHO (Home owners)
  • 38 = PFO (Farm owners)
  • 39 = PIM (Personal Inland Marine)
  • 40 = PEQ( Personal Earthquake)
  • 41 = PAU (Personal Automobile)
  • 42 = MHO (Mobile Homeowners)
  • 43 = CAL (Commercial Allied Lines)
  • 44 = CFR (Commercial Fire)
  • 45 = CMP (Commercial Multiperil)
  • 46 = CIM (Commercial Inland Marine)
  • 47 = CEQ (Commercial Earthquake)
  • 48 = CAU (Commercial Automobile)
  • 49 = PER (Personal)
  • 50 = COM (Commercial)
  • 51 = BLD (Residential Building)
  • 52 = APT (Residential Apartments)
  • 53 = IND (Industrial)
  • 54 = HTL (Hotels)
  • 55 = GH (Guest Houses)
  • 58 = SHP (Comprehensive Shops)
  • 59 = WH (Warehouse)
  • 60 = CNT (Residential Contents)
  • 63 = DWB (Dwelling Building)
  • 64 = DWC (Dwelling Contents)
  • 65 = APTB (Apartment Building)
  • 66 = APTC (Apartment Contents)
  • 69 = COMB (Commercial & Industrial Buildings)
  • 70 = COMC (Commercial & Industrial Contents)
  • 71 = ITE (Business Interruption)
  • 72 = HSHB (Household Building)
  • 73 = HSHC (Household Contents)
  • 74 = FAL (Fire & Allied Lines)
  • 75 = ENG (Engineering)
  • 80 = GOVH (Government Housing)
  • 81 = CWC (Workers' Compensation)
  • 82 = CAI (Commercial & Industrial)
  • 83 = GRH (Greenhouses)
  • 84 = ANG (Agriculture w/o Greenhouses)
  • 85 = RB (Residential Building)
  • 86 = RBC (Residential Building & Contents)
  • 87 = RES (Residential)
  • 88 = MO (Mobile Home)
  • 89 = PD (Physical Damage)
  • 90 = ROD (Removal of Debris)
  • 91 = OEE (Operator's Extra Expenses)
  • 92 = BI (Business Interruption)
  • 93 = FOR (Forestry)
  • 94 A= UT (Japan Automobile)
  • 95 = CML (Commercial)
UnsignedTinyInt1   
 UNICEDE2LineofBusiness

Name of the UNICEDE/2 Line of Business.

Corresponds to the code in UNICEDE2LineofBusinessCode.

VarChar40   
 Description

Description of the UNICEDE/2 Line of Business.

Corresponds to the code in UNICEDE2LineofBusinessCode.

VarChar1024  
Objects that depend on tUNICEDE2LineofBusiness
 Database ObjectObject TypeDescriptionDep Level
tUNICEDE2CountryLOBXref tabletUNICEDE2CountryLOBXrefTable

System reference table used to identify the Line of Business by country that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business by country codes in Touchstone.

1
tUNICEDE2CoverageLOBXref tabletUNICEDE2CoverageLOBXrefTable

System reference table used to identify the Line of Business by coverage that can be used in UNICEDE/2. This information is used to enable the use of the UNICEDE/2 Line of Business by coverage codes in Touchstone.

1
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.