User Tools

Site Tools


This is an old revision of the document!

CDM Multi-Level Associations

  • Proposer: Clair Blacketer


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
       Patient_id -> Date of Meal -> Food item consumed -> Grams of Fat in Food
documentation/next_cdm/multi_level_linkage.1449500937.txt.gz · Last modified: 2015/12/07 15:08 by clairblacketer