Touchstone Re 2022 Database Reference
tModelCTGeoLevelMapping Table
AIRReference Database : tModelCTGeoLevelMapping Table
Description

Stores information how geocode levels are aggregated for each model.

Touchstone uses the information for company loss file (CLF) exports of detailed loss data for CATRADER.

Properties
Creation Date10/30/2018 9:13 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows241
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the model in Touchstone.

For a complete list of codes, see tModel Table.

smallint2   
Primary Key 

Area Level 1 code where the location resides. 

tinyint1   
 

Resolution of aggregate Level 1 (country) data for mapping between Touchstone and CATRADER.

tinyint1   
 

Resolution of aggregate Level 2 (area) data for mapping between Touchstone and CATRADER.

tinyint1   
 

Resolution of aggregate Level 3 (subarea) data for mapping between Touchstone and CATRADER.

tinyint1   
Objects that tModelCTGeoLevelMapping depends on
 Database ObjectObject TypeDescriptionDep Level
tModel tabletModelTableStores information about the models that are available in Touchstone.1
See Also

Related Objects

AIRReference Database