Additional OED Codes - Githubissues

MattDonovan82 commented 2 years ago

GC are proposing the additional codes for Occupancy, Roofcover and Geogscheme to be included into OED:

Geogschemes: UPRN - UK Property reference number (created by Ordnance Survey) EIRCODE - For Republic of Ireland

Roofcover: 26 - Thatch 27 - Felt 28 - Zinc

Occ codes: 1070 - Residential, Detached house 1071 - Residential, Semi-detached house. Attached residential unit. Shares a single common party wall, common type in UK/Ireland. 1072 - Residential, end terrace house. Attached residential unit. Used for end of row houses with additional end gable exposure to wind 1073 - Residential, Bungalow. Detached residential unit. One story, often with dormer roof. For semi-detached and terraced bungalows use those codes with single storey coding.

MattDonovan82 commented 2 years ago

I don't see any issues with these, except whether the proposed 1070 code for "detached house" would fall under the current 1051 for 'Residential, Permanent dwelling: single-family' which specifies "detached dwellings" in the description.

MattDonovan82 commented 2 years ago

@carlholden can you review this?

PaulLDJones commented 2 years ago

A separate and distinct 'Detached Properties only' is required for data interopability purposes. In practice the code 1051 (Residential, Permanent dwelling: single-family) and its equivalent in other model schemes is used as a more general catch all class for SFD.

MattDonovan82 commented 2 years ago

Thanks @PaulLDJones. We generally want to avoid duplication but as you state, this is for specific detached properties so should differentiate enough.

Thoughts @aiste-kalinauskaite @jones-matt @johcarter @benhayes21

johcarter commented 2 years ago

Hi @MattDonovan82 you raise a good point about duplication from the model developer perspective. Both 1051 and 1070 would be valid choices to describe a single detached house, say, and you could have some models that prefer to use the new 1070 codes because the extra detail is important for the modelling of risk (say for flood), and other models use the existing code 1051. Leading to different codes needed in exposure inputs for different models, which could get messy.

I suggest adding to the description of 1051 - "unknown property type" to encourage people to use the new codes where the property type is known.

For models where the property type is not relevant to vulnerability, map new 107X codes and 105X codes to the same vulnerability type.

For models where the property type is relevant to vulnerability, use the new 107X codes and map 1051 to a "property type unknown" vulnerability, ie a whatever the suitable default is.

johcarter commented 2 years ago

its just been brought to my attention that OED already supports property type via the BuildingType field.

MattDonovan82 commented 2 years ago

ok great. This would then make a better option? @PaulLDJones

PaulLDJones commented 2 years ago

@johcarter @MattDonovan82 this is known and we looked at it. However for translation between differing modelling vendor codes (external to OASIS) this makes the process cumbersome with some models holding specific occupcancies and some models using combinations of occupancy and building type. To a certain extent the extra building type field is a bit of a duplicate of occupancy.

johcarter commented 2 years ago

In view of that, I think extending the OED codes to include building types will make it easier for conversions into OED, lead to better information about exposures used by models. I would suggest deprecating BuildingType.

MattDonovan82 commented 2 years ago

@PaulLDJones in the interest of clarity, for occ code 1073 (bungalows), when you say "use those codes with single story coding", I assume you mean that when coding a semi-detached bungalow for example, it would be coded as occ code 1071 but with '1' NumberOfStoreys?

MattDonovan82 commented 2 years ago

@PaulLDJones please review the attached - changes highlighted in yellow in 'Occupancy Values' and 'Other Values' tab. Please add any examples for the new geogschemes. Thanks. OpenExposureData_Spec_edit_MD.xlsx

PaulLDJones commented 2 years ago

Matt

Yes, it’s about the roof form and common walls rather than the height as the primary descriptor.

Regards

Paul Jones, Head of UK Client Data Services, Global Strategic Advisory

Guy Carpenter | Global Strategic Advisory Tower Place, London, EC3R 5BU

+44 (0)20 7357 3640 | +44 (0)7392 122023 | @.**@.> @.***

A business of Marsh McLennan

The data and analysis provided by Guy Carpenter herein or in connection herewith are provided as is, without warranty of any kind whether express or implied. Neither Guy Carpenter, its affiliates nor their officers, directors, agents, modelers, or subcontractors (collectively, Providers) guarantee or warrant the correctness, completeness, currentness, merchantability, or fitness for a particular purpose of such data and analysis. In no event will any Provider be liable for loss of profits or any other indirect, special, incidental and/or consequential damage of any kind howsoever incurred or designated, arising from any use of the data and analysis provided herein or in connection herewith

