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

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.

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 user-specified Applies to Area filter associated with a treaty.

For a complete list of records, see tAppliesToArea Table.

int4   
Primary Key 

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

int4   
 

Ceded percentage expressed as a decimal, for example .3, which corresponds to 30%.

CededPercent appears as a percentage in the user interface but is stored in the database as a decimal.
float9  
Objects that tAppliesToAreaGeoXRef 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
See Also

Related Objects

AIRExposureRe Database