FINDING_LOCATION

Description:

The major vessels and segments of a finding.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique identifier for the finding record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	FINDING_VESSEL_ID	NUMERIC	No
	Stores the major vessels of the finding.
4	FINDING_VESSEL_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
5	FINDING_SEGMENT_ID	NUMERIC	No
	Stores the vessel segments of the finding.
6	FINDING_SEGMENT_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
7	VESSEL_GRAFT_ID	VARCHAR	No
	Stores the specific graft, branch, and sequence if the major vessel is on a graft.
8	VESSEL_BRANCH_ID	INTEGER	No
	Stores the lesion branch that the major vessel belongs to.