Health-Informatics-UoN / Carrot-Mapper

Carrot: Convenient And Reusable Rapid Omop Transformer.
https://carrot4omop.ac.uk
MIT License
12 stars 3 forks source link

Ability to delete mapped Table Person ID and Date Event data attributes #633

Open DrUrwin opened 5 months ago

DrUrwin commented 5 months ago

When assigning Person ID and Event Dates to individual dataset tables, then can be altered, but not deleted, so that they are blank.

Currently I am mapping a dataset with no date events (just a test mapping run through), but have assigned a data attribute to an Event Date in error. I can change the assigned data attribute, but cannot return the Event Date to its original blank state.

https://ccom.azurewebsites.net/scanreports/505/

N.B.: the Dataset is restricted and Viewers / Editors / Admins are set only to Phil & Esmond

Screenshot 2024-02-01 at 17 43 55

erummas commented 5 months ago

I think this was to ensure they are never blank/missing, kind of contradictory as initially they were blank.

However, as discussed in the meeting, these two are mandatory fields, the logic would change in future and you would be required to populate these two column values for every table before starting any kind of mapping. Thus the Mapper will not allow mapping in case ID and/or Event Date is missing in the table.

For now I would suggest to use any dummy column as an event date :)