Program source file guidelines

Guidelines for the program source file for China disaggregation.

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.

  • You can import only one worksheet at a time.

The first two lines should contain only the following mandatory specifications, where currency must be set to CNY (Chinese Yuan Renminbi) and Units must be set to Ones.

The mandatory Crop LOB filters (CornLOB, CottonLOB, etc.) appear in the Program pane's China Agriculture Filter dialog box and are applied during program disaggregation. If the format is set to 1 (covered) in the Program Workbook, the filter percentage applied is set to 100%. If the format is set to 0 (not covered), the filter percentage applied is set to 0%.

Program worksheet columns

Header

Description

Format

Data Mandatory/Optional

ProgramName

Name of program

Text

M

BarleyLOB

LOB Filter

1-covered, 0-not covered

M

CornLOB

LOB Filter

1-covered, 0-not covered

M

CottonLOB

LOB Filter

1-covered, 0-not covered

M
FruitTreesLOB LOB Filter

1-covered, 0-not covered

 M

PeanutLOB

LOB Filter

1-covered, 0-not covered

M

PotatoLOB

LOB Filter

1-covered, 0-not covered

M

RapeseedLOB

LOB Filter

1-covered, 0-not covered

M

RiceLOB

LOB Filter

1-covered, 0-not covered

M

RubberLOB

LOB Filter

1-covered, 0-not covered

M

SoybeanLOB

LOB Filter

1-covered, 0-not covered

M

SugarLOB

LOB Filter

1-covered, 0-not covered

M
TobaccoLOB LOB Filter

1-covered, 0-not covered

 M

WheatLOB

LOB Filter

1-covered, 0-not covered

M

CombinedLOB

LOB Filter

1-covered, 0-not covered

M
ForestFireLOB LOB Filter

1-covered, 0-not covered

 M

ForestComprehensiveLOB

LOB Filter

1-covered, 0-not covered

M

DairyCatlleLOB

LOB Filter

1-covered, 0-not covered

M

OtherCattleLOB

LOB Filter

1-covered, 0-not covered

M

BreedingSowLOB

LOB Filter

1-covered, 0-not covered

M

OtherPigLOB

LOB Filter

1-covered, 0-not covered

M

PoultryLOB

LOB Filter

1-covered, 0-not covered

M

SheepGoatLOB

LOB Filter

1-covered, 0-not covered

M

LivestockCombinedLOB

LOB Filter

1-covered, 0-not covered

M

ContractName

Name of the contract (contract ID)

Text

M

Site

Area name: province, city, or county

Text

M

Limit%

The excess of loss expressed as a % premium

100%; 100; (blank)** Column explicitly formatted as text

O

Retention%

Excess of loss retention expressed as a % of premium

50%; 50; (blank)* Column explicitly formatted as text

O

Participation%

Coinsurance

90%;90; blank Column explicitly formatted as text

O

Premium

Premium amount for the site specified.

Numeric non-negative Column explicitly formatted as text

O

CropDrought

Agriculture peril

1-covered 0-not covered Column explicitly formatted as text

M

CropFlood

Agriculture peril

M

CropWind

Agriculture peril

M

CropHeat

Agriculture peril

M

ForestryOther

Agriculture peril

ForestFire

Agriculture peril

M

ForestComprehensive

Agriculture peril

M

LivestockWeather

Agriculture peril

M

LivestockDisease

Agriculture peril

M

Disaggregate

Defined disaggregate option that must have a geographical resolution finer than the area in the "Site" column. If left blank, no disaggregation is performed.

City, county, or blank

O

Exclude

The subarea name excluded from the list of the disaggregated subareas.

City, county, or blank

O

* A blank is assumed to be no retention (i.e., 0).

** A blank is assumed to be no limit.