Mapping multiple source_values to the same omop concept_id could result in data truncation error in SQL Server.
e.g.:
Mapping multiple measurements to same concept results in error:
"String or binary data would be truncated in table 'FHIN.work.measurement', column 'measurement_source_value'."
The column ('measurement_source_value') in "work-zone" table is filled with "STRING_AGG(t.measurement_source_value, ', ')". Column size of 'measurement_source_value' is limited and aggregating multiple source_values exceeds this limit.
Mapping multiple source_values to the same omop concept_id could result in data truncation error in SQL Server.
e.g.:
Mapping multiple measurements to same concept results in error: "String or binary data would be truncated in table 'FHIN.work.measurement', column 'measurement_source_value'."
The column ('measurement_source_value') in "work-zone" table is filled with "STRING_AGG(t.measurement_source_value, ', ')". Column size of 'measurement_source_value' is limited and aggregating multiple source_values exceeds this limit.