Hi, I am new to OHDSI. The patient table has gender_source_value as ‘M’ or ‘F’. For person table, how to find corresponding concept_id and source_concept_id? Can I keep them as ‘0’ or empty?
Usually, you find them in the CONCEPT table. And the CONCEPT_RELATIONSHIP table has records with relationship_id=‘Maps to’ which tell you what to map it to.
With Gender, since there are only two, nobody bothers with that detail. Go to Athena and type in “Male” and “Female”, and pick Domain = ‘Gender’ and Standard Concept = ‘Standard’. Takes 10 seconds.