I am working on the lab test values mapping (MEASUREMENT table).
My local mapping table (handmade) has my measurement name (in French) and the associated LOINC code.
I load my local concepts into the CONCEPT table, then use an SQL query to associate the equivalent LOINC concept_id (from concept_code mapping).
I realise that the link is not made on the LOINC concept_code.
Indeed, when I filter the CONCEPT table on a LOINC concept_code (ex 34714-6) I find no result.
When I filter on the corresponding concept_id (3032080) I find the result with the desired concept_code.
The same process works on drugs (concept_code from ATC).
Can you tell me where this error comes from?
Thank you for your help.