Exposure Source File

The exposure source file for China disaggregation must be in CSV format.

Columns must be explicitly formatted as "text".
All columns and headers must be present and spelled correctly.
Only one worksheet can be imported at a time.

The first two lines should contain only column specifications for currency. This information is mandatory. Currency must be set to CNY (Chinese Yuan Renminbi) and Units must be set to Ones.


Currency	Units
CNY	Ones

Exposure Worksheet Columns


Header	Description	Format	Data Mandatory/Optional
Include	Exposure site name*: province, city, or county	Text	M
Exclude	Exposure subarea name to be excluded from the exposure disaggregation. In case more than one subarea is to be excluded, the semicolon (";") is used as the separator. Note: The Exclude field must contain areas at a higher resolution than the Include field if disaggregation is enabled.	Text	O
Corn	Sums Insured or Premium monetary value for this China MPCI line of business.	Columns 3 – 13: Number in decimal format, but column is explicitly formatted as text.	O
Cotton	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Rapeseed	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Rice	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Soybean	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Wheat	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Barley	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Peanut	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Potato	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Sugar	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Rubber	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Crop Combined	Sums Insured or Premium monetary value for this China MPCI line of business.**		O
Forestry	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Dairy Cattle	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Other Cattle	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Breeding Sow	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Other Pig	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Poultry	Sums Insured or Premium monetary value for this China MPCI line of business.		O
SheepGoat	Sums Insured or Premium monetary value for this China MPCI line of business.		O
Livestock Combined	Sums Insured or Premium monetary value for this China MPCI line of business.		O

* Refer to the Country Abbreviations CATRADER Version x.x document on AIR Client Portal.

** Excludes Forestry crop.

*** CAREAR: Construction All Risks/Erection All Risks