Touchstone Re 2022 Database Reference
tRRRR_LOSS_DimGeography Table
AIRResultRe Database : tRRRR_LOSS_DimGeography Table
Description

Stores information about each geography record that generated loss during a loss analysis. Touchstone generates the table only for analyses that a user transferred to Touchstone Re using the company loss association feature.

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 geography record.

For a complete list of records, see tGeography Table.

int4   
 Internal identifier for the country.smallint2  
 Internal identifier for the area.smallint2  
 Internal identifier for the subarea.int4  
 

Indicates whether the GeographySID represents an offshore location.

  • 1 = Yes (offshore)
  • 0 = No (not offshore)
bit1   
See Also

Related Objects

AIRResultRe Database