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 CL, PM, MA, MI, and 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