From: MattDonovan82 @.> Sent: 16 June 2022 14:13 To: OasisLMF/OpenDataStandards @.> Cc: Jones, Paul L @.>; Mention @.> Subject: Re: [OasisLMF/OpenDataStandards] Additional OED Codes (Issue #68)

@PaulLDJoneshttps://urldefense.com/v3/__https:/github.com/PaulLDJones__;!!O7V3aRRsHkZJLA!BzfYMjNG-G4W0l8oL8V94o9n-wI_OspjhVhqV2vrwjxItBabMoz5V76aPX2aoFjgkqXI_lEU1FfJBqOcGvmbqjqmBtA$ in the interest of clarity, for occ code 1073 (bungalows), when you say "use those codes with single story coding", I assume you mean that when coding a semi-detached bungalow for example, it would be coded as occ code 1071 but with '1' NumberOfStoreys?

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/OasisLMF/OpenDataStandards/issues/68*issuecomment-1157646640__;Iw!!O7V3aRRsHkZJLA!BzfYMjNG-G4W0l8oL8V94o9n-wI_OspjhVhqV2vrwjxItBabMoz5V76aPX2aoFjgkqXI_lEU1FfJBqOcGvmbRlG8miU$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AZUPK33OTNVWQ7OBMH5M7L3VPMR6PANCNFSM5XKZCPDA__;!!O7V3aRRsHkZJLA!BzfYMjNG-G4W0l8oL8V94o9n-wI_OspjhVhqV2vrwjxItBabMoz5V76aPX2aoFjgkqXI_lEU1FfJBqOcGvmb6C1kKpY$. You are receiving this because you were mentioned.Message ID: @.**@.>>

Business conducted on behalf of non-EEA domiciled clients is undertaken by Guy Carpenter & Company Limited.

Guy Carpenter & Company Limited is a company incorporated and registered in England and Wales with company number: 335308, whose registered office is at 1 Tower Place West, Tower Place, London, EC3R 5BU, United Kingdom.

Guy Carpenter & Company Limited is an appointed representative and agent of Marsh Ltd which is authorised and regulated in the United Kingdom by the Financial Conduct Authority (FCA).

Please note Guy Carpenter & Company Limited also trades as Healthcare Risk Partners, Guy Carpenter and GC Fac.

Business conducted on behalf of EEA domiciled clients is undertaken by Guy Carpenter & Company GmbH (London Branch).

Guy Carpenter & Company GmbH (London Branch) is located at 1 Tower Place West, London EC3R 5BU, and is a registered branch of Guy Carpenter & Company GmbH, registry court: Munich HRB 95354, with its registered seat at Munich, Germany. Managing Director: Axel Flöring. Competent supervisory authority: Munich Chamber of Industry and Commerce in Germany (IHK München) Register number: D-2QJI-HQV9W-81

Guy Carpenter & Company GmbH has entered into the UK's Temporary Permissions Regime and is deemed to be authorised and regulated by the Financial Conduct Authority until such time as full authorisation is granted. Details of the Temporary Permissions Regime which allows EEA-based firms to operate in the UK are available on the Financial Conduct Authority’s website.

Please note Guy Carpenter & Company GmbH (London Branch) also trades as Guy Carpenter and Healthcare Risk Partners.

Guy Carpenter is unable to provide insurance or reinsurance broking, risk consulting, claims or other services or provide any benefit to the extent that the provision of such services or benefit would violate applicable law or expose Guy Carpenter or its affiliates to any sanction, prohibition or restriction under UN Security Council Resolutions or under other trade or economic sanctions laws or regulations

If you are interested in how we use your personal information and how you may exercise your rights in respect of that information, please refer to the Guy Carpenter Privacy Notice https://www.guycarp.com/privacy-policy.html

The transmission of any information relating to, inter alia, placement of any re/insurance business shall be treated as confidential and neither the sender nor the recipient will disclose it to any other person not entitled to receive such information except as may be necessary to fulfill their respective obligations in the conduct of the re/insurance business and except as may be required by law or regulatory authority.

Any specific confidentiality agreement for any particular re/insurance placement or business will take precedence over the general language above.

This message and any attachments are confidential. If you have received this message in error please delete it from your system. If you require any assistance please notify the sender. Thank you.

carlholden commented 2 years ago

Hi all,

Interesting thread - from a modelling pov, a bungalow should always be 1 storey of course, but can also be detached and semi-detached as well (and let’s not ignore loft conversions!). My guess is there may not be a perfect solution, its just a case of how model developers build the vulnerabilities as well as how cat modellers code up exposure information etc., and matching the two.

Hope that’s helpful.

Thanks,

Carl

On 16 Jun 2022, at 14:21, PaulLDJones @.***> wrote: