[Cyber] Refactoring of coverage_code and coverage financial terms #215
Description
Description
CoverageValues is a new sheet/csv file in OED V4. It is there to describe more formally the coverage id and coverage code for all class of business. Historically those information were implicit in the naming convention of the financial terms associated with coverage.
the following list will give some examples of "coverage terms":
for location
LocDedCode1Building
LocDedType1Building
LocDed1Building
LocMinDed1Building
LocMaxDed1Building
LocDedCode2Other
LocDedType2Other
LocDed2Other
for condition:
CondDedCode1Building
CondDedType1Building
CondDed1Building
CondMinDed1Building
CondMaxDed1Building
CondDedCode2Other
CondDedType2Other
CondDed2Other
As we can see in CoverageValues those implicit name have been translated to
CoverageID CoverageCode
1 1Building
2 2Other
3 3Contents
4 4BI
5 5PD
6 6All
and the new coverage for Cyber have been added but with a slightly different naming convention
7 BI
8 CBI
9 DIAS
10 EXT
11 FIN
12 INRE
13 LIAB
14 REG
15 ENO
16 CYB
I would like to take advantage of the change of major version to refactor the name of the coverages codes and the associated financial terms.
The new CoverageValues file will be like this.
CoverageValues.csv
In particular the most important change is the renaming of the property coverage codes and will imply the renaming of the financial terms.
To explain with an example,
From the name LocDedCode1Building, we extracted the coverage values => 1Building
I would like to change the coverage value to BLD instead of 1Building
and have the same naming convention as the cyber coverage
so LocDedCode1Building => LocDedCodeBLD
same for all coverage level terms (loc, cond, pol, acc)
I also would like to add an extra column SubCoverages in order to describe how coverage should be grouped for higher level terms.
Reasons for change
- its always nice to have a consistent naming convention
- This modification help removing the potential confusion between property 4BI and cyber BI. Each will have it's own explicit code readable without prior knowledge
- It simplify the tooling to interpret each financial terms and may remove the necessity for hard-coding certain rules on third party provider (oasislmf)
Scope of change
- Location File
- Accounts File
- Reinsurance Scope
- Reinsurance Info
Impact of change
If accepted, ODS tool will provided an oed3-to-oed4 converter and the capability to seamlessly load oed3 file as oed4 ,or load an oed4 file as an oed 3 file.
So there will be no impact on existing oed exposure going through ods_tools.
Metadata
Assignees
Type
Projects
Status
Done