documentation:next_cdm:multi_level_linkage
This is an old revision of the document!
CDM Multi-Level Associations
- Proposer: Clair Blacketer
Proposal
Add a table that allows for two or more levels of association or linkage between CONCEPT_IDs. This would mostly benefit data sources that are not claims or EHR based. The specific use case I am thinking of is related to the NHANES dataset; a U.S. based survey that combines both health and nutrition information. I cannot currently store the nutrition information effectively because all the CDM tables have one level of association. Adding in a table with two or more levels would allow me to use the nutritional information effectively. For example:
Patient_id -> Date of Meal -> Food item consumed -> Calories in Food item
Patient_id -> Date of Meal -> Food item consumed -> Grams of Fat in Food
This file was taken straight from the NHANES website and shows how the dietary data are constructed.
documentation/next_cdm/multi_level_linkage.1452174666.txt.gz · Last modified: by clairblacketer