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 |
** Excludes Forestry crop.
*** CAREAR: Construction All Risks/Erection All Risks
