Versions Compared

Old Version 9

changes.mady.by.user Jordan Li

Saved on

compared with

New Version 10

changes.mady.by.user Jordan Li

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Approach 1: using result location variables

Dataset wrap
titlecv.xpt
NameTU


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
hi1styleyellow
hi27
hi16
hi2styleaqua
tableidTU1


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 REGIONYY


CT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
2

TUDY01

TU409122
Limb with Lesion Location IdentificationLOWER LIMB REGIONLOCATEDIDENTIFIEDLOCATEDIDENTIFIEDLEGLEFT
CT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
3

TUDY01

TU409123
Vessel with Lesion Location IdentificationLOWER LIMB REGIONLOCATEDIDENTIFIEDLOCATEDIDENTIFIEDFEMORO-POPLITEAL PERIPHERAL ARTERYLEFT
CT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07
4

TUDY01

TU409124Lesion 1Lesion Location IdentificationLOWER LIMB REGIONLOCATEDIDENTIFIEDLOCATEDIDENTIFIEDPOPLITEAL ARTERYLEFTBELOW KNEECT PERIPHERAL ANGIOGRAPHYINVESTIGATOR2VISIT 12007-02-07



...

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

...

Dataset wrap
NameCV


Dataset2


Row

STUDYID

DOMAIN

USUBJID

RSSEQCVLNKID

CVTEST

CVCAT

CVORRES

VISITNUM

VISIT

RSDTC

1

TUDY01

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




Alternative approach by representing Approach 2: representing lesion locations as result values:

Dataset wrap
titlecv.xpt
NameTU



Dataset2
hi1styleyellow
hi24,5
hi12,3
hi36,7,8
hi2styleaqua
hi3stylepink
tableidTU1


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




Pros:
  1. Locationlesion location, location laterality and location details are represented as separate rows and tests.
  2. Not limited to a single result (i.e. located).
  3. TUTESTs - allowing different results
Cons:
  1. The need to create lesion type-specific tests (aneurysm, 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 and correctly for each test, step wise.

...