OasisLMF / ODS_OpenExposureData

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

Extending the length of LocUserDefx fields in Loc file #77

Closed michael-fehlmann closed 1 year ago

michael-fehlmann commented 2 years ago

In the current OED specification, LocUserDef1, ..., LocUserDef5 in the Loc file are defined as varchar(20). For our integration, we are using these fields to pass some internal codes. We are planning to use some UIDs which exceed the 20 characters. Could this definition be altered to support longer strings, e.g. 100 or 200?

MattDonovan82 commented 2 years ago

@michael-fehlmann no problem. This is just the length originally used in the SQL databases for data reporting purposes, no issues at all to increase them.

MattDonovan82 commented 1 year ago

this will be extended to 100 characters.

MattDonovan82 commented 1 year ago

Closed as included in OED v3.0.0