ORDER_RES

Description:

The ORDER_RES table contains result finding information for an order. Result findings include mammography pathology results, cardiovascular palette findings, and other result findings.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique identifier of the finding record corresponding to the result.
2	RESULT_TYPE_C_NAME	VARCHAR	No
	The result type category ID for the order result. May contain organization-specific values: No Category Entries: Endoscopy Finding Sensitivity Comments BLOOD - Single Division Joint Exam Tympanogram Result Audiogram Result Speech Audiometry Acoustic Reflex Lab Follow-Up Lab Comm Log Lab Requisition RIS General Breast Problem RIS Mammo Mass RIS Mammo Calcification RIS Mammo Architectural Distortion RIS Mammo Asymmetric Density RIS Mammo Misc RIS Mammo Result RIS Mammo Recommendations Pathology Result Lesion RIS Result Finding Follow-up RIS General Recommendations Finding Screening Program Pathology Screening Program Recommendation RIS Unverified Result Finding Follow Up RIS Unverified General Recommendation Unverified Screening Program Recommendation Observation Observation Instance Dermatology Finding Anatomy Dental Finding Dental Procedure Soft Tissue Finding Soft Tissue Group Finding Orthodontics Appliance
3	FINDING_SIDE_C_NAME	VARCHAR	No
	The finding side category ID for the finding. May contain organization-specific values: No Category Entries: Right Left Both
4	FINDING_TYPE_C_NAME	VARCHAR	No
	The finding type category ID for the 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 Patient History Right Heart Catheterization Parent Wall Score Vessel Segment Finding CMR Left Ventricle CMR Right Ventricle CMR Atria CMR Wall Thickness CMR Valves CMR Vessels CMR Pericardium CMR Tissue Characterization CMR Tissue Measurements CMR Mass CMR Incidental Findings CMR Clinical Impression CMR Perfusion 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 Pulmonary Nodule Normal Tissue Technical Details Technical Quality
5	RECOMMENDATION_C_NAME	VARCHAR	No
	The mammography recommendation category number for the finding. May contain organization-specific values: Yes Category Entries: Short Interval Follow-up Ultrasound Biopsy
6	RECO_SIDE_C_NAME	VARCHAR	No
	The side of the body category ID for which side a mammography recommendation is for. Maps to Right, Left, or Bilateral. May contain organization-specific values: No Category Entries: Bilateral Right Left
7	CLASS_OF_LESION_C_NAME	VARCHAR	No
	The classification of lesion category ID for the pathology result. May contain organization-specific values: Yes Category Entries: Benign High Risk Malignant Premalignancy - Hyperplasia Malignant - Non-lung Clinical - without histology Non-diagnostic Other (please specify) Unknown
8	SIZE_OF_TUMOR	NUMERIC	No
	The size of the tumor (mm) for pathology results of mammogram biopsies.
9	PATH_FND_SIDE_C_NAME	VARCHAR	No
	The finding side category ID for the pathology result. The category values for this column were already listed for column: FINDING_SIDE_C_NAME
10	HISTOLOGY_GRADE_C_NAME	VARCHAR	No
	The histology grade category ID for the pathology result. May contain organization-specific values: Yes Category Entries: GX G1 G2 G3 DCIS: Low Grade DCIS: Intermediate Grade DCIS: High Grade
11	MARGIN_STATUS_C_NAME	VARCHAR	No
	The margin status category ID for the pathology result. May contain organization-specific values: Yes Category Entries: Uninvolved Involved
12	NIPPLE_INVOLVED_YN_NAME	VARCHAR	No
	Indicates if nipple is included in the pathology result. May contain organization-specific values: No Category Entries: No Yes
13	NODES_REMOVED	INTEGER	No
	The number of nodes removed.
14	NODES_POSITIVE	INTEGER	No
	The number of nodes positive in the pathology result.
