Touchstone Re 2022 Database Reference
tAppliesToEventFilterLatLong Table
AIRExposureRe Database : tAppliesToEventFilterLatLong Table
Description

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.

Properties
Creation Date4/11/2022 6:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the event filter.

For a complete list of records, see tAppliesToEventFilter Table.

int4   
Primary Key Latitude coordinate associated with the event filter.numeric9 (9,6)   
Primary Key Longitude coordinate associated with the event filter.numeric9 (9,6)   
 Sequence order of the event filter.smallint2   
Objects that tAppliesToEventFilterLatLong depends on
 Database ObjectObject TypeDescriptionDep Level
tAppliesToArea tabletAppliesToAreaTable

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.

2
tAppliesToEventFilter tabletAppliesToEventFilterTable

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
tCompany tabletCompanyTableStores information about companies.3
tReinsuranceProgram tabletReinsuranceProgramTableStores information about reinsurance programs.2
tReinsuranceTreaty tabletReinsuranceTreatyTableStores information about reinsurance treaties included in reinsurance programs.1
See Also

Related Objects

AIRExposureRe Database