tUNICEDE2LineofBusiness Table

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.

Creation Date	1/10/2012 12:17 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	62
Data Space Used	8.00 KB
Index Space Used	8.00 KB

Column Name	Description	Datatype	Length
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)	tinyint	1
UNICEDE2LineofBusiness	Name of the UNICEDE/2 Line of Business. Corresponds to the code in UNICEDE2LineofBusinessCode.	varchar	40
Description	Description of the UNICEDE/2 Line of Business. Corresponds to the code in UNICEDE2LineofBusinessCode.	varchar	1024

Column Name

Description

Datatype

Length

Allow Nulls

Default

Formula

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)

tinyint

1

UNICEDE2LineofBusiness

Name of the UNICEDE/2 Line of Business.

Corresponds to the code in UNICEDE2LineofBusinessCode.

varchar

40

Description

Description of the UNICEDE/2 Line of Business.

Corresponds to the code in UNICEDE2LineofBusinessCode.

varchar

1024

	Database Object	Object Type	Description	Dep Level
	tUNICEDE2CountryLOBXref	Table	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	Table	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

Related Objects

AIRReference Database