CEDE 8.0 Database Reference
tReinsuranceUNICEDEUpgradeMapping Table
AIRReference Database : tReinsuranceUNICEDEUpgradeMapping Table
Description
Stores mappings between lines of business in previous versions of the UNICEDE/2 specification and the corresponding lines of business in the current version of the specification.
Properties
Creation Date2/14/2018 2:20 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows55843
Data Space Used4,520.00 KB
Index Space Used3,368.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryID

Identifier for the country associated with the LOB.

For a complete list of codes, refer to the UNICEDE/2 documentation.

int4   
Primary Key VersionVersion of UNICEDE/2 associated with the OldUnicedeCode.varchar20   
Primary Key OldUnicedeCodeUNICEDE/2 code for the LOB in a previous version of the UNICEDE/2 specification.varchar20   
Primary Key NewUnicedeCodeUNICEDE/2 code for the LOB in the current version of the UNICEDE/2 specification.varchar20   
Primary Key OldLobName of the LOB the LOB in a previous version of the UNICEDE/2 specification.varchar10   
Primary Key NewLobName of the LOB in the current version of the UNICEDE/2 specification.varchar10   
 WeightWeight of the LOB.float9  
 ExposureTypeIDIdentifier for the type of exposure associated with the LOB.tinyint1  
 IsAlternateGeo

Indicates whether the country associated with the LOB has alternate geocode.

  • Yes = 1 (alternate geocode selected)
  • No = 0 (alternate geocode not selected)
bit1   
See Also

Related Objects

AIRReference Database