Skip to contents

List containing default joining keys for CDISC datasets

Source: R/data.R
default_cdisc_join_keys.Rd

These represent primary and foreign keys for joining CDISC datasets.

Usage 

default_cdisc_join_keys

Format

An object of class join_keys (inherits from list) of length 19.

Source

internal. See data-raw/cdisc_datasets.yaml and data-raw/data.R for details.

See also

join_keys()

Examples 

default_cdisc_join_keys
#> A join_keys object containing foreign keys between 19 datasets:
#> ADSL: [STUDYID, USUBJID]
#>   <-- ADAE: [STUDYID, USUBJID]
#>   <-- ADEG: [STUDYID, USUBJID]
#>   <-- ADTTE: [STUDYID, USUBJID]
#>   <-- ADAETTE: [STUDYID, USUBJID]
#>   <-- ADCM: [STUDYID, USUBJID]
#>   <-- ADEX: [STUDYID, USUBJID]
#>   <-- ADLB: [STUDYID, USUBJID]
#>   <-- ADMH: [STUDYID, USUBJID]
#>   <-- ADQS: [STUDYID, USUBJID]
#>   <-- ADRS: [STUDYID, USUBJID]
#>   <-- ADSAFTTE: [STUDYID, USUBJID]
#>   <-- ADVS: [STUDYID, USUBJID]
#>   <-- ADDV: [STUDYID, USUBJID]
#>   <-- ADSUB: [STUDYID, USUBJID]
#>   <-- ADHY: [STUDYID, USUBJID]
#>   <-- ADQLQC: [STUDYID, USUBJID]
#>   <-- ADCSSRS: [STUDYID, USUBJID]
#>   <-- ADEQ5D5L: [STUDYID, USUBJID]
#> ADAE: [STUDYID, USUBJID, ASTDTM, AETERM, AESEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADEG: [STUDYID, USUBJID, PARAMCD, AVISIT]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADTTE: [STUDYID, USUBJID, PARAMCD]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADAETTE: [STUDYID, USUBJID, PARAMCD]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADCM: [STUDYID, USUBJID, ASTDTM, CMSEQ, ATC1CD, ATC2CD, ATC3CD, ATC4CD]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADEX: [STUDYID, USUBJID, PARCAT1, PARAMCD, AVISITN, ASTDTM, EXSEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADLB: [STUDYID, USUBJID, PARAMCD, AVISIT]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADMH: [STUDYID, USUBJID, ASTDTM, MHSEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADQS: [STUDYID, USUBJID, PARAMCD, AVISIT]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADRS: [STUDYID, USUBJID, PARAMCD, AVISIT]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADSAFTTE: [STUDYID, USUBJID, PARAMCD]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADVS: [STUDYID, USUBJID, PARAMCD, AVISIT]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADDV: [STUDYID, USUBJID, ASTDT, DVTERM, DVSEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADSUB, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADSUB: [STUDYID, USUBJID, PARAMCD, AVISITN, ADTM, SRCSEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADHY, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADHY: [STUDYID, USUBJID, PARAMCD, AVISITN, ADTM, SRCSEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADQLQC, ADCSSRS, ADEQ5D5L
#> ADQLQC: [STUDYID, USUBJID, PARCAT1N, PARAMCD, BASETYPE, AVISITN, ATPTN, ADTM, QSSEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADCSSRS, ADEQ5D5L
#> ADCSSRS: [STUDYID, USUBJID, PARAMCD, BASETYPE, AVISITN, DTYPE, ADTM]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADEQ5D5L
#> ADEQ5D5L: [STUDYID, USUBJID, PARCAT1N, PARAMCD, BASETYPE, AVISITN, ATPTN, ADTM, QSSEQ]
#>   --> ADSL: [STUDYID, USUBJID]
#>   --* (implicit via parent with): ADAE, ADEG, ADTTE, ADAETTE, ADCM, ADEX, ADLB, ADMH, ADQS, ADRS, ADSAFTTE, ADVS, ADDV, ADSUB, ADHY, ADQLQC, ADCSSRS 
default_cdisc_join_keys[c("ADSL", "ADAE")] # Subset for ADSL and ADAE
#> A join_keys object containing foreign keys between 2 datasets:
#> ADSL: [STUDYID, USUBJID]
#>   <-- ADAE: [STUDYID, USUBJID]
#> ADAE: [STUDYID, USUBJID, ASTDTM, AETERM, AESEQ]
#>   --> ADSL: [STUDYID, USUBJID]