...
...
Row
...
STUDYID
...
DOMAIN
...
USUBJID
...
TUTEST
...
TULOC
...
TUORRES
...
TUMETHOD
...
VISITNUM
...
VISIT
...
TUDTC
...
TUDY01
...
TUDY01
...
TUDY01
...
Approach 3: taking a similar approach as SEND in MI domain modeling where MI test = microscopic examination, the identified abnormality is the result and the location of the said abnormality is mapped to RESLOC.
I think Diane had proposed this approach before but it didn't go anywhere?
Dataset wrap |
---|
|
Dataset2 |
---|
hi1style | yellow |
---|
hi2 | 7 |
---|
hi1 | 6 |
---|
hi2style | aqua |
---|
tableid | TU1 |
---|
|
Row | STUDYID | DOMAIN | USUBJID | TUSEQ | TULNKID | TUTEST | TULOC | TUORRES | TUSTRESC | TU Result LOC | TU Result LAT | TU Result LOCDTL | TUMETHOD | TUEVEL | VISITNUM | VISIT | TUDTC |
---|
1 | TUDY01 | TU | 40912 |
---|
1Lesion 1 |
| Lesion Indicator | LOWER LIMB REGION | Y | Y |
|
|
| CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 | 2 | TUDY01 | TU | 40912 | 2 | Lesion 1 | Examination for Abnormality | LOWER LIMB REGION |
---|
LesionLesionlesion | POPLITEAL ARTERY | LEFT | BELOW THE KNEE | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 | 3 | TUDY01 | TU | 40912 | 3 | Lesion 2 |
---|
Lesion Indicator | LOWER LIMB REGION | Y | Y | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 | 4 | TUDY01 | TU | 40912 | 4 | Lesion 2 | Examination for Abnormality | LOWER LIMB REGION | Lesion | Dataset2 |
---|
hi1style | yellow |
---|
hi2 | 7 |
---|
hi1 | 6 |
---|
hi2style | aqua |
---|
tableid | TU1 |
---|
| Row | STUDYID | DOMAIN | USUBJID | TUSEQ | TULNKID | TUTEST | TULOC | TUORRES | TUSTRESC | TU Result LOC | TU Result LAT | TU Result LOCDTL | TUMETHOD | TUEVEL | VISITNUM | VISIT | TUDTC |
---|
TUDY01 | TU | 40912 | 1 | Lesion Indicator | LOWER LIMB REGION | Y | Y | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 | 1 | TUDY01 | TU | 40912 | 1 | Lesion 1 | Presence of Lesion Indicator | LOWER LIMB REGION | Y | Y | POPLITEAL ARTERY | LEFT | BELOW THE KNEE | Lesion | Femoral Artery | Right | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 | 5 | TUDY01 | TU | 40912 | 1 | Lesion 1 | Lesion Indicator | LOWER LIMB REGION | N | N | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 8 | VISIT 8 | 2007-10-08 | 6 | TUDY01 | TU | 40912 | 2 | Lesion 2 | Lesion Indicator | LOWER LIMB REGION | Y | Y | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 8 | VISIT 8 | 2007-10-08 | 7 | TUDY01 | TU | 40912 | 3 | Lesion 2 | Examination for Abnormality | LOWER LIMB REGION | Lesion | Lesion | Femoral Artery | Right | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 8 | VISIT 8 | 2007-10-08 | |
|
Dataset wrap |
---|
|
lesion | FEMORAL ARTERY | RIGHT |
|
CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 |
TUDY01 | TU | 40912 | 1 | Lesion 1 | Presence of Lesion IndicatorLOWER LIMB REGION | N | N | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 7 | VISIT 8 | 2007-02-07 | |
|
Copy:
Dataset wrap |
---|
|
Dataset2 |
---|
hi1style | yellow |
---|
hi2 | 7 |
---|
hi1 | 6 |
---|
hi2style | aqua |
---|
tableid | TU1 |
---|
| Row | STUDYID | DOMAIN | USUBJID | TUSEQ | TULNKID | TUTEST | TULOC | TUORRES | TUSTRESC | TU Result LOC | TU Result LAT | TU Result LOCDTL | TUMETHOD | TUEVEL | VISITNUM | VISIT | TUDTC |
---|
1 | TUDY01 | TU | 40912 | 1 | Lesion Indicator | LOWER LIMB REGION | Y | Y | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 | 2 | TUDY01 | TU | 40912 | 2 | Lesion 1 | Examination for Abnormality | LOWER LIMB REGION | aneurysm | aneurysm | POPLITEAL ARTERY | LEFT | BELOW THE KNEE | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 |
---|
3 | TUDY01 | TU | 40912 | 3 | Lesion 2 | Examination for Abnormality | LOWER LIMB REGION | aneurysm | aneurysm | Femoral Artery | Right | CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 2 | VISIT 1 | 2007-02-07 | 4 | TUDY01 | TU | 40912 | 4 |
| Lesion Indicator | LOWER LIMB REGION | Y | Y |
|
|
| CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR |
---|
89 | VISIT 8 | 2007-10-08 | 5 | TUDY01 | TU | 40912 | 5 | Lesion 1 | Examination for Abnormality | LOWER LIMB REGION |
---|
aneurysm Unidentifiableaneurysm Unidentifiablelesion unidentifiable |
|
|
| CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 89 | VISIT 8 | 2007-10-08 | 6 | TUDY01 | TU | 40912 | 6 | Lesion 2 | Examination for Abnormality | LOWER LIMB REGION |
---|
aneurysmaneurysmFemoral ArteryRightRIGHT |
| CT PERIPHERAL ANGIOGRAPHY | INVESTIGATOR | 8
|
|