Page History

...

Approach 1: using result location variables

Dataset wrap

title	cv.xpt
Name	TU

Rowcaps

Row 1:	Shows one or more lesions have been identified in the lower limb region.
Row 2:	Shows the limb that contains lesion is the left leg.
Row 3:	Shows the major vessel that contains a lesion is the left femoro-popliteal peripheral artery.
Row 4:	Shows the lesion is found in the left popliteal artery, in the segment below the knee. Note a TULNKID is created for row 4 ONLY where TULNKID = Lesion 1. This --LNKID is used to connect this lesion to the lesion severity assessment in CV. TULNKID is created in this case as the lesion identifier, it also serves the function to connect the identified lesion to other assessments in different domains.

Dataset2

Row	STUDYID	DOMAIN	USUBJID	TUSEQ	TULNKID	TUTEST	TULOC	TUORRES	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				CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
2	TUDY01	TU	40912	2	Lesion 1	Lesion Location Identification	LOWER LIMB REGION	IDENTIFIED	POPLITEAL ARTERY	LEFT	ABOVE KNEE	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
3	TUDY01	TU	40912	3	Graft Lesion 1	Lesion Location Identification	LOWER LIMB REGION	IDENTIFIED	LEFT FEMORO-POPLITEAL GRAFT	LEFT	PROXIMAL ANASTOMOSIS, 5MM FROM THE ORIGIN OF THE GRAFT	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07

Pros:	Reusibility of the result location variables in other domains. Simplicity: there is only one location for TULOC for the Lesion Location Identification process. Imaging location is treated as the general location for TULOC, and all result locations are under the RESLOC variable. Clarity of data representation
Cons:	there is only one result associated with the location questions. We currently have DIR, LAT, PORTOT, Loc Detail, how many more variables might we need if there are more locations info that we need to represent. For example, the graft use-case where we need to indicate that a location is a graft, or transplant.
Vote:

...

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

title	cv.xpt
Name	TU

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 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

lesion

Lesion

lesion

6
Lesion	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	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

LOWER LIMB REGION

lesion

FEMORAL ARTERY

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

title	cv.xpt
Name	TU

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	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
	TUDY01	TU	40912	1	Lesion 1	Presence of Lesion Indicator	LOWER LIMB REGION	N	N				CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	7	VISIT 8	2007-02-07

Copy:

Dataset wrap

title	cv.xpt
Name	TU

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

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

9

8	VISIT 8	2007-10-08
5	TUDY01	TU	40912	5	Lesion 1	Examination for Abnormality	LOWER LIMB REGION

lesion unidentifiable

aneurysm Unidentifiable

lesion unidentifiable

aneurysm Unidentifiable

CT PERIPHERAL ANGIOGRAPHY

INVESTIGATOR

9

8	VISIT 8	2007-10-08
6	TUDY01	TU	40912	6	Lesion 2	Examination for Abnormality	LOWER LIMB REGION

lesion

aneurysm

lesion

aneurysm

FEMORAL ARTERY

Femoral Artery

RIGHT

Right

CT PERIPHERAL ANGIOGRAPHY

INVESTIGATOR

9

8

VISIT 8

2007-10-08

7

Space shortcuts

Page tree

Versions Compared

Old Version 31

New Version 32

Key

Approach 1: using result location variables

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.