OHDSI Home | Forums | Wiki | Github

How to assign measurement_type_concept_id to some Measurement/LOINC concepts?

CDM Builders
#1

We have data for concept ids 3035992 (ED referring practitioner name), 3031655 (Reason for referral (narrative)), 3017852 (Microbiology studies (set)). They have string values and coded values (for 3031655). How should we choose the right measurement type concept ids for them? The same for 3010922 (Medication dose)? Thanks.

Ming

#2

@Christian_Reich To clarify, are these in the right domain (i.e., measurement)?

Things like ED referring practitioner name or Reason for referral (narrative) would not seem to be recordable a such.

#3

Ming:

The Type Concepts are the provenance of the data. Where did you get them from? What is the source?

Here is what you do: For a given concept, determine the domain. Then, list all the type concepts for that domain. E.g. for the Observation domain the types would be in in the Observation Type domain. There are usually not that many. Pick hte one that fits your data. If you can’t find what you need, tell us, and we add a new type.

#4

Jon:

Will be fixed in the next release: They will be:

concept_name domain_id vocabulary_id concept_class_id standard_concept concept_code
ED referring practitioner name Observation LOINC Claims attachment S 18705-4
Reason for referral (narrative) Observation LOINC Claims attachment S 42349-1

It should go into the garbage can (OBSERVATION table).

t