Copied from Richard Marshall's space.

Aneurysms

Interventions performed

  • CT Scan
    • Anatomical focus of Intervention
      • Chest
  • MRI Scan
    • Anatomical focus of Intervention
      • Body

Events with anatomical manifestations

  • Aneurysm
    • Anatomical manifestations
      • Subject ABC-123, Aneurysm 1:
        • Categorized location: Aorta
        • Detailed location: Aortic Arch to Descending Aorta
        • Length/diameter: 7.5cm
      • Subject ABC-123, Aneurysm 2:
        • Categorized location: Aorta
        • Detailed location: Ascending Aorta to Aortic Arch
        • Length/diameter: 2.5cm
      • Subject ABC-456, Aneurysm 1:
        • Categorized location: Renal artery
      • Subject ABC-456, Aneurysm 2:
        • Categorized location: Thoracic artery

Observations made

  • Anatomical manifestation indicator
    • Anatomical object of observation (scope) - coincides with anatomical focus of Interventions
      • Chest
      • Body
    • Result
      • Aggregate occurrence indicator (boolean)
  • Where did the aneurysm event manifest? 
    • Anatomical object of observation (scope) - coincides with anatomical focus of Interventions
      • Chest
      • Body
    • Result
      • Anatomical manifestations of aneurysm event → see above
  • Number of aneurysms
    • Anatomical object of observation (scope) - coincides with anatomical focus of Interventions
      • Chest
      • Body
    • Result
      • Aggregate (count)
  • Aneurysm Length/Diameter
    • Anatomical object of observation
      • Anatomical manifestation of aneurysm event → see above
    • Result
      • Amount/unit

Representing each aneurysm as a separate event

Row 1:There was an anatomical manifestation of the aneurysm event in the aortic arch to descending aorta part of the aorta.
Row 2:There was an anatomical manifestation of the aneurysm event in the ascending aorta to aortic arch part of the aorta.
Row 3:There was an anatomical manifestation of the aneurysm event in the renal artery.
Row 4:There was an anatomical manifestation of the aneurysm event in the thoracic artery.


ce.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDCESEQCESPIDCETERMCELOC
CELOCDTL
1ABCCEABC-12311ANEURYSMAORTA
Aortic Arch to Descending Aorta
2ABCCEABC-12312ANEURYSMAORTA
Ascending Aorta to Aortic Arch
3ABCCEABC-45611ANEURYSMRENAL ARTERY

4ABCCEABC-45622ANEURYSMTHORACIC ARTERY

$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

The locations are represented on the FA records because they indicate the anatomical object of the observations.

Row 1:I looked at the aneurysm in the aortic arch to descending aorta part of the aorta using a CT scan and found its length to be 7.5 cm.
Row 2:I looked at the aneurysm in the ascending aorta to aortic arch part of the aorta using a CT scan and found its length to be 2.5 cm.

fa.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDFASEQFALNKIDFATESTCDFATESTFAOBJFAORRESFAORRESUFALOCFAMETHOD
FALOCDTL
1ABCFAABC-12311LENDIAMLength/DiameterANEURYSM7.5cmAORTACT SCAN
Aortic Arch to Descending Aorta
2ABCFAABC-12322LENDIAMLength/DiameterANEURYSM2.5cmAORTACT SCAN
Ascending Aorta to Aortic Arch
$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Summarizing observed aneurysms by region

Aneurysms are reported as events per region when they were found.

Row 1:There was at least one anatomical manifestation of the aneurysm event in the aortic arch to descending aorta and ascending aorta to aortic arch parts of the aorta.
Row 2:There was at least one anatomical manifestation of the aneurysm event in the renal artery.
Row 3:There was at least one anatomical manifestation of the aneurysm event in the thoracic artery.


ce.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDCESEQCESPIDCETERMCELOC
CELOCDTLCELOCDT1CELOCDT2
1ABCCEABC-12311ANEURYSMAORTA
MULTIPLEAortic Arch to Descending AortaAscending Aorta to Aortic Arch
2ABCCEABC-45611ANEURYSMRENAL ARTERY



