Stores information about the geographic or area filter applied to each reinsurance treaty.
Reinsurance treaty geographic filters are optional.
CEDE 2025 (13.0) Database Reference
tReinsAppliesToGeo Table
Stores information about the geographic or area filter applied to each reinsurance treaty.
Reinsurance treaty geographic filters are optional.
| Creation Date | 05-06-2025 01:54 |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ReinsAppliesToGeoSID | Unique system-generated sequential identifier for the record that associates the reinsurance layer and geographic filter. | int | 4 | |||
| ReinsuranceSID | Unique system-generated sequential identifier for the reinsurance record. For a complete list of records, see tReinsurance Table. | int | 4 | ||||
| SQLString | SQL representation of the geographic filter. | varchar | 16 | ||||
| Expression | XML expression of the geographic filter. Used internally by Touchstone. | xml | 0 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tProgram | Table | Stores information about reinsurance programs. A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs. | 1 |
| tReinsurance | Table | Stores information about reinsurance treaties. A reinsurance program includes one or more related reinsurance treaties or layers. Reinsurance coverage applies to locations or treaties and not to reinsurance programs. | 1 |