CSV file for China MPCI custom ILF
Format requirements for the China MPCI custom industry loss file (ILF) file.
Column headers
The following header column is required in the following order.
Province
LOB
Crop-AllPerils-Franchise
Crop-AllPerils-Deductible
Drought-Franchise
Drought-Deductible
Flood-Franchise
Flood-Deductible
Wind-Franchise
Wind-Deductible
Frost-Franchise
Frost-Deductible
Heat-Franchise
Heat-Deductible
Livestock-Weather-Franchise
Livestock-Weather-Deductible
Livestock-Disease-Franchise
Livestock-Disease-Deductible
Livestock-Indemnity-Fraction-Culling
Input for each row
The input will be franchise and straight deductibles by province, crop, and peril. There is an All Perils option as well for crop.
Province: must be a valid China province.
LOB must be a supported crop (Corn, Cotton, Rapeseed, Rice, Soybean, Wheat, Barley, Peanut, Potato, Sugar, Rubber) or livestock type (Dairy Cattle, Other Cattle, Breeding Sow, Other Pig, Poultry, Sheep/Goat).
Deductibles columns must be a number between 0 and 1, inclusive.
Required
The following is required:
Header row
At least one body row.
Province + LOB combinations must be unique (e.g., cannot have two rows for Beijing Corn).
Peril-specific deductibles must be in pairs for a given peril. E.g., If Drought-Franchise is present, the Drought-Deductible must be also be present.)
For Livestock-Disease, all 3 are required (Franchise, Deductible, and Culling Fraction)
Each row must have the following:
LOB
If the LOB is a crop: one complete pair of terms for a crop sub-peril (e.g., Drought-Franchise + Drought-Deductible).
If the LOB is a livestock: one complete set of terms for a livestock sub-peril (i.e., Livestock-Weather-Franchise + Livestock-Weather-Deductible, OR, Livestock-Disease-Franchise + Livestock-Disease-Deductible + Livestock-Indemnity-Fraction-Culling).
Province
Optional for each row
If the LOB is a crop other franchise and deductible pairs (including AllPerils) are optional.
If the LOB is a livestock other sub-peril terms are options.
