CDM4 and CDM5 defines length of VALUE_AS_STRING field in OBSERVATION as 60. However, we observed that vendor data contains values more than this length. Please provide guidance on how to handle this case.
Note: Increasing length to 500 accommodate values. Is OHDSI going to change length in the future versions of CDM for this field?
Hi Mitesh: For all varchar fields, we provide guidance as to what you need
to specify as your minimum size. But, if for your particular source, you
need to make it larger, go ahead, it should not interfere with any analysis
process. Only thing as a generic caution is that some RDBMSs have
different definitions of varchar(max), so it can be safest to specify some
number.