OHDSI Home | Forums | Wiki | Github

Relationship options for fact_relationship table

(Melanie Philofsky) #1


I am hoping you can help me find an appropriate concept_id for the fact_relationship table to link two tobacco use concepts together. Filtering on concept_class_id = Relationship or filtering on vocabulary_id = Relationship gives me the same 402 concepts. Only 10 of those concepts are standard concepts. None are appropriate for linking together two social history facts. What standard relationship_concept_id should I use? I also have use cases to link sexual activity and contraception type; alcohol intake and start/stop/quit dates; illicit drug use concepts.


New fact_relationship relationship_id
(Dmytry Dymshyts) #2

It’s a good question,
looks kinda similar

And the final idea was to propose to extend the Note table with addtional related events fields.

@MPhilofsky, according to your use case, do you think, instead of using fact_relationship table, it would be better to have related_event_id, related_domain_id fields in Observation table where you can put your additional concepts?

@Christian_Reich, is it possible to extend Measurement, Observation, Condition, Procedure tables with related_event_id, related_domain_id fields?

(Melanie Philofsky) #3

@Dymshyts I like the idea, however, I will have many related_event_ids. Person uses tobacco, person is light cigarette smoker, person started smoking 19500101, person has 100 year pack history, etc. How would we relate them all together?

This is also similar to the cultures conversation. Another use case we are about to embark upon.

(Christian Reich) #4

@Dymshyts, @MPhilofsky:

This is for THEMS and the CDM WG. Create a list of options, and let’s discuss the pros and cons. You mentioned two:

  1. A predefined list of relationship concept for FACT_RELATIONSHIP (I am not a fan, as you know)
  2. Adding fields for those linkages.

What else?

(Melanie Philofsky) #5


I know! I am the one that volunteered to take on social history modeling. I am researching the options.

@Dymshyts - Do you know of any SNOMEDCT codes (or any standardized codes/code system) that would work for connecting social history “facts” I mention above?

@OHDSI community - How have others added social history concepts to OMOP? Or how would you add it?


(Christian Reich) #6

Hahahaha. It called “sending on a circular goose chase”.