search

OasisLMF / ODS_OpenExposureData

Open data standards curated by Oasis.
62 stars 8 forks source link

Add new modifier StaticMotorVehicle in Location file #4

Closed rtahiry closed 3 years ago

rtahiry commented 4 years ago

It would be helpful to have an new column 'StaticMotorVehicle' in the location file. This modifier primarily applies to motor vehicle exposures e.g. to differentiate a risk that is dynamic (e.g. moving from postcode to postcode for commute) and a risk that is static (e.g. a car yard or dealership store).

column name: StaticMotorVehicle datatype: boolean (0 or 1) meaning: 0 means the risk is a dynamic motor exposure, 1 means the risk is a static motor exposure default value: 0

aiste-kalinauskaite commented 4 years ago

Please allow blank in this field (blanks to default to 0). In SQL DB, this field would go into LocationDetails table.

MattDonovan82 commented 4 years ago

is this merely an update to the input files to include this field?

aiste-kalinauskaite commented 4 years ago

This is an update to the input files and to SQL DB. The rest would be done by modellers, of they choose to use the field.

MattDonovan82 commented 4 years ago

Hi Tahiry, Apologies its been a while to respond to this - the ODS implementation/updates are still a work in progress.

We've had some discussion on this today and would an extra construction code for 'static motor vehicles/car dealership' suffice here? This would be the preferred option rather than creating a specific header in the loc file?

MattDonovan82 commented 4 years ago

@rtahiry not sure if you saw this last comment?

rtahiry commented 4 years ago

Hi @MattDonovan82 ,

No problem and my apologies as well for the long delay in replying, I was on leave for a while.

We've been thinking about this and it might be good in the long run to have the 'static motor vehicles' to be independent from 'construction code'. The reason is that 'static motor vehicles' can be used for risks other than car dealerships. Moreover, we may want to model portfolios with risks of the same 'construction code' but where static motor vehicles is switched on and off. We have already needed to do this in our native workbench platform, and we introduced a separate column for this in our own input format. In HailAUS, the statistical movement of car motor vehicles are captured by the model. However, some clients portfolio also contain marine crafts and since we don't model their dynamics, we assume these to be static as well. So in this case, the field 'static motor vehicle' should be independent of the construction code. This way, other model vendors can use or ignore it while the construction code remains intact.

MattDonovan82 commented 3 years ago

@benhayes21 It seems reasonable to include this field in OED. What do you think?

MattDonovan82 commented 3 years ago

Added to data spec v1.1.3 in develop branch