Create a differences report between wiki BC relationships and CDISC Library

[OGarcia11]

https://wiki.cdisc.org/display/BIOMEDDEV/Variable+Relationships

[lexjansen]

linking_phrases_predicate_terms_2024-10-09.xlsx

Attached is a report in Excel that shows relationship metadata between the Wiki and COSMoS SDTM dataset specializations.
It contains the following tabs.

• Relationships Wiki – metadata from the tables on the pages listed at https://wiki.cdisc.org/display/BIOMEDDEV/Variable+Relationships
(excluded: Variable Relationships Needing Development)
• Relationships COSMoS – metadata from the relationships from the latest Excel download for the COSMoS SDTM Dataset Specializations
• Linking Phrases – Linking Phrases used across Wiki and COSMoS, where you can see in column B and C, whether they are used in Wiki and/or COSMoS
• Predicate Terms – Predicate Terms used across Wiki and COSMoS, where you can see in column B and C, whether they are used in Wiki and/or COSMoS
• Link. Phrases - Pred. Terms – Combinations of Linking Phrase / Predicate Term used across Wiki and COSMoS, where you can see in column D/E and F/G, whether they are used in Wiki and/or COSMoS.
Column “count” shows the number of distinct Predicate Terms used for the Linking Phrase.
There are 2 Linking Phrases that use multiple Predicate Terms:

• “is the medical condition that is the reason for the treatment in” uses INDICATES and IS_REASON_FOR
• “is the role of the assessor who performed the test in” uses PERMORED and PERFORMS

I also compared how similar some Linking Phrases are by using distances between the phrases.
I found the following pairs. I don’t know if they should be the same.
There may be more, which can be seen on the Linking Phrases tab.

• specifies the anatomical location of
specifies the anatomical location in

• was the subject position during performance of the test in
is the subject position during performance of the test in

• is the name for the value in
is a name for the value in

• is the dictionary-derived term for the value in
is a dictionary-derived term for the value in

• is a dictionary-derived code for the value in
is the dictionary-derived class code for the value in

• is the numeric value for
is a numeric value for

• is the date of occurrence for
is the date of occurrence

• is the role of the assessor who provided the result in
is the role of the assessor who performed the test in

• is the code for
is the code for the value in