Adding manufacturer and model information to the device_exposure table

If you need somewhere to save the details of the device, but don’t need it to be recognized in OHDSI tools, you can put it in the device_exposure.device_source_value. I often - particularly when developing the ETL code use this field to contain a formatted representation of the source and its value. For example in capturing Emergency Medical Service (EMS) defibrillator data the device_source_value is expanded to VARCHAR(1024) and the following is saved as a dot-format ID: ...<s/n>.<procedure/transaction GUID>

ex “Zoll Medical.M Series ™ Defibrillator.80,07.11223344.20090724120202_00030004”

Its a work around but I found it helpful when debugging ETLs and grouping measurements/observations to the GUID or looking at what manufacturers were involved, which models, etc in a large national trial of many EMS agencies and devices involved.