Stores mappings between previously supported area schemes and currently supported area schemes.
Touchstone Re 2022 Database Reference
tReinsuranceLegacyAreaExposureUpgrade Table
| Creation Date | 11/20/2019 4:11 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 89121 |
| Data Space Used | 4,928.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| intOldAreaLevel1 | Internal identifier for a previously supported area level 1 (country). | int | 4 | ||||
| intOldAreaLevel2 | Internal identifier for a previously supported area level 2 (area). | int | 4 | ||||
| intOldAreaLevel3 | Internal identifier for a previously supported area level 3 (subarea). | int | 4 |  | |||
| intNewAreaLevel1 | Internal identifier for the corresponding currently supported area level 1 (country). | int | 4 | ||||
| intNewAreaLevel2 | Internal identifier for the corresponding currently supported area level 2 (area). | int | 4 | ||||
| intNewAreaLevel3 | Internal identifier for the corresponding currently supported area level 3 (subarea). | int | 4 | | |||
| LOBCode | Code that represents a line of business supported for the area scheme. For a complete list of codes, see tReinsuranceLOB Table. | int | 4 | ||||
| LobsWeight | Weight of the LOB. Used internally. | float | 9 | | |||
| LegacyFileVersion | Version of the previously supported area scheme. | tinyint | 1 | | |||
| OldGeographySID | Unique system-generated sequential identifier for the old geography record. | int | 4 | | |||
| NewGeographySID | Unique system-generated sequential identifier for the new geography record. | int | 4 | |