RELREC Domain-to-Domain Example 1

This example shows how to use the RELREC dataset to represent related information that is submitted as multiple datasets that have an identifying variable in common.

In this example, all the records with the same --SPID across the domains with the same USUBJID are being related to each other. Because this relationship exists for all values of USUBJID and all values of --SPID (specified in IDVARVAL), both USUBJID and IDVARVAL are null.

$titleHtml

relrec.xpt

RowSTUDYIDRDOMAINUSUBJIDIDVARIDVARVALRELTYPERELID
1999123CL
CLSPID
MANYA
2999123MI
MISPID
MANYA
3999123MA
MASPID
MANYA
4999123PM
PMSPID
MANYA
5999123TF
TFSPID
MANYA
$warningHtml
Because IDVAR identifies the keys that can be used to merge/join records between the datasets, the root values (e.g., --SPID in this example) for IDVAR are the same for all records with the same RELID. --SEQ cannot be used because --SEQ only has meaning within a subject within a domain, not across domains.


RELREC --SPID Examples

The following --SPID examples are based on the preceding RELREC dataset. These examples show only the variables from the CL, PM, MA, MI, and Tumor Findings (TF) domains that are relevent to the RELREC discussion. In a submission, additional variables would be included.

RELREC --SPID Example 1

TOBA-298 - Getting issue details... STATUS Shows the unique mass number across the 5 domains.

cl.xpt

RowSTUDYIDDOMAINUSUBJIDCLSEQCLSPID
1999123CL999123-10256MASS A
$warningHtml

pm.xpt

RowSTUDYIDDOMAINUSUBJIDPMSEQPMSPID
1999123PM999123-10264MASS A
$warningHtml

ma.xpt

RowSTUDYIDDOMAINUSUBJIDMASEQMASPID
1999123MA999123-102128MASS A
$warningHtml

mi.xpt

RowSTUDYIDDOMAINUSUBJIDMISEQMISPID
1999123MI999123-10284MASS A
$warningHtml

tf.xpt

RowSTUDYIDDOMAINUSUBJIDTFSEQTFSPID
1999123TF999123-10255MASS A
$warningHtml

RELREC --SPID Example 2

TOBA-298 - Getting issue details... STATUS During the course of the study a mass split into 2 masses; therefore, a new identifier was given to the second mass.

cl.xpt

RowSTUDYIDDOMAINUSUBJIDCLSEQCLSPID
1999123CL999123-10256MASS A
$warningHtml

pm.xpt

RowSTUDYIDDOMAINUSUBJIDPMSEQPMSPID
1999123PM999123-10264MASS A
2999123PM999123-102228MASS B
$warningHtml

ma.xpt

RowSTUDYIDDOMAINUSUBJIDMASEQMASPID
1999123MA999123-102128MASS A
2999123MA999123-102345MASS B
$warningHtml

mi.xpt

RowSTUDYIDDOMAINUSUBJIDMISEQMISPID
1999123MI999123-10284MASS A
2999123MI999123-10284MASS B
$warningHtml

tf.xpt

RowSTUDYIDDOMAINUSUBJIDTFSEQTFSPID
1999123TF999123-10255MASS A
2999123TF999123-10276MASS B
$warningHtml

RELREC --SPID Example 3

TOBA-298 - Getting issue details... STATUS During the course of the study 2 masses (mass A and mass B) merge to make a single mass; a new identifier ("MASS C") was given to merged mass.

cl.xpt

RowSTUDYIDDOMAINUSUBJIDCLSEQCLSPIDCLDTC
1999123CL999123-10256MASS A2013-10-01
$warningHtml

pm.xpt

RowSTUDYIDDOMAINUSUBJIDPMSEQPMSPIDPMDTC
1999123PM999123-10264MASS A2013-10-08
2999123PM999123-102228MASS B2013-10-08
3999123PM999123-102228MASS C2013-10-15
$warningHtml

ma.xpt

RowSTUDYIDDOMAINUSUBJIDMASEQMASPIDMADTC
1999123MA999123-102128MASS C2013-10-22
$warningHtml

mi.xpt

RowSTUDYIDDOMAINUSUBJIDMISEQMISPIDMIDTC
1999123MI999123-10284MASS C2013-10-22
$warningHtml

tf.xpt

RowSTUDYIDDOMAINUSUBJIDTFSEQTFSPIDTFDTC
1999123TFb999123-10255MASS C2013-10-22
$warningHtml

« RELREC Examples for Record-To-Record Relationships

Supplemental Qualifier Dataset Examples »


  • No labels