15	STAGE_C_NAME	VARCHAR	No
	The cancer staging category number for the finding. May contain organization-specific values: Yes Category Entries: Stage 0 Stage 1 Stage 2A Stage 2B Stage 3A Stage 3B Stage 3C Stage 4 Stage 1A Stage 1B
16	ESTROGEN_RECP_C_NAME	VARCHAR	No
	The estrogen receptor category ID for the estrogen receptor associated with the finding. May contain organization-specific values: Yes Category Entries: Negative Positive
17	PROGESTERONE_RCP_C_NAME	VARCHAR	No
	The estrogen receptor category ID that clarifies the progesterone receptor in the pathology result. The category values for this column were already listed for column: ESTROGEN_RECP_C_NAME
18	S_PHASE	INTEGER	No
	The S phase for a specific pathology result.
19	OB_ULTRASOUND_GA	VARCHAR	No
	The gestational age interpreted for the entire ultrasound, in days, for the result corresponding to ultrasound findings.
20	NEEDS_FOLLOW_UP_C_NAME	VARCHAR	No
	The needs follow up category number for the order results. This is used as a flag for a recommendation record that needs follow up. May contain organization-specific values: Yes Category Entries: Needs Follow-up Closed Resolved
21	MAMMO_DUE_DT	DATETIME	No
	Due date for the recommendation.
22	MAMMO_FIND_CTX_C_NAME	VARCHAR	No
	The context category number for the mammography finding. This is populated using the enhanced drawing tools to document on breast diagrams within the radiology mammography module. May contain organization-specific values: Yes Category Entries: Technologist Radiologist
23	ORIGINAL_FINDING_ID	NUMERIC	No
	The unique ID of the original finding this finding record was copied from.
24	GRAFT_ID	VARCHAR	No
	The graft ID for this result.
25	DOMINANCE_C_NAME	VARCHAR	No
	The coronary dominance category ID for the finding. May contain organization-specific values: Yes Category Entries: Left Right Co-dominant
26	ANNOTATION_TYPE_C_NAME	VARCHAR	No
	The annotation type category ID for the coronary diagram annotation result finding. May contain organization-specific values: No Category Entries: Lesion Existing Stent Graft Collateral Branch
27	ANNOT_VESSEL_ID	NUMERIC	No
	The major vessel of the annotation.
28	ANNOT_VESSEL_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
29	ANNOT_SEGM_ID	NUMERIC	No
	The vessel segment ID.
30	ANNOT_SEGM_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
31	ANNOT_END_SEGM_ID	NUMERIC	No
	The ending vessel segment ID.
32	ANNOT_END_SEGM_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
33	COLLAT_END_VES_ID	NUMERIC	No
	The major vessel ID of the destination of a collateral
34	COLLAT_END_VES_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
35	COLLAT_END_SEGM_ID	NUMERIC	No
	The vessel segment of the destination of a collateral.
36	COLLAT_END_SEGM_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
37	VESSEL_LOCATION_C_NAME	VARCHAR	No
	The vessel location category ID for the result record. May contain organization-specific values: Yes Category Entries: Coronary Cerebral Arteries Left Cervical Arteries Right Cervical Arteries Right Upper Extremity Arteries Left Upper Extremity Arteries Aortic Visceral Arteries Lower Extremity Arteries - Left Suprainguinal Lower Extremity Arteries - Left Infrainguinal Lower Extremity Arteries - Left Infrapopliteal Lower Extremity Arteries - Right Suprainguinal Lower Extremity Arteries - Right Infrainguinal Lower Extremity Arteries - Right Infrapopliteal Left Neck Venous Right Neck Venous Superior Vena Cava Left Upper Extremity Venous Right Upper Extremity Venous Inferior Vena Cava Abdominal Vein Lower Extremity Veins - Left Lower Extremity Veins - Right Pulmonary Arteries Pulmonary Veins Non Coronary Arteries Non Coronary Veins
38	SEGMENT_LOC_C_NAME	VARCHAR	No
	The location of the body category ID for an annotation of a segment. Used to distinguish between two separate annotations in the same segment. Maps to proximal and distal. May contain organization-specific values: No Category Entries: PROXIMAL DISTAL
