Closed stephanieshong closed 2 years ago
sdoh_answer_code_xwalk dataset is built to include all of the LOINC coded answer concepts submitted for the SDoH concepts and for the xwalk table to contain the proper LOINC coded answer concept_ids. String text are added to the value_set_mapping tables. Add the code in the observation to left join with the sdo_answer_code_xwalk to find the correct LOINC coded LA%-% concept_ids.
PR submitted in the TrinetX template source code.
code changes are in step 4: observation.sql and sdoh_answer_code_xwalk.sql
Support both instances in mapping SDoH answer codes to the correct value_as_concept_id. Extract LA%-% to map to OMOP concept table to find the correct concept_ids.