Using HADES for in-house curation of registry data

[MPhilofsky (Melanie Philofsky)]

Let me highlight this:

@Javier

non-standard visit code in the source_visit_concept_id, and the standard visit type in visit_concept_id.

This way any standard cohort definition, for example from phenotype library, will gather patients from all the registries.

We MUST keep standard concept_ids in the standard concept_id field of every table in order to achieve reproducible RWE.

Also, in order for the above to work, you have to put those custom (> 2billion) concepts and their relationships to standard concept_ids in the Concept and Concept Relationship tables. The source_to_concept_map table is not used by Atlas. See my poster here which explains the pros/cons of the two methods for mapping non-OHDSI supported codes to standard concepts.