China exposure source file guidelines

The exposure source file is used to input China exposures.

Note:

The file 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
Barley	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Corn	Sums Insured or Premium monetary value for this China agriculture line of business.	All remaining columns: Number in decimal format, but column is explicitly formatted as text.	O
Cotton	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Fruit trees	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Peanut	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Potato	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Rapeseed	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Rice	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Rubber	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Soybean	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Sugar	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Tobacco	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Wheat	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Crop Combined	Sums Insured or Premium monetary value for this China agriculture line of business.**		O
Forest: Fire	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Forest: Comprehensive	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Dairy Cattle	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Other Cattle	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Breeding Sow	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Other Pig	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Poultry	Sums Insured or Premium monetary value for this China agriculture line of business.		O
SheepGoat	Sums Insured or Premium monetary value for this China agriculture line of business.		O
Livestock Combined	Sums Insured or Premium monetary value for this China agriculture line of business.		O

** Excludes fruit trees, forestry, and livestock exposures.

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