39	LESION_PRE_STEN	INTEGER	No
	The pre-stent stenosis percentage for this result.
40	LESION_POST_STEN	INTEGER	No
	The post-stent stenosis percentage for this result.
41	INTERVENTION_TYPE_C_NAME	VARCHAR	No
	The intervention type category ID of the intervention. May contain organization-specific values: Yes Category Entries: Angioplasty Stent Atherectomy Thrombolysis PCI Valvuloplasty PFO Closure ASD Closure VSD Closure Peripheral Intervention Foreign Body Removal - Percutaneous Post-Intervention Lesion Assessment Thrombectomy Lithotripsy
42	ATMOS_INFLATION	NUMERIC	No
	The measures of the balloon atmospheres inflation for the result.
43	SEC_OF_INFLATION	INTEGER	No
	The number of seconds of balloon inflation measured for the result.
44	STENT_LENGTH	VARCHAR	No
	Indicates length of the stent
45	STENT_DIAMETER	VARCHAR	No
	Indicates diameter of the stent.
46	INTERVENTIO_SEQ_NUM	INTEGER	No
	The sequence of the intervention.
47	GRAFT_PROX_ANAST_ID	NUMERIC	No
	The proximal anastomosis for a graft.
48	GRAFT_PROX_ANAST_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
49	GR_DIST_ANST_VEL_ID	NUMERIC	No
	The major vessel of the distal anastomosis for a graft.
50	GR_DIST_ANST_VEL_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
51	GR_DIST_ANST_SEG_ID	NUMERIC	No
	The vessel segment of the distal anastomosis for a graft.
52	GR_DIST_ANST_SEG_ID_RECORD_NAME	VARCHAR	No
	Stores record name (.2)
53	GRAFT_SEQ_NUM	INTEGER	No
	The graft sequence number in a multi-vessel graft.
54	CONDITION_C_NAME	VARCHAR	No
	The patient condition category ID for the result finding. May contain organization-specific values: Yes Category Entries: Resting Stress Post Stress Baseline Low Dose Mid Dose Peak Dose Metabolic Rest Attenuation Correction Stress Attenuation Correction
55	TECH_DOC_DTTM	DATETIME (UTC)	No
	The instant at which this finding was documented in the procedure log.
56	MAMMO_FIND_PULFW_YN	VARCHAR	No
	Indicates, at the finding level, whether or not a Mammo finding in Image Documentation should be pulled forward to future studies. The category values for this column were already listed for column: NIPPLE_INVOLVED_YN_NAME
57	PAT_ID	VARCHAR	No
	The unique ID of the patient record with whom the result finding as associated. This column is frequently used to link to the PATIENT table.
58	MAMFND_SRC_FIND_ID	NUMERIC	No
	The result finding unique identifier for the source result finding from which the current result finding record was copied. Typically populated for permanent findings such as scars or tattoos.
59	MAMMO_BIOPSY_TYPE_C_NAME	VARCHAR	No
	The mammography biopsy type category ID for the pathology result. May contain organization-specific values: Yes Category Entries: Excisional biopsy Core biopsy Fine needle aspiration cytology Cyst aspiration - diagnostic Incisional Biopsy Other Biopsy performed, type unknown
60	MAMFND_PFWD_VERF_YN	VARCHAR	No
	Indicates if a finding was verified in the Mammo Image Documentation section. The category values for this column were already listed for column: NIPPLE_INVOLVED_YN_NAME
61	PAT_CSN	NUMERIC	No
	The unique contact serial number (CSN) of the patient for whom the contact was moved.
62	LAST_FINDING_ID	NUMERIC	No
	The unique identifier for the most recent finding for a breast lesion. Use this column to join to another copy of ORDER_RES on the FINDING_ID column. This will only be populated for lesion records in ORDER_RES where RESULT_TYPE_C is equal to 52013 (Lesion).
