Page History

...

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 where TULNKID = Lesion 1. This --LNKID is used to connect to the lesion severity assessment in CV.

Dataset2

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		Limb with Lesion Location Identification	LOWER LIMB REGION	LOCATED	LOCATED	LEG	LEFT		CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
3	TUDY01	TU	40912	3		Vessel with Lesion Location Identification	LOWER LIMB REGION	LOCATED	LOCATED	FEMORO-POPLITEAL PERIPHERAL ARTERY	LEFT		CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
4	TUDY01	TU	40912	4	Lesion 1	Lesion Location Identification	LOWER LIMB REGION	LOCATED	LOCATED	POPLITEAL ARTERY	LEFT	BELOW KNEE	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07

Pros:	Reusibility of the result location variables in other domains. Only one location for TULOC for the Location Identification process - Imaging location is treated as the general location for TULOC. All result locations are under the RESLOC variable. A combination of location-related tests and location variables help to better support anatomical data mapping. Clarity of data representation
Cons:	there is only one result associated with the location questions.

Dataset wrap

Name	CV

Dataset2

Row	STUDYID	DOMAIN	USUBJID	RSSEQ	CVLNKID	CVTEST	CVCAT	CVORRES	VISITNUM	VISIT	RSDTC
1	TUDY01	CV	40912	1	Lesion 1	Lesion Severity	Sponsor-defined Criteria	Severe	2	VISIT 1	2007-02-07

...

Dataset wrap

title	cv.xpt
Name	TU

Dataset2

Row	STUDYID	DOMAIN	USUBJID	TUSEQ	TUGRPID	TUTEST	TULOC	TUORRES	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	1	Limb with Lesion Location Identification	Lower limb region	Leg	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
3	TUDY01	TU	40912	3	1	Limb with Lesion location Laterality Identification	Leg	Left	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
4	TUDY01	TU	40912	4	2	Vessel with Lesion Location Identification	Lower limb region	Femerol-popliteal peripheral artery	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
5	TUDY01	TU	40912	5	2	Vessel with Lesion Location Laterality Identification	Femerol-popliteal peripheral artery	left	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
6	TUDY01	TU	40912	6	3	Lesion Location Identification	Lower limb region	popliteal artery	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
7	TUDY01	TU	40912	7	3	Lesion Location Laterality Identification	popliteal artery	left	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07
8	TUDY01	TU	40912	8	3	Lesion Location Detail Identification	left popliteal artery	above the knee	CT PERIPHERAL ANGIOGRAPHY	INVESTIGATOR	2	VISIT 1	2007-02-07

Pros:	Location, laterality and location details are represented as separate rows and tests. Not limited to a single result (i.e. located).
Cons:	The need to create lesion type-specific tests (aneurysm, lesion, calcified annuls, etc), causing an expansion of TUTESTs. Reusibility in other domains is limited, seeing as lesion identification should all be mapped to TU. Requires good understanding of lesion anatomy and the difference between TSTLOC vs RESLOC in order to map the locations properly for each test, step wise.

Space shortcuts