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.

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	Default
AppliesToEventFilterSID	Unique system-generated sequential identifier for the event filter.	int	4
ReinsuranceTreatySID	Unique system-generated identifier for the reinsurance treaty associated with the event filter. For a complete list of records, see tReinsuranceTreaty Table.	int	4
FilterName	Name of the event filter.	varchar	255
GeoSelected	Code that specifies the type of geographic area identifier associated with the event filter: 1 = Geography 0 = Lat/Long	bit	1	((0))

Database Object	Object Type	Description	Dep Level
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

Database Object

Object Type

Description

Dep Level

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

Database Object	Object Type	Description	Dep Level
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.	2
tCompany	Table	Stores information about companies.	3
tReinsuranceProgram	Table	Stores information about reinsurance programs.	2
tReinsuranceTreaty	Table	Stores information about reinsurance treaties included in reinsurance programs.	1

Related Objects

AIRExposureRe Database