Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
This example demonstrates the use of the domain to record clinical signs follow-up examinations performed at necropsy.
Dataset wrap
NameMA
Rowcaps
Rows 1-2:Represents examples of a follow-up of a clinical observation that could not be confirmed at necropsy.
Row 3:Represents an example of a follow-up of a clinical observation that was confirmed at necropsy.
Dataset2
RowSTUDYIDDOMAINUSUBJIDMASEQMATESTCDMATESTMAORRESMASTRESCMASPECMAANTREGMADTCMADY
1999123MA999123-10116CLSFUPClinical Signs Follow-upMASS NOT FOUND AT NECROPSYMASS NOT FOUND AT NECROPSY

2000-01-31T14:33:21365
2999123MA999123-10117CLSFUPClinical Signs Follow-upNOT PRESENTNOT PRESENT

2000-01-31T14:33:21365
3999123MA999123-10118CLSFUPClinical Signs Follow-upPRESENTPRESENT

2000-01-31T14:33:21365

This RELREC demonstrates a linking between a specific clinical observation (CLSEQ) and its corresponding clinical sign follow-up at necropsy (MASEQ).

Dataset wrap
Namerelrec
Dataset2
RowSTUDYIDRDOMAINUSUBJIDPOOLIDIDVARIDVARVALRELTYPERELID
1999123CL123456
CLSEQ47
62
2999123CL123456
CLSEQ49
63
3999123CL123456
CLSEQ51
64
4999123MA123456
MASEQ16
62
5999123MA123456
MASEQ17
63
6999123MA123456
MASEQ18
64

This example demonstrates a linking between findings across the Clinical Observations (CL), Palpable Masses (PM), MA, Microscopic Findings (MI), and Tumor Findings (TF) domains using RELREC. The mass was first identified as an abrasion over several weeks (grouped by CLGRPID = 5), graduating to a mass with several associated clinical findings (identified by a CLSPID of "MASS 2"). These clinical findings correspond to a set of findings in the PM domain, a clinical signs follow-up and gross pathological examination in the MA domain, a single microscopic finding from the MI domain, and a single tumor finding in the TF domain. Each of the findings in the PM, MA, MI, and TF are related by way of the --SPID field, with a value of "MASS 2".

Because all of these records are related, they are given the same RELID (in this case a value of 80).

Dataset wrap
Namerelrec
Dataset2
RowSTUDYIDRDOMAINUSUBJIDPOOLIDIDVARIDVARVALRELTYPERELID
1PY001002CLAA-12540
CLGRPID5
80
2PY001002CLAA-12540
CLSPIDMASS 2
80
3PY001002PMAA-12540
PMSPIDMASS 2
80
4PY001002MAAA-12540
MASPIDMASS 2
80
5PY001002MIAA-12540
MISPIDMASS 2
80
6PY001002TFAA-12540
TFSPIDMASS 2
80