Touchstone Re 2022 Database Reference
tChinaMPCIAreaRatio Table
AIRGeography Database : tChinaMPCIAreaRatio Table
Description

Stores values used to disaggregate program data in China from the province (area) or city level to a higher resolution. The values are based on weighted averages developed using AIR's Industry Exposure Database.

For example, Touchstone Re uses the ratios supplied in the table to disaggregate premiums, define limits and retentions by county or city, and so on.

Properties
Creation Date11/19/2018 12:20 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows6087
Data Space Used688.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AreaGeographySID

Unique system-generated sequential identifier for the area.

For a complete list of records, see tGeography Table.

int4   
Primary Key SubareaGeographySID

Unique system-generated sequential identifier for the subarea.

For a complete list of records, see tGeography Table.

int4   
Primary Key CityName of the city.varchar60   
Primary Key DisaggregationLevel

Code that represents the type of disaggregation associated with the ratio.

  • 1 = Province to city
  • 2 = Province to county
  • 3 = City to county
int4   
 RatioPortion of the program data to associate with the subarea or city.float9   
See Also

Related Objects

AIRGeography Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.