Stores the names of Applies to Area filters.
An Applies to Area filter specifies that a reinsurance treaty applies only to a given geographic area.
Touchstone Re 2022 Database Reference
tAppliesToArea Table
Stores the names of Applies to Area filters.
An Applies to Area filter specifies that a reinsurance treaty applies only to a given geographic area.
| Creation Date | 4/11/2022 6:17 PM |
| File Group | PRIMARY |
| Text File Group | |
| 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 | |
|---|---|---|---|---|---|---|---|
 | AppliesToAreaSID | Unique system-generated sequential identifier for the user-specified Applies to Area filter associated with a reinsurance treaty. | int | 4 | |||
| AppliesToAreaName | Name of the Applies to Area filter. | varchar | 255 |  |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAppliesToAreaGeoXRef | Table | Stores the geography and ceded amount associated with each Applies to Area filter. An Applies to Area filter specifies that a reinsurance treaty applies only to a given geographic area. | 1 |
| tAppliesToEventFilter | Table | Stores information about event filters. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 1 |
| tAppliesToEventFilterGeoXRef | Table | Stores information about event filters that include geographic areas. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tAppliesToEventFilterLatLong | Table | Stores information about event filters that include latitude and longitude pairs. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tAppliesToEventFilterRule | Table | Stores information about event filters that include event parameters, such as earthquake depth or hurricane central pressure. An event filter specifies that a reinsurance treaty applies only to events that meet certain criteria. You can create an event filter that includes event parameters, a latitude and longitude pair, or a list of areas. | 2 |
| tReinsuranceTreaty | Table | Stores information about reinsurance treaties included in reinsurance programs. | 1 |
| tReinsuranceTreatyReinstatement | Table | Stores information about reinstatement treaties included in reinsurance programs. | 1 |
| tReinsuranceTreatyTerrorismOption | Table | Stores information about the terrorism coverage for each reinsurance treaty. | 1 |
| tReinsuranceTreatyUDCClassification_Xref | Table | Stores relationships between user-defined categories (UDCs) and reinsurance treaties. | 1 |