Specimen quantity

TBanokina · January 13, 2022, 10:36am

Hi everyone,

There is Themis rule on defaulting quantity in Device_exposure and Procedure_occurrence tables to the value of 1 in the case of unknown or 0 values.

Can this rule be applied to Specimen table? Should we replace unknown values with 1 or to keep it null?

Thank you in advance for your reply!

Philip_Solovyev · January 13, 2022, 1:18pm

Hi @TBanokina
I’m pretty sure it should be NULL since quantity here is an amount of collected sample, and it is float and has a unit. So the idea of quantity here is different from what we have in procedure and device - quantity there is integer and unit is absent.