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
Auditory Brainstem Response
Auditory Evoked Potentials
Newborn Hearing Screening
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
Cataract Lens Calculation
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
MUGA Details
Bilateral Blood Pressure
ABI Measurements
Right Lower Doppler Waveforms
Left Lower Doppler Waveforms
Right Lower PVR
Left Lower PVR
Right Lower Digit PPG
Left Lower Digit PPG
Lower Digit PPG Measurements
Exercise ABI
Laser Doppler Measurements
Popliteal Entrapment Measurements
Right WBI
Left WBI
Right WBI Measurements
Right Upper PVR
Left Upper PVR
Right Upper Digit PPG
Left Upper Digit PPG
Left WBI Measurements
Right Upper Doppler Waveforms
Left Upper Doppler Waveforms
Right Provocative Test
Left Provocative Test
Right Thoracic Outlet Syndrome
Left Thoracic Outlet Syndrome
TIPS
Endoscopy Procedure Details
Patient Friendly Report Summary
Cervical Cancer Finding
Abscess
Palpable Mass
Generic Finding
Tympanogram
Audiogram
Speech Audiometry
Acoustic Reflex
Auditory Brainstem Response
Auditory Evoked Potentials
Newborn Hearing Screening
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
Renal Lesion
Pancreatic Lesion
Intracranial Aneurysm
Cervical Aneurysm
Thoracic Aneurysm
Abdominal Aortic Aneurysm
Abdominal Non-Aortic Aneurysm
Other Aneurysm
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.