3ABCCEABC-45622ANEURYSMTHORACIC ARTERY



$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

The location shown in CELOC are also represented on the FA records because they indicate the anatomical object of the observations.

The result location details shown in CELOCDTL could alternatively be represented:

  • In FARLODTL on the number of aneurysm records - as long as FARLODTL is a record qualifier and not a variable qualifier of FARESLOC.  
  • As separate records in FA (e.g., with a test of "LOCDTL"/"Location Details"), with FALOC indicating the scope of the observation (which would be the individual values from CELOC). These records would be in the same form as the length/diam records: e.g., "I looked at the first aneurysm in the aorta using a CT scan and found its detailed location was the aortic arch to descending aorta."

However, the location result details should only be represented in one place - either CE or FA.

Location/location details on the length/diameter records indicates which specific aneurysm is being measured. 

Row 1:I looked at the aorta using a CT scan and found 2 aneurysms in the aortic arch to descending aorta and ascending aorta to aortic arch.
Row 2:I looked at the aneurysm in the aortic arch to descending aorta part of the aorta using a CT scan and found its length to be 7.5 cm.
Row 3:I looked at the aneurysm in the ascending aorta to aortic arch part of the aorta using a CT scan and found its length to be 2.5 cm.
Row 4:I looked at the renal artery using an MRI and found 1 aneurysm.
Row 5:I looked at the thoracic artery using an MRI scan and found 1 aneurysm.

fa.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDFASEQFALNKIDFASPIDFATESTCDFATESTFAOBJFAORRESFAORRESUFALOCFAMETHOD
FALOCDTL
1ABCFAABC-12311
OCCNUMNumber of OccurrencesANEURYSM2
AORTACT SCAN

2ABCFAABC-123211LENDIAMLength/DiameterANEURYSM7.5cmAORTACT SCAN
Aortic Arch to Descending Aorta
3ABCFAABC-123312LENDIAMLength/DiameterANEURYSM2.5cmAORTACT SCAN
Ascending Aorta to Aortic Arch
4ABCFAABC-45611
OCCNUMNumber of OccurrencesANEURYSM1
RENAL ARTERYMRI

5ABCFAABC-45622
OCCNUMNumber of OccurrencesANEURYSM1
THORACIC ARTERYMRI

$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Summarizing aneurysms as an event

Row 1:The aneurysm event did occur and there was at least one manifestation in the aorta.
Row 2:The aneurysm event did occur and there was at least one manifestation in the renal artery and thoracic artery.
Row 3:The aneurysm event did not occur.


ce.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDCESEQCETERMCEOCCURCELOC
CELOC1CELOC2
1ABCCEABC-1231ANEURYSMYAORTA


2ABCCEABC-4561ANEURYSMYMULTIPLE
RENAL ARTERYTHORACIC ARTERY
3ABCCEABC-7891ANEURYSMN



$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

The locations are represented on the FA records because they indicate the anatomical object of the observations.

Location on the length/diameter records indicates which specific aneurysm is being measured. 

FARESLOC/FARESLO1/FARESLO2 are not used because information about the location of the manifestations of the aneurysm events is already represented in CE. Also representing them in FA would just be duplicating the information. The location(s) of any anatomical manifestation(s) of an event should be recorded on the event record when such a record is available. The location(s) of any anatomical manifestation(s) of an event should only be recorded as result location(s) if an event record is unavailable.

