Stores the geographic reference mapping identifiers between Touchstone and Touchstone Re.
Touchstone 2022 Database Reference
tReinsuranceGeographyTSXref Table
Stores the geographic reference mapping identifiers between Touchstone and Touchstone Re.
| Creation Date | 3/1/2020 10:27 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 19 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | tReinsuranceGeographyTSXrefID | Unique system-generated sequential identifier for the geography reference record. | int | 4 | |||
| TS_GeographySID | Unique system-generated sequential identifier in Touchstone for the geographic record. | int | 4 | ||||
| TSRe_GeographySID | Unique system-generated sequential identifier in Touchstone Re for the geographic record. | int | 4 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tGeography | Table | Stores the post-validation geographical area information that the application displays on the user interface. After you import exposure data, the application writes the data to TblAreaExternal Table and validates the data using the airsp_ValidateArea stored procedure. Then, the application updates the records in tGeography to match the content of TblAreaExternal. | 1 |