Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add columns default_domain and domain to stem table. #398

Open
don-torok opened this issue Jan 4, 2024 · 0 comments
Open

Add columns default_domain and domain to stem table. #398

don-torok opened this issue Jan 4, 2024 · 0 comments
Labels
enhancement Rabbit-In-A-Hat Issue concerning the specification of mapping rules

Comments

@don-torok
Copy link

We ETL into the Stem table, and then create views representing the OMOP tables, Condition, Drug Exposure, ... We use COALESCE(domain, default_domain) to determine which table a Stem table row belongs to. Where the domain is determined by the domain_id of the concept id, and the default domain is where the ETL determines the Stem table row should go if concept id is zero.

@janblom janblom added enhancement Rabbit-In-A-Hat Issue concerning the specification of mapping rules labels Jan 4, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement Rabbit-In-A-Hat Issue concerning the specification of mapping rules
Projects
None yet
Development

No branches or pull requests

2 participants