63	LAST_LSN_STAT_C_NAME	VARCHAR	No
	The mammography last lesion status for the lesion. May contain organization-specific values: No Category Entries: Active Deleted Resolved
64	CONF_OF_TARGET_C_NAME	VARCHAR	No
	The confirmation of target category ID for a breast biopsy lesion that indicates whether or not the suspicious lesion was obtained. May contain organization-specific values: Yes No Entries Defined
65	IMG_DEVICE_USED_C_NAME	VARCHAR	No
	The imaging device used category ID for the finding of a breast biopsy. May contain organization-specific values: Yes No Entries Defined
66	TECHNIQUE_USED_C_NAME	VARCHAR	No
	The technique used category ID for a breast biopsy. May contain organization-specific values: Yes No Entries Defined
67	BIOPSY_REPEAT_TYP_C_NAME	VARCHAR	No
	The category number of the type of biopsy that was performed for a repeat procedure. The category values for this column were already listed for column: MAMMO_BIOPSY_TYPE_C_NAME
68	MYOCARDIAL_TYPE_C_NAME	VARCHAR	No
	The myocardial finding type category ID for the finding, allowing the distinction of RES records used for echo documentation. May contain organization-specific values: Yes Category Entries: Left Ventricle Left Atrium Right Ventricle Right Atrium Mitral Valve Aortic Valve Tricuspid Valve Pulmonic Valve IVC/SVC Ascending Aorta Pericardium Pulmonary Artery Septum Congenital Coronary Vessels Congenital Pulmonary Structures Wall Scoring Mitral Valve - Stress Aortic Valve - Stress Tricuspid Valve - Stress Pulmonic Valve - Stress Left Ventricle - Stress Left Atrium - Stress Right Ventricle - Stress Right Atrium - Stress Pericardium - Stress Response to Stress Study Impression Single Ventricle Atrial Septum Ventricular Septum Atrioventricular Valve Truncal Valve
69	PATH_RESULT_DATE	DATETIME	No
	The date on which a pathology result was returned from the lab after a breast biopsy was performed.
70	INVASIVE_SIZE_MM	NUMERIC	No
	The size (mm) of the invasive component of a breast lesion.
71	IN_SITU_SIZE_MM	NUMERIC	No
	The size (mm) of the in situ component of a breast legion.
72	NUM_OF_MARGINS	INTEGER	No
	The number of margins that were identified anatomically and measured in metric units for a breast lesion.
73	SPEC_COMP_SUBMTD_YN	VARCHAR	No
	Indicates whether the specimen was completely submitted (totally embedded) for microscopic evaluation following a surgical breast procedure. May contain organization-specific values: No Category Entries: No Yes Unknown
74	MAM_SURGERY_TYPE_C_NAME	VARCHAR	No
	The surgery type category ID for the pathology result. May contain organization-specific values: Yes Category Entries: Lumpectomy Mastectomy Re-Excision
75	LN_EXTRA_EXTNSN_C_NAME	VARCHAR	No
	The extracapsular extension status category ID for the pathology result. May contain organization-specific values: No Category Entries: Absent Present
76	HER2_IHC_C_NAME	VARCHAR	No
	The HER2/neu IHC category ID for the pathology result. May contain organization-specific values: No Category Entries: 0 1+ 2+ 3+
77	HER2_FISH_C_NAME	VARCHAR	No
	The HER2/neu FISH category ID for the pathology result. The category values for this column were already listed for column: ESTROGEN_RECP_C_NAME
78	STATUS_C_NAME	VARCHAR	No
	The lab status category ID for a follow-up recommendation. May contain organization-specific values: No Category Entries: Completed Open
79	GENERAL_RECOM_C_NAME	VARCHAR	No
	The general recommendation category ID for the follow-up recommendation of a non-mammography study. May contain organization-specific values: Yes Category Entries: Additional Imaging or Other Follow-up
