search

cdisc-org / COSMoS

CDISC Conceptual and Operational Standards Metadata Services (COSMoS)
MIT License
16 stars 1 forks source link

Create a differences report between wiki BC relationships and CDISC Library #39

Open OGarcia11 opened 1 month ago

OGarcia11 commented 1 month ago

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

lexjansen commented 1 month ago

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:

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