tChinaMPCIExposureRatio Table

Description

Stores values used to disaggregate exposures in China from the province (area) or city level to the county (subarea) level. The values are based on weighted averages developed using AIR's Industry Exposure Database.

For example, Touchstone Re may multiply the total exposure for each province, peril, and line of business by the ratios supplied in the table to determine the portion of the exposure to associate with each county. How Touchstone Re computes exposure depends on whether a user excluded any provinces or cities from the computation.

Properties

Creation Date	11/19/2018 12:20 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	123533
Data Space Used	7,744.00 KB
Index Space Used	64.00 KB

Columns

Column Name	Description	Datatype	Length
AreaGeographySID	Unique system-generated sequential identifier for the area to disaggregate. For a complete list of records, see tGeography Table.	int	4
SubareaGeographySID	Unique system-generated sequential identifier for the subarea associated with the ratio. For a complete list of records, see tGeography Table.	int	4
City	Name of the city associated with the ratio.	varchar	60
PerilSetCode	Numeric code for the peril or set of perils associated with the ratio. For a complete list of codes, see tPerilSet Table.	int	4
ExposureTypeCode	Code that represents the exposure type. For a complete list of codes, see tAggregateExposureType Table.	int	4
LOBCode	Code that represents the line of business. For a complete list of codes, see tReinsuranceLOB Table.	int	4
Ratio	Portion of the total exposure to associate with the subarea or city.	float	9

Related Objects

AIRGeography Database

Verisk Analytics Client Confidential

Please contact Verisk Analytics with questions or comments.