CEDE 8.0 Database Reference
tReinsAppliesToGeo Table
| AIRReinsurance Database : tReinsAppliesToGeo Table |
Stores information about the geographic or area filter applied to each reinsurance treaty.
Reinsurance treaty geographic filters are optional.
| Creation Date | 5/19/2020 4:05 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 5 |
| Data Space Used | 8.00 KB |
| Index Space Used | 40.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 | 16 |
| 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. | 2 |
| 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 |