Result location details are currently missing from this representation. They could be represented in CELOCDTL on the CE records as long as CELOCDTL is a record qualifier and not a variable qualifier of CELOC - there would be no correlation between CELOC values and CELOCDTL values. Alternatively, the location details could be represented as separate records in FA (e.g., with a test of "LOCDTL"/"Location Details"), with FALOC indicating the scope of the observation (which could either be the higher-level value of chest/body or the individual values from CELOC(n).

Row 1:I looked at the chest using a CT scan and found 2 aneurysms.
Row 2:I looked at the aneurysm in the aortic arch to descending aorta part of the aorta using a CT scan and found its length to be 7.5 cm.
Row 3:I looked at the aneurysm in the ascending aorta to aortic arch part of the aorta using a CT scan and found its length to be 2.5 cm.
Row 4:I looked at the body using an MRI and found 2 aneurysms.

fa.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDFASEQFALNKIDFASPIDFATESTCDFATESTFAOBJFAORRESFAORRESUFALOCFAMETHOD
FALOCDTL
1ABCFAABC-12311
OCCNUMNumber of OccurrencesANEURYSM2
CHESTCT SCAN

2ABCFAABC-123211LENDIAMLength/DiameterANEURYSM7.5cmAORTACT SCAN
Aortic Arch to Descending Aorta
3ABCFAABC-123312LENDIAMLength/DiameterANEURYSM2.5cmAORTACT SCAN
Ascending Aorta to Aortic Arch
4ABCFAABC-45611
OCCNUMNumber of OccurrencesANEURYSM2
BODYMRI

$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Summarizing aneurysms as symptoms of an event

No location information is shown for the arterial disease event

ce.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDCESEQCETERM
1ABCCEABC-1231ARTERIAL DISEASE
2ABCCEABC-4561ARTERIAL DISEASE
3ABCCEABC-7891ARTERIAL DISEASE
$warningHtml

On the records for aneurysm indicator and number of aneurysms, FALOC indicates the scope of the observation and the location of the manifestations of the aneurysm event are shown in FARESLOC.

Location does need to be specified on the length/diameter records to indicate which specific aneurysm is being measured. 

Result location details are currently missing from this representation. They could be represented in FARLODTL on the indicator/"number of" FA records as long as FARLODTL is a record qualifier and not a variable qualifier of CERESLOC - there would be no correlation between FARESLOC values and FARLODTL values. Alternatively, the location details could be represented as separate records in FA (e.g., with a test of "LOCDTL"/"Location Details"), with FALOC indicating the scope of the observation (which could either be the higher-level value of chest/body or the individual values from FALOC(n).

Row 1:I looked at the chest using a CT scan and found that there was at least one aneurysm in the aorta.
Row 2:I looked at the chest using a CT scan and found 2 aneurysms in the aorta.
Row 3:I looked at the aneurysm in the aortic arch to descending aorta part of the aorta using a CT scan and found its length to be 7.5 cm.
Row 4:I looked at the aneurysm in the ascending aorta to aortic arch part of the aorta using a CT scan and found its length to be 2.5 cm.
Row 5:I looked at the body using an MRI and found that there was at least one aneurysm in the renal artery and thoracic artery.
Row 6:I looked at the body using an MRI and found 2 aneurysms in the renal artery and thoracic artery.
Row 7:I looked at the body using an MRI and found no aneurysms.

fa.xpt

xx.xpt

RowSTUDYIDDOMAINUSUBJIDFASEQFALNKIDFASPIDFATESTCD

FATEST

FAOBJFAORRESFAORRESUFALOCFAMETHOD
FALOCDTLFARESLOCFARESLO1FARESLO2
1ABCFAABC-12311
ANEURINDAneurysm IndicatorARTERIAL DISEASEY
CHESTCT SCAN

AORTA

2ABCFAABC-12321
ANEURNUMNumber of AneurysmsARTERIAL DISEASE2
CHESTCT SCAN

AORTA

3ABCFAABC-123311ANLENDIAAneurysm Length/DiameterARTERIAL DISEASE7.5cmAORTACT SCAN
Aortic Arch to Descending Aorta


4ABCFAABC-123412ANLENDIAAneurysm Length/DiameterARTERIAL DISEASE2.5cmAORTACT SCAN
Ascending Aorta to Aortic Arch


5ABCFAABC-45611
ANEURINDAneurysm IndicatorARTERIAL DISEASEY
BODYMRI

MULTIPLERENAL ARTERYTHORACIC ARTERY
6ABCFAABC-45621
ANEURNUMNumber of AneurysmsARTERIAL DISEASE2
BODYMRI

MULTIPLERENAL ARTERYTHORACIC ARTERY
7ABCFAABC-78911
ANEURINDAneurysm IndicatorARTERIAL DISEASEN
BODYMRI




$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Representing aneurysm findings in CV

Same as FA immediately above, but without --OBJ.

Result location details are currently missing from this representation. They could be represented in CVRLODTL on the indicator/"number of" CV records as long as CVRLODTL is a record qualifier and not a variable qualifier of CVRESLOC - there would be no correlation between CVRESLOC values and CVRLODTL values. Alternatively, the location details could be represented as separate records in CV (e.g., with a test of "LOCDTL"/"Location Details"), with CVLOC indicating the scope of the observation (which could either be the higher-level value of chest/body or the individual values from CVLOC(n).

Row 1:I looked at the chest using a CT scan and found that there was at least one aneurysm in the aorta.
Row 2:I looked at the chest using a CT scan and found 2 aneurysms in the aorta.
Row 3:I looked at the aneurysm in the aortic arch to descending aorta part of the aorta using a CT scan and found its length to be 7.5 cm.
Row 4:I looked at the aneurysm in the ascending aorta to aortic arch part of the aorta using a CT scan and found its length to be 2.5 cm.
Row 5:I looked at the body using an MRI and found that there was at least one aneurysm in the renal artery and thoracic artery.
Row 6:I looked at the body using an MRI and found 2 aneurysms in the renal artery and thoracic artery.
Row 7:I looked at the body using an MRI and found no aneurysms.


cv.xpt

xx.xpt

Row

STUDYID

DOMAIN

USUBJID

CVSEQ

CVGRPID

CVSPIDCVTESTCD

CVTEST

CVORRES

CVORRESUCVSTRESCCVSTRESNCVSTRESU

CVLOC

CVMETHOD

VISITNUM

VISIT

CVDTC


CVLOCDTL

CVRESLOCCVRESLO1CVRESLO2
1ABCCVABC-12311
ANEURINDAneurysm IndicatorY



CHESTCT SCAN1BASELINE2020-04-27

AORTA

2ABCCVABC-12321
ANEURNUMNumber of Aneurysms2



CHESTCT SCAN1BASELINE2020-04-27

AORTA

3ABCCVABC-123311ANLENDIAAneurysm Length/Diameter7.5cm7.57.5cmAORTACT SCAN1BASELINE2020-04-27
Aortic Arch to Descending Aorta


4ABCCVABC-123412ANLENDIAAneurysm Length/Diameter2.5cm2.52.5cmAORTACT SCAN1BASELINE2020-04-27
Ascending Aorta to Aortic Arch


5ABCCVABC-45612
ANEURINDAneurysm IndicatorY



BODYMRI1BASELINE2020-04-27

MULTIPLERENAL ARTERYTHORACIC AORTA
6ABCCVABC-45622
ANEURNUMNumber of Aneurysms2



BODYMRI1BASELINE2020-04-27

MULTIPLERENAL ARTERYTHORACIC AORTA
7ABCCVABC-78911
ANEURINDAneurysm IndicatorN



BODYMRI1BASELINE2020-04-27




$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

Representing anatomical manifestations of events as separate result records

ORRES/STRESC can be used to handle the categorization/standardization of location. No new result location variables are needed.

CVLOC for the indicator/number/location records is the scope of the observation, which coincides with the focus of the diagnostic procedure that was used to perform the observation.

Note that the location for the length/diameter record is the location of the specific anatomical manifestation of the aneurysm event that is the object of the observation. CVMETHOD still indicates the name of the procedure used to perform the observation.

Row 1:I looked at the chest using a CT scan and found that there was at least one aneurysm.
Row 2:I looked at the chest using a CT scan and found 2 aneurysms.
Row 3:I looked at the chest using a CT scan and found an aneurysm in the aortic arch to descending aorta, which is represented in a standard way as "aorta".
Row 4:I looked at the chest using a CT scan and found an aneurysm in the ascending aorta to aortic arch, which is represented in a standard way as "aorta".
Row 5:I looked at the aneurysm in the aortic arch to descending aorta part of the aorta using a CT scan and found its length to be 7.5 cm.
Row 6:I looked at the aneurysm in the ascending aorta to aortic arch part of the aorta using a CT scan and found its length to be 2.5 cm.
Row 7:I looked at the body using an MRI and found that there was at least one aneurysm.
Row 8:I looked at the body using an MRI and found 2 aneurysms.
Row 9:I looked at the body using an MRI and found that there was an aneurysm in the renal artery.
Row 10:I looked at the body using an MRI and found that there was an aneurysm in the thoracic artery.
Row 11:I looked at the body using an MRI and found no aneurysms.


cv.xpt

xx.xpt

Row

STUDYID

DOMAIN

USUBJID

CVSEQ

CVGRPID

CVSPIDCVTESTCD

CVTEST

CVORRES

CVORRESUCVSTRESCCVSTRESNCVSTRESU

CVLOC

CVMETHOD

VISITNUM

VISIT

CVDTC


CVLOCDTL

1ABCCVABC-12311
ANEURINDAneurysm IndicatorY



CHESTCT SCAN1BASELINE2020-04-27

2ABCCVABC-12321
ANEURNUMNumber of Aneurysms2



CHESTCT SCAN1BASELINE2020-04-27

3ABCCVABC-123311ANEURLOCAneurysm LocationAortic Arch to Descending Aorta
AORTA

CHESTCT SCAN1BASELINE2020-04-27

4ABCCVABC-123412ANEURLOCAneurysm LocationAortic Arch to Descending Aorta
AORTA

CHESTCT SCAN1BASELINE2020-04-27

5ABCCVABC-123511ANLENDIAAneurysm Length/Diameter7.5cm7.57.5cmAORTACT SCAN1BASELINE2020-04-27
Aortic Arch to Descending Aorta
6ABCCVABC-123612ANLENDIAAneurysm Length/Diameter2.5cm2.52.5cmAORTACT SCAN1BASELINE2020-04-27
Aortic Arch to Descending Aorta
7ABCCVABC-45612
ANEURINDAneurysm IndicatorY



BODYMRI1BASELINE2020-04-27

8ABCCVABC-45622
ANEURNUMNumber of Aneurysms2



BODYMRI1BASELINE2020-04-27

9ABCCVABC-123311ANEURLOCAneurysm LocationRENAL ARTERY
RENAL ARTERY

BODYMRI1BASELINE2020-04-27

10ABCCVABC-456456412ANEURLOCAneurysm LocationTHORACIC AORTA
THORACIC AORTA

BODYMRI1BASELINE2020-04-27

11ABCCVABC-78911
ANEURINDAneurysm IndicatorN



BODYMRI1BASELINE2020-04-27

$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.



Ventricular Diameter

Interventions performed

  • TTE
    • Anatomical focus of Intervention
      • (unspecified)

Events with anatomical manifestations

  • None

Observations made

  • Minor axis cross-sectional diameter
    • Anatomical object of observation
      • Heart, left ventricle (at high papillary muscle level)
      • Heart, right ventricle (below the tricuspid valve)
    • Result
      • Amount/unit


Row 1:I looked at the left ventricle of the heart at the high papillary muscle level and found that the minor axis cross-sectional diameter was 3.7cm.
Row 2:I looked at the right ventricle of the heart below the tricuspid valve and found that the minor axis cross-sectional diameter was 3.7cm.
$titleHtml

cv.xpt

Row

STUDYID

DOMAIN

USUBJID

CVSEQ

CVTESTCD

CVTEST

CVORRES

CVORRESU

CVLOC

CVMETHOD

VISITNUM

VISIT

CVDTC


CVLOCDTL

1 ABCCVABC-123 1MNDIAEVDMinor Axis Cross-sec Diameter, EVD 3.7 cmHEART, LEFT VENTRICLETTE1BASELINE

At high papillary muscle level
 2 ABCCVABC-123 2MNDIAEVDMinor Axis Cross-sec Diameter, EVD 3.2 cmHEART, RIGHT VENTRICLETTE1BASELINE

Below the tricuspid valve
$warningHtml

XX NSV Metadata

Dataset Wrapper Debug Message

Please add a row column to your dataset.

  • No labels