This function assists with transforming OMOP concept_ids to interpretable strings by retrieving the requested concepts from the appropriate OMOP concept table.
get_concept(
table_map,
db_connection,
concept_table,
concept_id,
concept_name,
table,
joinable_id,
table_concept_id,
col_name,
subject_id_field = NULL,
selected_subject = NULL
)The desired OMOP concept based on the user data model for all subjects
A dplyr::tibble containing a mapping between the CDM standard tables and fields to the user connected tables and fields.
A DBI::dbConnect object.
A string, containing the standard CDM concept table name.
A string, containing the standard CDM concept id field.
A string, containing the standard CDM concept name field.
A string, containing the table name that requires OMOP concepts.
A string, indicating what variable is "joinable" between the concept table and the desired table.
A string, containing the the table concept id
A string, containing the desired name for the retrieved concept.
A string, identifying which table field contains the subject id.
A numeric, or coercible to numeric containing the desired subject id.