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

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.

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 identifier for the event filter rule. int4   
 

Unique system-generated sequential identifier for the event filter.

For a complete list of records, see tAppliesToEventFilter Table.

int4  
 

Numerical code that represents the event parameter.

For a complete list of codes, see tEventFilterRuleAttribute Table.

int4   
 

Numerical code that represents the condition for the rule.

  • 0 = less than (<)
  • 1 = less than or equal to (<=)
  • 2 = not equal to (<>)
  • 3 = equal to (=)
  • 4 = greater than (>)
  • 5 = greater than or equal to (>=)
  • 6 = BETWEEN
  • 7 = NOT BETWEEN
int4   
 Parameter value.float9  
 Parameter value.float9  
Objects that tAppliesToEventFilterRule 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