80	GEN_REC_ANAT_RGN_C_NAME	VARCHAR	No
	The anatomical region category ID for the follow-up recommendation of a non-mammography study. May contain organization-specific values: Yes Category Entries: Other Abdomen Lung Pelvis Spine
81	GEN_RECOM_MOD_TYP_C_NAME	VARCHAR	No
	The modality type category ID for the follow-up recommendation of a non-mammography study. May contain organization-specific values: Yes Category Entries: Computed Tomography Magnetic Resonance Positron Emission Tomography (PET) Ultrasound Radiographic Imaging Gamma Camera Mammography Computed Radiography Digital Radiography Biomagnetic Imaging Duplex Doppler Endoscopy Magnetic Resonance Angiography Single-Photon Emission Computed Tomography (SPECT) X-Ray Angiography Intra-Oral Radiography General Microscopy External-Camera Photography Audio Cardiac Electrophysiology Nuclear Medicine Color Flow Doppler Diaphanography Laser Surface Scan Magnetic Resonance Spectroscopy Thermography Radio Fluoroscopy Presentation State Electrocardiography Hemodynamic Waveform Intravascular Ultrasound Panoramic X-Ray Radiotherapy Image Radiotherapy Structure Set RT Treatment Record SR Document Radiotherapy Dose Radiotherapy Plan Hard Copy Slide Microscopy Other
82	GEN_RECOM_DUE_IN_C_NAME	VARCHAR	No
	The general recommendation due within category ID due date that defines the recommended time frame for the follow-up recommendation of a non-mammography study. May contain organization-specific values: Yes
83	GEN_RECOM_NOTE_ID	VARCHAR	No
	The comment entered for a follow-up recommendation for a non-mammography study.
84	REC_SRC_FINDING_ID	NUMERIC	No
	The finding record ID associated with a follow-up recommendation placed on a study.
85	RSLT_TRK_ACTY_C_NAME	VARCHAR	No
	The acuity level category ID for the finding. May contain organization-specific values: Yes Category Entries: Critical Significant Unexpected
86	RSLT_TRK_FINDING_C_NAME	VARCHAR	No
	The acuity notification findings category ID for the critical result. May contain organization-specific values: Yes
87	RSLT_TRK_BGN_USR_ID	VARCHAR	No
	The user who documented a critical result.
88	RSLT_TRK_BGN_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
89	RSLT_TRK_BEGIN_DTTM	DATETIME (UTC)	No
	The instant at which a critical result was documented on a study.
90	RSLT_TRK_END_USR_ID	VARCHAR	No
	The user who completed the follow-up communication on a critical result.
91	RSLT_TRK_END_USR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
92	RSLT_TRK_END_DTTM	DATETIME (UTC)	No
	The instant at which a critical result follow-up communication was completed on a study.
93	PATH_LAB_ORDER_ID	NUMERIC	No
	The lab order that the pathology finding is documenting.
94	PATH_DOCUMENT_ID	VARCHAR	No
	The scanned document that the pathology finding is linked to.
95	PATH_BIOPSY_DATE	DATETIME	No
	The biopsy date for the tissue sample that the pathology finding corresponds to. This column will not include pre-upgrade data until after a specific workflow is done (ORD conversion 248404 has run to completion). If you are unsure whether this has happened yet, you can get the entire set of data if you COALESCE this column with the old column for the pathology biopsy date (ORDER_PROC_2.PATH_RSLT_DATE).
96	PATH_NOTE_ID	VARCHAR	No
	The unique ID of the user-entered, free-form text note that stores the comment/narrative text for the pathology finding as rich text format data. This column will not include pre-upgrade data until after a specific workflow is done (ORD conversion 248404 run to completion). If you are unsure whether this has happened yet, you can get the entire set of data if you COALESCE this column with the old column for pathology comment/narrative text (ORDER_PROC_4.PATH_NARR_NOTE_ID).
97	RSLT_TRK_FND_COMMNT	VARCHAR	No
	The comment associated with a critical result finding.
98	RESULT_NAME	VARCHAR	No
	Stores the result name.