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
Row
STUDYID
DOMAIN
USUBJID
CESEQ
CESPID
CETERM
CELOC
CELOCDTL
1
ABC
CE
ABC-123
1
1
ANEURYSM
AORTA
Aortic Arch to Descending Aorta
2
ABC
CE
ABC-123
1
2
ANEURYSM
AORTA
Ascending Aorta to Aortic Arch
3
ABC
CE
ABC-456
1
1
ANEURYSM
RENAL ARTERY
4
ABC
CE
ABC-456
2
2
ANEURYSM
THORACIC ARTERY
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
CELOCDTL
Location Detail
text
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
Row
STUDYID
DOMAIN
USUBJID
FASEQ
FALNKID
FATESTCD
FATEST
FAOBJ
FAORRES
FAORRESU
FALOC
FAMETHOD
FALOCDTL
1
ABC
FA
ABC-123
1
1
LENDIAM
Length/Diameter
ANEURYSM
7.5
cm
AORTA
CT SCAN
Aortic Arch to Descending Aorta
2
ABC
FA
ABC-123
2
2
LENDIAM
Length/Diameter
ANEURYSM
2.5
cm
AORTA
CT SCAN
Ascending Aorta to Aortic Arch
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
FALOCDTL
Location Detail
text
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
Row
STUDYID
DOMAIN
USUBJID
CESEQ
CESPID
CETERM
CELOC
CELOCDTL
CELOCDT1
CELOCDT2
1
ABC
CE
ABC-123
1
1
ANEURYSM
AORTA
MULTIPLE
Aortic Arch to Descending Aorta
Ascending Aorta to Aortic Arch
2
ABC
CE
ABC-456
1
1
ANEURYSM
RENAL ARTERY
3
ABC
CE
ABC-456
2
2
ANEURYSM
THORACIC ARTERY
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
CELOCDTL
Location Detail
text
CELOCDT1
Location Detail 1
text
CELOCDT2
Location Detail 2
text
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
Row
STUDYID
DOMAIN
USUBJID
FASEQ
FALNKID
FASPID
FATESTCD
FATEST
FAOBJ
FAORRES
FAORRESU
FALOC
FAMETHOD
FALOCDTL
1
ABC
FA
ABC-123
1
1
OCCNUM
Number of Occurrences
ANEURYSM
2
AORTA
CT SCAN
2
ABC
FA
ABC-123
2
1
1
LENDIAM
Length/Diameter
ANEURYSM
7.5
cm
AORTA
CT SCAN
Aortic Arch to Descending Aorta
3
ABC
FA
ABC-123
3
1
2
LENDIAM
Length/Diameter
ANEURYSM
2.5
cm
AORTA
CT SCAN
Ascending Aorta to Aortic Arch
4
ABC
FA
ABC-456
1
1
OCCNUM
Number of Occurrences
ANEURYSM
1
RENAL ARTERY
MRI
5
ABC
FA
ABC-456
2
2
OCCNUM
Number of Occurrences
ANEURYSM
1
THORACIC ARTERY
MRI
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
FALOCDTL
Location Detail
text
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
Row
STUDYID
DOMAIN
USUBJID
CESEQ
CETERM
CEOCCUR
CELOC
CELOC1
CELOC2
1
ABC
CE
ABC-123
1
ANEURYSM
Y
AORTA
2
ABC
CE
ABC-456
1
ANEURYSM
Y
MULTIPLE
RENAL ARTERY
THORACIC ARTERY
3
ABC
CE
ABC-789
1
ANEURYSM
N
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
CELOC1
Location 1
text
(LOC)
CELOC2
Location 2
text
(LOC)
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
Row
STUDYID
DOMAIN
USUBJID
FASEQ
FALNKID
FASPID
FATESTCD
FATEST
FAOBJ
FAORRES
FAORRESU
FALOC
FAMETHOD
FALOCDTL
1
ABC
FA
ABC-123
1
1
OCCNUM
Number of Occurrences
ANEURYSM
2
CHEST
CT SCAN
2
ABC
FA
ABC-123
2
1
1
LENDIAM
Length/Diameter
ANEURYSM
7.5
cm
AORTA
CT SCAN
Aortic Arch to Descending Aorta
3
ABC
FA
ABC-123
3
1
2
LENDIAM
Length/Diameter
ANEURYSM
2.5
cm
AORTA
CT SCAN
Ascending Aorta to Aortic Arch
4
ABC
FA
ABC-456
1
1
OCCNUM
Number of Occurrences
ANEURYSM
2
BODY
MRI
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
FALOCDTL
Location Detail
text
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
Row
STUDYID
DOMAIN
USUBJID
CESEQ
CETERM
1
ABC
CE
ABC-123
1
ARTERIAL DISEASE
2
ABC
CE
ABC-456
1
ARTERIAL DISEASE
3
ABC
CE
ABC-789
1
ARTERIAL 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
Row
STUDYID
DOMAIN
USUBJID
FASEQ
FALNKID
FASPID
FATESTCD
FATEST
FAOBJ
FAORRES
FAORRESU
FALOC
FAMETHOD
FALOCDTL
FARESLOC
FARESLO1
FARESLO2
1
ABC
FA
ABC-123
1
1
ANEURIND
Aneurysm Indicator
ARTERIAL DISEASE
Y
CHEST
CT SCAN
AORTA
2
ABC
FA
ABC-123
2
1
ANEURNUM
Number of Aneurysms
ARTERIAL DISEASE
2
CHEST
CT SCAN
AORTA
3
ABC
FA
ABC-123
3
1
1
ANLENDIA
Aneurysm Length/Diameter
ARTERIAL DISEASE
7.5
cm
AORTA
CT SCAN
Aortic Arch to Descending Aorta
4
ABC
FA
ABC-123
4
1
2
ANLENDIA
Aneurysm Length/Diameter
ARTERIAL DISEASE
2.5
cm
AORTA
CT SCAN
Ascending Aorta to Aortic Arch
5
ABC
FA
ABC-456
1
1
ANEURIND
Aneurysm Indicator
ARTERIAL DISEASE
Y
BODY
MRI
MULTIPLE
RENAL ARTERY
THORACIC ARTERY
6
ABC
FA
ABC-456
2
1
ANEURNUM
Number of Aneurysms
ARTERIAL DISEASE
2
BODY
MRI
MULTIPLE
RENAL ARTERY
THORACIC ARTERY
7
ABC
FA
ABC-789
1
1
ANEURIND
Aneurysm Indicator
ARTERIAL DISEASE
N
BODY
MRI
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
FALOCDTL
Location Detail
text
FARESLOC
Result Location
text
(LOC)
FARESLO1
Result Location 1
text
(LOC)
FARESLO2
Result Location 2
text
(LOC)
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
CVSPID
CVTESTCD
CVTEST
CVORRES
CVORRESU
CVSTRESC
CVSTRESN
CVSTRESU
CVLOC
CVMETHOD
VISITNUM
VISIT
CVDTC
CVLOCDTL
CVRESLOC
CVRESLO1
CVRESLO2
1
ABC
CV
ABC-123
1
1
ANEURIND
Aneurysm Indicator
Y
CHEST
CT SCAN
1
BASELINE
2020-04-27
AORTA
2
ABC
CV
ABC-123
2
1
ANEURNUM
Number of Aneurysms
2
CHEST
CT SCAN
1
BASELINE
2020-04-27
AORTA
3
ABC
CV
ABC-123
3
1
1
ANLENDIA
Aneurysm Length/Diameter
7.5
cm
7.5
7.5
cm
AORTA
CT SCAN
1
BASELINE
2020-04-27
Aortic Arch to Descending Aorta
4
ABC
CV
ABC-123
4
1
2
ANLENDIA
Aneurysm Length/Diameter
2.5
cm
2.5
2.5
cm
AORTA
CT SCAN
1
BASELINE
2020-04-27
Ascending Aorta to Aortic Arch
5
ABC
CV
ABC-456
1
2
ANEURIND
Aneurysm Indicator
Y
BODY
MRI
1
BASELINE
2020-04-27
MULTIPLE
RENAL ARTERY
THORACIC AORTA
6
ABC
CV
ABC-456
2
2
ANEURNUM
Number of Aneurysms
2
BODY
MRI
1
BASELINE
2020-04-27
MULTIPLE
RENAL ARTERY
THORACIC AORTA
7
ABC
CV
ABC-789
1
1
ANEURIND
Aneurysm Indicator
N
BODY
MRI
1
BASELINE
2020-04-27
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
CVLOCDTL
Location Detail
text
CVRESLOC
Result Location
text
(LOC)
CVRESLO1
Result Location 1
text
(LOC)
CVRESLO2
Result Location 2
text
(LOC)
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
CVSPID
CVTESTCD
CVTEST
CVORRES
CVORRESU
CVSTRESC
CVSTRESN
CVSTRESU
CVLOC
CVMETHOD
VISITNUM
VISIT
CVDTC
CVLOCDTL
1
ABC
CV
ABC-123
1
1
ANEURIND
Aneurysm Indicator
Y
CHEST
CT SCAN
1
BASELINE
2020-04-27
2
ABC
CV
ABC-123
2
1
ANEURNUM
Number of Aneurysms
2
CHEST
CT SCAN
1
BASELINE
2020-04-27
3
ABC
CV
ABC-123
3
1
1
ANEURLOC
Aneurysm Location
Aortic Arch to Descending Aorta
AORTA
CHEST
CT SCAN
1
BASELINE
2020-04-27
4
ABC
CV
ABC-123
4
1
2
ANEURLOC
Aneurysm Location
Aortic Arch to Descending Aorta
AORTA
CHEST
CT SCAN
1
BASELINE
2020-04-27
5
ABC
CV
ABC-123
5
1
1
ANLENDIA
Aneurysm Length/Diameter
7.5
cm
7.5
7.5
cm
AORTA
CT SCAN
1
BASELINE
2020-04-27
Aortic Arch to Descending Aorta
6
ABC
CV
ABC-123
6
1
2
ANLENDIA
Aneurysm Length/Diameter
2.5
cm
2.5
2.5
cm
AORTA
CT SCAN
1
BASELINE
2020-04-27
Aortic Arch to Descending Aorta
7
ABC
CV
ABC-456
1
2
ANEURIND
Aneurysm Indicator
Y
BODY
MRI
1
BASELINE
2020-04-27
8
ABC
CV
ABC-456
2
2
ANEURNUM
Number of Aneurysms
2
BODY
MRI
1
BASELINE
2020-04-27
9
ABC
CV
ABC-123
3
1
1
ANEURLOC
Aneurysm Location
RENAL ARTERY
RENAL ARTERY
BODY
MRI
1
BASELINE
2020-04-27
10
ABC
CV
ABC-456456
4
1
2
ANEURLOC
Aneurysm Location
THORACIC AORTA
THORACIC AORTA
BODY
MRI
1
BASELINE
2020-04-27
11
ABC
CV
ABC-789
1
1
ANEURIND
Aneurysm Indicator
N
BODY
MRI
1
BASELINE
2020-04-27
$warningHtml
XX NSV Metadata
Name
Label
Data Type
Codelist
CVLOCDTL
Location Detail
text
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.