ORD_FINDINGS
Description:
This table contains a list of all of the cardiovascular findings associated with the result for this order.

Primary Key
Column Name Ordinal Position
ORDER_PROC_ID 1
ORD_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 ORDER_PROC_ID NUMERIC No
The unique identifier for the order record.
2 ORD_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 CV_FINDINGS_TYPE_C_NAME VARCHAR No
The findings type category ID of the study finding.
May contain organization-specific values: Yes
Category Entries:
Mole
Lump
Pain
Tenderness
Redness
Mass
Calcifications
Architectural Distortion
Special Cases
Nipple Discharge
Skin Changes
Implants
Scar
Tattoo
Asymmetric Density
Clip
Post-Surgical Finding
Wall Score
Myocardial Finding
Nuclear Perfusion
Congenital Heart Disease
Vasculature Record
Vessel Finding
Vessel Annotation
Intervention
Complication
Lesion Complication
Right Atrium
Tricuspid Valve
Right Heart Pressures
Left Ventricle
Left Atrium
Mitral Valve
Aortic Valve
Left Heart Pressures
Aorta
Right Ventricle
Pericardium
Pulmonic Valve
Ergonovine
Endomyocardial Biopsy
Percutaneous Procedure
Peripheral Angiography
Temporary Pacemaker
Fluoroscopy of Chest
Pulmonary Angiography
ECG
Stress Findings
Response to Stress
Nuclear Measurements
Nuclear Ejection Fraction
Nuclear Study Quality
Study Impression
Perfusion Defect
Perfusion Defect 2
Perfusion Defect 3
Perfusion Defect 4
Perfusion Defect 5
Lymph Node
Solitary Dilated Duct
Focus
Non-mass Enhancement
Skin Lesion
Asymmetry
Inverted Nipple
Fat Containing
Non-enhancing
Associated Features
Cyst
Thrombectomy
Impella Insertion
ABI
Abdominal Aorta
Abdominal Aorta Graft
Axillary Femoral Graft
Left Groin
Right Groin
Left Lower Arterial
Right Lower Arterial
Upper Arterial
Renal
Lower Venous
Upper Venous
Left Carotid
Right Carotid
Prior Study
Cardiac Protocol
Study Details
Repeatable Finding
Drawing Template
Endoscopy Finding
Right Ablation Vein Mapping
Left Ablation Vein Mapping
Right Venous Insufficiency Duplex
Left Venous Insufficiency Duplex
Right Hemodialysis Access
Left Hemodialysis Access
Inferior Vena Cava
Right Upper Vein Mapping
Left Upper Vein Mapping
Right Lower Vein Mapping
Left Lower Vein Mapping
Right Lower Bypass Graft
Left Lower Bypass Graft
Superior Mesenteric Artery
Transcutaneous Oximetry
Right Transcranial Doppler
Right Upper Extremity Arterial Doppler
Left Upper Extremity Arterial Doppler
Right Renal Transplant
Left Renal Transplant
Right Penile
Left Penile
Pulse Volume Recordings
Left Transcranial Doppler
Aortic Root
Ascending Aorta
Aortic Arch
Descending Aorta
Additional Aorta Findings
Perfusion Comments
Perfusion Defect Conclusion
Absolute Flow
Stress Function Comments
Stress Function Defect
Rest Function Comments
Rest Function Defect
Stress Combined Conclusion
Metabolic Viability Defect
Metabolic Viability Conclusion
Metabolic Other Findings
Sarcoid Defect
CT Findings
Stress Hemodynamics
Stress Symptoms
Stress Post Impression
Echo Post Stress
Isotope Administration
Viability Isotope Administration
Perfusion Isotope Administration
Sarcoid Study Prep
Metabolic Study Prep
Nuclear Prior Study
Sarcoid Isotope Administration
Segmental Anatomy
Bubble Study
Right Lower Venous
Left Lower Venous
Right Upper Venous
Left Upper Venous
Right Renal
Left Renal
Kidneys
Right ABI
Left ABI
ABI Exercise
Left Upper Arterial
Right Upper Arterial
Abdominal Aorta Additional Findings
Gynecomastia
Duct Ectasia
Upper Pulse Volume Recording
Lower Pulse Volume Recording
Resting ECG
Stress ECG
Reason for Procedure
Procedure Details
PYP History
PYP Technical Details
PYP Findings
PYP Conclusion
Pulmonary Function Test
Hemodynamic Data
Hemodynamic Information
Breast Implant
Assist Devices
Parent Wall Score
Vessel Segment Finding
2D Measurement
M-Mode Measurement
Doppler Measurement
Tissue Doppler Imaging Measurement
Stress Echo Measurements
Endoscopy Procedure Details
Abscess
Palpable Mass
Generic Finding
Tympanogram
Audiogram
Speech Audiometry
Acoustic Reflex
Calcium Scoring
Noncardiac
LCSR Aortic Aneurysm Found
LCSR Coronary Arterial Calcification Found
LCSR Pulmonary Fibrosis Found
LCSR Mass Found
LCSR Other Interstitial Lung Disease Found
LCSR Other Clinically Significant Abnormalities Found
LCSR Emphysema Found
LCSR No Clinically Significant Abnormalities Found
LCSR Unknown Finding
Normal Tissue
Technical Details
Technical Quality
6 CV_FINDING_ID NUMERIC No
The unique ID of the study findings associated with this contact.
7 ORD_END_DATE_REAL FLOAT No
This is a numeric representation of the end date for each order in your system. The integer portion of the number specifies the date the order was placed. The digits after the decimal point indicate multiple orders on one day.