    WHEN metadata_no_multi.item_response_type IN ('multi-select','checkbox')
     THEN mv.item_oid
    ELSE 'unhandled'
-  END::varchar(40) as item_oid
+  END as item_oid
 , metadata_no_multi.item_units
 , metadata_no_multi.item_data_type
 , metadata_no_multi.item_response_type

   WHEN cd_no_labels_multi.item_value <> ''
    THEN cd_no_labels_multi.item_oid || '_' || cd_no_labels_multi.item_value
   ELSE 'unhandled'
  END::varchar(40) as item_oid
, cd_no_labels_multi.item_units
, cd_no_labels_multi.item_data_type
, cd_no_labels_multi.item_response_type

   WHEN metadata_no_multi.item_response_type IN ('multi-select','checkbox')
    THEN mv.item_name
   ELSE 'unhandled'
  END as item_name
, metadata_no_multi.item_description 
FROM dm.metadata_no_multi
LEFT JOIN (
