Excerpt |
---|
This example demonstrates the use of the domain to record clinical signs follow-up examinations performed at necropsy. |
Dataset wrap |
---|
|
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 |
---|
Row | STUDYID | DOMAIN | USUBJID | MASEQ | MATESTCD | MATEST | MAORRES | MASTRESC | MASPEC | MAANTREG | MADTC | MADY |
---|
1 | 999123 | MA | 999123-101 | 16 | CLSFUP | Clinical Signs Follow-up | MASS NOT FOUND AT NECROPSY | MASS NOT FOUND AT NECROPSY |
|
| 2000-01-31T14:33:21 | 365 | 2 | 999123 | MA | 999123-101 | 17 | CLSFUP | Clinical Signs Follow-up | NOT PRESENT | NOT PRESENT |
|
| 2000-01-31T14:33:21 | 365 | 3 | 999123 | MA | 999123-101 | 18 | CLSFUP | Clinical Signs Follow-up | PRESENT | PRESENT |
|
| 2000-01-31T14:33:21 | 365 | |
|
This RELREC demonstrates a linking between a specific clinical observation (CLSEQ) and its corresponding clinical sign follow-up at necropsy (MASEQ).
Dataset wrap |
---|
|
Dataset2 |
---|
Row | STUDYID | RDOMAIN | USUBJID | POOLID | IDVAR | IDVARVAL | RELTYPE | RELID |
---|
1 | 999123 | CL | 123456 |
| CLSEQ | 47 |
| 62 | 2 | 999123 | CL | 123456 |
| CLSEQ | 49 |
| 63 | 3 | 999123 | CL | 123456 |
| CLSEQ | 51 |
| 64 | 4 | 999123 | MA | 123456 |
| MASEQ | 16 |
| 62 | 5 | 999123 | MA | 123456 |
| MASEQ | 17 |
| 63 | 6 | 999123 | MA | 123456 |
| MASEQ | 18 |
| 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 |
---|
|
Dataset2 |
---|
Row | STUDYID | RDOMAIN | USUBJID | POOLID | IDVAR | IDVARVAL | RELTYPE | RELID |
---|
1 | PY001002 | CL | AA-12540 |
| CLGRPID | 5 |
| 80 | 2 | PY001002 | CL | AA-12540 |
| CLSPID | MASS 2 |
| 80 | 3 | PY001002 | PM | AA-12540 |
| PMSPID | MASS 2 |
| 80 | 4 | PY001002 | MA | AA-12540 |
| MASPID | MASS 2 |
| 80 | 5 | PY001002 | MI | AA-12540 |
| MISPID | MASS 2 |
| 80 | 6 | PY001002 | TF | AA-12540 |
| TFSPID | MASS 2 |
| 80 |
|
|