Thanks @Christian_Reich, this is helpful.
I have a related question about how to represent ideas extracted from notes for which there is no single pre-coordinated concept?
For example, ‘symptom x is side effect of drug y’ AND ‘symptom x is attenuated by drug y’.
(As reported by the patient - not indications and known side effects or adverse events - but rather observations about what a patient experiences)
What is OHDSI guidance for how to best represent this in both the NOTE_NLP table and clinical tables?
The drug and symptom are straightforward - a single record in NOTE_NLP for the drug and symptom and a single record in the clinical tables (drug_exposure and condition_occurrence).
How do define not just that there is a relationship between the two clinical observations, but the nature of the relationship - specifically, that the relationship is ‘has side effect of’ and the converse is side effect of?
Here’s my best guess, but I know @MPhilofsky would say this is an “off label” use of the FACT_RELATIONSHIP table. I am also struggling to understand best practices around use of the modifier_list field. I suspect it’s not “legal” to create syntactic expressions to represent the nature of the relationship between two concepts in the field:
I see in this thread that @rtmill (Mar 2023) proposes extending the range of allowable values for the relationship_id field in FACT_RELATIONSHIP. What he’s proposing is the only method of the many we tried to represent the relationships ‘has side effect’ / ‘is side effect of’ (and ‘attenuates’ / ‘is attenuated by’) between a substance and a sign-symptom-disorder.
Again, any advise greatly appreciated!
Piper