AIRReference Database : tReinsuranceUNICEDELOB Table |
Stores the mappings between UNICEDE/2 lines of business (LOBs) and LOBs supported in Touchstone Re.
Touchstone uses the mappings when a user exports UNICEDE/2 data and associates the data to a company in Touchstone Re. For more information, see the Touchstone online help.
Creation Date | 4/7/2017 4:08 PM |
File Group | PRIMARY |
Text File Group | |
System Object | ![]() |
Published for Replication | ![]() |
Rows | 2561 |
Data Space Used | 136.00 KB |
Index Space Used | 16.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
Code | Reserved for future use. | varchar | 255 | ![]() | |||
LOBDescription | Reserved for future use. | varchar | 255 | ![]() | |||
CountryName | Name of the country associated with the LOB mapping. | varchar | 255 | ![]() | |||
Version | Version of UNICEDE/2 associated with the LOB mapping. | varchar | 255 | ![]() | |||
UNICEDELOB | UNICEDE/2 code for the LOB. | varchar | 100 | ||||
LOBCode | Code that represents the LOB in Touchstone Re. For a complete list of codes, see dbo.tReinsuranceLOB Table. | int | 4 | ![]() | |||
CountryID | Identifier for the country associated with the LOB. For a complete list of codes, refer to the UNICEDE/2 documentation. | int | 4 | ||||
![]() | SID | Unique system-generated sequential identifier for the LOB mapping. | int | 4 |