You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

This example shows how to model complex locations using a combination of location-related TESTs and location variables.

This is probably as complicated for modeling anatomy as it goes, location identification for most abnormality may not require this level of detail, i.e. the aneurysm example.

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.

tu.xpt

tu.xpt

Row

STUDYID

DOMAIN

USUBJID

TUSEQTULNKID

TUTEST

TULOC

TULATTULOCDTL

TUORRES

TUSTRESCTU Result LOCTU Result LATTU Result LOCDTL

TUMETHOD

TUEVEL

VISITNUM

VISIT

TUDTC

1

TUDY01

TU409121
Lesion IndicatorLOWER LIMB REGION

YY


CT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
2

TUDY01

TU409122
Limb with Lesion Location IdentificationLOWER LIMB REGION

LOCATEDLOCATEDLEGLEFT
CT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
3

TUDY01

TU409123
Vessel with Lesion Location IdentificationLOWER LIMB REGION

LOCATEDLOCATEDFEMORO-POPLITEAL PERIPHERAL ARTERYLEFT
CT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
4

TUDY01

TU409124Lesion 1Lesion Location IdentificationLOWER LIMB REGION

LOCATEDLOCATEDPOPLITEAL ARTERYLEFTBELOW KNEECT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
$warningHtml

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Pros:
  1. Reusibility of the result location variables in other domains.
  2. 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.
  3. A combination of location-related tests and location variables help to better support anatomical data mapping.
  4. Clarity of data representation
Cons:
  1. there is only one result associated with the location questions.

cv.xpt

cv.xpt

Row

STUDYID

DOMAIN

USUBJID

RSSEQCVLNKID

CVTEST

CVCAT

CVORRES

VISITNUM

VISIT

RSDTC

1

TUDY01

CV409121Lesion 1Lesion SeveritySponsor-defined CriteriaSevere2VISIT 12007-02-07
$warningHtml

Alternative approach by representing locations as result values:

tu.xpt

tu.xpt

Row

STUDYID

DOMAIN

USUBJID

TUSEQTUGRPID

TUTEST

TULOC

TUORRES

TUMETHOD

TUEVEL

VISITNUM

VISIT

TUDTC

1

TUDY01

TU409121
Lesion IndicatorLower limb regionYCT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
2

TUDY01

TU4091221Limb with Lesion Location IdentificationLower limb regionLegCT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
3

TUDY01

TU4091231Limb with Lesion location Laterality IdentificationLegLeftCT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
4

TUDY01

TU4091242Vessel with Lesion Location IdentificationLower limb region

Femerol-popliteal peripheral artery

CT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
5

TUDY01

TU4091252Vessel with Lesion Location Laterality IdentificationFemerol-popliteal peripheral arteryleftCT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
6

TUDY01

TU4091263Lesion Location IdentificationLower limb regionpopliteal arteryCT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
7

TUDY01

TU4091273Lesion Location Laterality Identificationpopliteal arteryleftCT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
8

TUDY01

TU4091283Lesion Location Detail Identificationleft popliteal arteryabove the kneeCT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
$warningHtml

Pros:
  1. Location, laterality and location details are represented as separate rows and tests.
  2. Not limited to a single result (i.e. located).
Cons:
  1. The need to create lesion type-specific tests (aneurysm, lesion, calcified annuls, etc), causing an expansion of TUTESTs.
  2. Reusibility in other domains is limited, seeing as lesion identification should all be mapped to TU.
  3. 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.
  • No labels