Stores internal area and subarea mappings for each geography.
Touchstone Re 2022 Database Reference
tReinsuranceInternalCodeMapping Table
| Creation Date | 6/13/2017 11:47 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 22206 |
| Data Space Used | 1,368.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of codes, see tGeography Table. | int | 4 | |||
| IntLevelID | Identifier for the geographic resolution of the data.
| int | 4 | ||||
| IntLevel1 | Country code. | int | 4 | ||||
| IntLevel2 | Area code. | int | 4 |  | |||
| IntLevel3 | Subarea code. | int | 4 | | |||
| StrLevel2 | Area code. | varchar | 15 | | |||
| StrLevel3 | Subarea code. | varchar | 15 | | |||
| intAltCode1 | Alternative numeric code for the level 1 geographic resolution. | smallint | 2 | | |||
| intAltCode2 | Alternative numeric code for the level 2 geographic resolution. | smallint | 2 | | |||
| intAltCode3 | Alternative numeric code for the level 3 geographic resolution. | smallint | 2 | | |||
| strAltCode1 | Alternative string code for the level 1 geographic resolution. | varchar | 10 | | |||
| strAltCode2 | Alternative string code for the level 2 geographic resolution. | varchar | 10 | | |||
| AreaScheme | Code that represents the area scheme for the country. The area scheme is the hierarchy of geographic resolutions for the country. For example, the area scheme for a country may specify that the country is organized by country, state, county, and then ZIP code. | smallint | 2 | | |||
| MaxSub | Maximum number of locations associated with the record. | int | 4 |