Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Relationships represented in RELREC are collected relationships. The RELREC dataset should be used to represent either:

  • Explicit explicit relationships, (e.g., concomitant medications taken as a result of an adverse event) ; or
  • Information information of a nature that necessitates using multiple datasets and that may need to be examined together for analysis or proper interpretation.  

...

Metadataspec
NumCombinationDescription
1ONE, ONE

Indicates there is not hierarchical a hierarchical relationship between the datasets and the records in the datasets. Only 1 record from each dataset will potentially have the same value of the IDVAR within USUBJID.

2ONE, MANY

Indicates there is a hierarchical (parent-child) relationship between the datasets. One record within USUBJID in the dataset identified by RELTYPE = "ONE" will potentially have the same value of the IDVAR with many (1 or more) records in the dataset identified by RELTYPE = "MANY".

3MANY, MANYThis combination is unusual and challenging to manage in a merge/join, and may represent a relationship that was never intended to convey a usable merge/join,.

Pagenav