ORDER_RES_2
Description:
The ORDER_RES_2 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 for the finding record.
2 EXTERNAL_RESULT_YN VARCHAR No
Indicates if the biopsy or surgery for a pathology result was performed outside of the organization. 'Y' indicates it was performed externally. Typically used to exclude these result findings from measures that evaluate the quality of an organization's pathology resulting.
May contain organization-specific values: No
Category Entries:
No
Yes
3 EXTERNAL_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
4 EXTERNAL_LOC_CMT VARCHAR No
The free-text name of the external location that resulted the pathology. Used in cases where the location does not have a location definitions (EAF) record.
5 PATH_SPECIMEN_ID NUMERIC No
Links to the specimen that this pathology finding is documenting.
6 FIRST_DOCUMENTED_DT DATETIME No
The date on which a mammography lesion was first documented.
7 FINDING_INCLUDED_YN VARCHAR No
Indicates whether this finding has been marked as included on an imaging study. Y indicates that the finding is included. N indicates that the finding is not included on the study. A null value indicates data from before the 2014 release and should be considered the same as Y.
The category values for this column were already listed for column: EXTERNAL_RESULT_YN
8 LESION_NAME INTEGER No
A unique identifier for a lesion on a patient to track its changes.
9 LESION_ASSESSMENT_C_NAME VARCHAR No
The mammography assessment category ID for the lesion.
May contain organization-specific values: Yes
Category Entries:
Need Additional Imaging Evaluation
Negative
Benign
Probably Benign
Suspicious
Highly Suggestive of Malignancy
Known Biopsy-Proven Malignancy
Post-Procedure Mammogram for Marker Placement
Need Prior Mammograms for Comparison
Low Suspicion for Malignancy
Moderate Suspicion for Malignancy
High Suspicion for Malignancy
10 REM_LET_SUPPRESS_YN VARCHAR No
Indicates if an automated process for reminder letters should suppress the creation of a reminder letters for this record. 'Y' indicates that automatic reminder letters should be suppressed for this recommendation.
The category values for this column were already listed for column: EXTERNAL_RESULT_YN
11 REM_LET_SUPP_RSN_C_NAME VARCHAR No
The category ID for the reason why reminder letters were suppressed for a particular recommendation record. For example, letters may be suppressed due to an import of recommendations from a legacy system, or they may be suppressed due to logic in the reminder letter batch.
May contain organization-specific values: Yes
Category Entries:
Utility
Batch
12 PRIMARY_TUMOR_C_NAME VARCHAR No
The primary tumor category ID, as defined in NMD 3.0., for a result.
May contain organization-specific values: No
Category Entries:
TX
T0
Tis
Tis (DCIS)
Tis (LCIS)
Tis (Paget's)
T1
T1mi
T1a
T1b
T1c
T2
T3
T4
T4a
T4b
T4c
T4d
13 REGIONAL_LYMPH_ND_C_NAME VARCHAR No
The regional lymph nodes category ID, as defined in NMD 3.0, for a result.
May contain organization-specific values: No
Category Entries:
NX
N0
N1
N2
N2a
N2b
N3
N3a
N3b
N3c
N1mi
14 DIST_METASTASES_C_NAME VARCHAR No
The distant metastases category ID of a result, as defined for NMD 3.0
May contain organization-specific values: No
Category Entries:
M0
cM0(i+)
M1
15 VESSEL_PROC_TYPE_C_NAME VARCHAR No
The procedure type category ID for a vessel result finding.
May contain organization-specific values: No
Category Entries:
Cath
CT Angiography
Vascular Ultrasound
16 CLOSEST_MRGN_NAME_C_NAME VARCHAR No
The closest margin category ID for a breast legion.
May contain organization-specific values: Yes
Category Entries:
Anterior
Posterior
Superior
Inferior
Medial
Lateral
17 CLOSEST_MARGIN_DIST NUMERIC No
The closest margin measurement for a breast lesion
18 LESION_PRE_ST_GRD_C_NAME VARCHAR No
The pre-stenosis value category ID for the lesion, when the value is saved as a grade.
May contain organization-specific values: Yes
Category Entries:
Normal
Minimal (1-24%)
Mild (25-49%)
Moderate (50-69%)
Severe (70-99%)
Occluded
19 LESION_POS_ST_GRD_C_NAME VARCHAR No
The post-stenosis value category ID for the lesion, when the value is saved as a grade.
The category values for this column were already listed for column: LESION_PRE_ST_GRD_C_NAME
20 LAST_SX_PROG_REC_C_NAME VARCHAR No
The recommendation category ID for the most recent type of this follow-up recommendation, which should be associated with a study for a screening program.
May contain organization-specific values: Yes
Category Entries:
Follow Up LDCT in 1 Year
Follow Up LDCT in 6 Months
Follow Up LDCT in 3 Months
Biopsy
Obtain Prior Studies for Comparison
Additional Imaging
Await pathology results
No further screening colonoscopies necessary
Repeat screening colonoscopy in 10 years
Repeat colonoscopy in 7 years
Repeat colonoscopy in 5 years
Repeat colonoscopy in 3 years
Repeat colonoscopy in 1 year
Schedule repeat colonoscopy
Follow up with me in clinic
Follow up with PCP
Await pathology results
Repeat sigmoidoscopy in 10 years
Repeat sigmoidoscopy in 5 years
Schedule repeat sigmoidoscopy
Schedule full colonoscopy
No further screening sigmoidoscopies necessary
Follow up with me in clinic
Follow up with PCP
Await pathology results
Follow up with me in clinic
Follow up with PCP
Schedule repeat EGD
Schedule follow-up procedure for continued treatment
Await pathology results
Follow up with me in clinic
Follow up with PCP
Schedule repeat upper EUS
Schedule follow-up procedure for continued treatment
Await pathology results
Follow up with me in clinic
Follow up with PCP
Schedule repeat ERCP
Schedule follow-up procedure for continued treatment
Await pathology results
Follow up with me in clinic
Follow up with PCP
Schedule repeat LEUS
Schedule follow-up procedure for continued treatment
Await pathology results
Follow up with me in clinic
Follow up with PCP
Schedule repeat enteroscopy
Schedule follow-up procedure for continued treatment
Await pathology results
Follow up with me in clinic
Follow up with PCP
Follow up with referring physician
Follow up EBUS
Schedule repeat bronchoscopy
Follow up bronchoscopy
Follow up PFT
Await pathology results
Follow up with me in clinic
Follow up with PCP
Schedule repeat retrograde enteroscopy
Schedule follow-up procedure for continued treatment
Follow up LDCT in 1 Month
Diagnostic CT Chest
Await pathology results
Repeat pouchoscopy in 10 years
Repeat pouchoscopy in 5 years
Schedule repeat pouchoscopy
No further recurring pouchoscopies necessary
Follow up with me in clinic
Follow up with PCP
Await pathology results
Follow up with me in clinic
Follow up with PCP
Schedule repeat ileoscopy
Schedule follow-up procedure for continued treatment
Follow up with me in clinic
Follow up with PCP
Ablation
Excision
Endometrial biopsy
Endocervical curettage
Colposcopy
Colposcopy in 4 months
Colposcopy in 6 months
Colposcopy in 12 months
Colposcopy post-partum
HPV testing
HPV testing in 6 months
HPV testing in 12 months
HPV testing in 2 years
HPV testing in 3 years
HPV testing in 5 years
HPV typing
HPV typing 16/18
Cotesting
Pap
Pap in 6 months
Pap in 12 months
Pap in 2 years
Pap in 3 years
Pap in 5 years
Pap post-partum
Refer to GYN
Refer to GYN ONC
Screening no longer indicated
Other Cervical Cancer Screen Follow-up
Start screening colonoscopies at appropriate age per current guidelines
Colposcopy in 2 years
Colposcopy in 3 years
Colposcopy in 5 years
Colposcopy immediately
HPV testing in 4 months
HPV testing immediately
Pap in 4 months
Pap immediately
Referral for further clinical evaluation
PET/CT
Pulmonology Consult
Historic Follow-up Documentation for CCS Screening
Repeat pouchoscopy in 1 year
Repeat pouchoscopy in 3 years
21 LST_SX_PG_REC_LOC_C_NAME VARCHAR No
The location of the body category ID for the most recent location associated with this follow-up recommendation.
May contain organization-specific values: No
Category Entries:
Right
Left
Bilateral
Right Upper Lobe
Right Middle Lobe
Right Lower Lobe
Left Upper Lobe
Lingula
Left Lower Lobe
Left Hilum
Right Hilum
Right Middle and Right Lower Lobes
Right Upper and Right Middle Lobes
Lingula
Other
Unknown
22 SX_PROGRAM_TYPE_C_NAME VARCHAR No
The screening program type category ID associated with this finding.
May contain organization-specific values: No
Category Entries:
Lung Screening
Breast Screening
Colorectal Follow-up
EGD Follow-up
Upper EUS Follow-up
ERCP Follow-up
Diabetic Retinopathy Screening
Sigmoidoscopy Follow-up
Lower EUS Follow-up
Antegrade Enteroscopy Follow-up
Bronchoscopy Follow-up
Retrograde Enteroscopy Follow-up
Pouchoscopy Follow-Up
Ileoscopy Follow-Up
Actionable Finding
Cervical Cancer Screening
23 PATH_LOCATION_CMT VARCHAR No
Lung cancer location comment for a pathology finding.
24 PATH_LOCATION_C_NAME VARCHAR No
The location of the body category ID for a pathology result finding.
The category values for this column were already listed for column: LST_SX_PG_REC_LOC_C_NAME
25 LUNG_STAGE_C_NAME VARCHAR No
The lung cancer staging category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
Stage 1A
Stage 1B
Stage 2A
Stage 2B
Stage 3A
Stage 3B
Stage 4
Stage 4A
Stage 4B
Stage 0
Stage IA1
Stage IA2
Stage IA3
Stage IIIC
Unknown
26 LUNG_HISTOLOGY_C_NAME VARCHAR No
The lung cancer histology category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
Non-small cell cancer
Small cell lung cancer
Carcinoid
Atypical carcinoid
Other
Unknown
27 LUNG_NON_SMALL_C_NAME VARCHAR No
The lung cancer histology category ID for a non small cell cancer pathology finding.
May contain organization-specific values: No
Category Entries:
Invasive adenocarcinoma
Squamous cell carcinoma
Adenosquamous cell carcinoma
Large cell carcinoma
Undifferentiated carcinoma
Other
28 LUNG_NON_SMALL_COMM VARCHAR No
Lung cancer histology comment for a non small cell cancer pathology finding.
29 LUNG_MALIG_C_NAME VARCHAR No
The lung malignancy type category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
Adenocarcinoma in situ
Minimally invasive
Invasive
Carcinoid
Non-invasive
Invasive status unknown
30 LUNG_PERIOD_FU_MON INTEGER No
Lung cancer period of follow-up for a pathology finding.
31 LUNG_DX_METHOD_C_NAME VARCHAR No
The lung cancer tissue diagnosis method category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
Percutaneous
Bronchoscopic
Surgical
Unknown
32 LUNG_T_STATUS_C_NAME VARCHAR No
The lung cancer histology T status category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
T1a
T1b
T2a
T2b
T3
T4
Tis
T0
T1c
T1mi
Unknown
TX
33 LUNG_N_STATUS_C_NAME VARCHAR No
The lung cancer histology N status category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
N0
N1
N2
N3
NX
34 LUNG_M_STATUS_C_NAME VARCHAR No
The lung cancer histology M status category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
M0
M1a
M1b
M1c
MX
35 LUNG_STAGE_METHOD_C_NAME VARCHAR No
The lung cancer staging method category ID for a pathology finding.
May contain organization-specific values: No
Category Entries:
Clinical
Pathologic
Unknown
36 LESION_INCOMP_RSN_C_NAME VARCHAR No
The incomplete reason category ID for the breast imaging finding. Only radiologist findings that have an assessment of incomplete (0) have a value populated for this column.
May contain organization-specific values: No
Category Entries:
Incomplete
Negative
Benign appearance or behavior
Probably benign
Suspicious - 4A
Very Suspicious - 4B
Very Suspicious - 4X
Clinically significant findings
Prior lung cancer
Incomplete coverage
Noise
Respiratory motion
Expiration
Obscured by acute abnormality
Unknown
Unable to complete
Inflammatory or infectious process
Not reported
Additional images for evaluation
Priors for comparison
Technical repeat
Version 1.0
Version 1.1
Version 2.0
37 SEGMENT_LOCATION_ID INTEGER No
The location of an annotation within the vessel segment if there are multiple annotations in the same segment.
38 ORIGIN_GRAFT_ID VARCHAR No
The specific branch and sequence of the current graft that this branch comes off of.
39 GRAFT_BRANCH_NUM INTEGER No
The branch identifier of the graft.
40 INST_EXAM_UTC_DTTM DATETIME (UTC) No
The instant (in UTC) when the Audiology exam was administered.
41 AUDIO_RELIABILITY_C_NAME VARCHAR No
The reliability category ID for the audiogram results. The possible responses are Good, Fair, or Poor.
May contain organization-specific values: No
Category Entries:
Good
Fair
Poor
42 PROBE_TONE INTEGER No
The probe tone frequency in Hz.
43 RES_LINK_ORDER_ID NUMERIC No
The unique ID of the order with which the result finding is associated.
44 FINDING_SUBTYPE_C_NAME VARCHAR No
The finding subtype category ID for the procedural finding.
May contain organization-specific values: No
Category Entries:
Asymmetry
Global Asymmetry
Focal Asymmetry
Developing Asymmetry
45 OB_US_EDD_ASOF_DATE DATETIME No
The patient's working estimated date of delivery at the time the ultrasound exam started.
46 OB_US_EDD_BASIS_C_NAME VARCHAR No
The category ID for the basis for the patient's estimated date of delivery (EDD), at the time when the ultrasound started.
May contain organization-specific values: Yes
Category Entries:
Other Basis
Last Menstrual Period
Est. Date of Conception
Embryo Transfer
Ultrasound
Uterus Size
Quickening
Fundal Ht. at Umbil.
FHR with Doppler
FHR with Fetoscope
Patient Reported
Alternate EDD Entry
47 REPORTING_CAT_C_NAME VARCHAR No
The category ID for the reporting category to use for a 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
48 LESION_FINDING_RSLT_NOTE_ID VARCHAR No
The rich text format result text for this lesion finding.
49 ANTERIOR_MARGIN_DIST NUMERIC No
The distance for anterior margin in millimeters (mm).
50 POSTERIOR_MARGIN_DIST NUMERIC No
The distance for posterior margin in millimeters (mm).
51 SUPERIOR_MARGIN_DIST NUMERIC No
The distance for superior margin in millimeters (mm).
52 INFERIOR_MARGIN_DIST NUMERIC No
The distance for inferior margin in millimeters (mm).
53 MEDIAL_MARGIN_DIST NUMERIC No
The distance for medial margin in millimeters (mm).
54 LATERAL_MARGIN_DIST NUMERIC No
The distance for lateral margin in millimeters (mm).
55 REMAINING_MARGINS_GT_DIST NUMERIC No
The greater than distance for the remaining margins (mm).
56 LAST_STATUS_CHNG_RSN_C_NAME VARCHAR No
The status change reason category ID for the recommendation.
May contain organization-specific values: Yes
Category Entries:
Patient Not Reachable
Patient Refused
Utility
Patient Deceased
Patient Unmarked Deceased
Pathology Entered
Closed via OPA Acknowledgement
Interim Order
External Interim Order
Verified
Created
Deleted
System
57 RECORD_STATUS_2_C_NAME VARCHAR No
The record status category ID for the result finding.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
58 RADIOLOGIST_FINDING_ORDER_ID NUMERIC No
The unique ID of the associated order for the radiologist finding. Null means that the finding is not on the latest version of the order and has been replaced by another result finding record.
59 LAST_INCLUDED_FINDING_ID NUMERIC No
The unique ID of the last finding documented for a breast lesion that was included in a study. This column represents the finding where a radiologist last documented on the lesion. Null means that the lesion was created but all associated findings were deleted and all associated orders were cancelled. This item will also be null for technologist findings.
60 FINDING_TEXT_HAS_EDITS_YN VARCHAR No
Indicates whether the finding text generated automatically (from a SmartForm) has been manually edited by users. 'Y' indicates there have been manual edits.
The category values for this column were already listed for column: EXTERNAL_RESULT_YN
61 MAMMO_NEOADJUVANT_CHEMO_YN VARCHAR No
Indicates whether the patient has had neoadjuvant chemotherapy. 'Y' indicates that neoadjuvant chemotherapy was administered.
The category values for this column were already listed for column: EXTERNAL_RESULT_YN
62 OB_US_CLASS_C_NAME VARCHAR No
The OB ultrasound classification category ID for the order.
May contain organization-specific values: Yes
Category Entries:
Standard
Limited
Specialized
Follow Up
63 LUNG_DX_COMMENT VARCHAR No
The diagnosis comment for the patient's pathology result.
64 LUNG_OTHER_ILD_TYPE_C_NAME VARCHAR No
The interstitial lung disease type category ID for the finding.
May contain organization-specific values: No
Category Entries:
UIP/IPF
ILD, Other
ILD, Unknown
65 LUNG_LCSR_SPECIFICATION VARCHAR No
The specified details entered by the user for the finding.
66 OB_UTZ_USERDEF_GA VARCHAR No
User defined GA for an ultrasound.
67 OB_UTZ_EDD_ON_SAVE_DATE DATETIME No
The working estimated date of delivery that was used to calculate the ultrasound study's gestational age. This item is not set if a Fetus GA was selected as the Study GA.
68 RES_ORDER_RADIOLOGY_STATUS_C_NAME VARCHAR No
The imaging study status category ID for the order associated with the RES record.
May contain organization-specific values: No
Category Entries:
Ordered
No Show
Scheduled
Arrived
Exam Begun
Procedure Started
Discontinued
Procedure Finished
Exam Ended
----- BEGIN READING PALETTE STATUSES -----
Tech Complete
Tech Revise
Resident Revise
Saved
Queued In Trans
In Transcription
Incomplete Transcription
Transcribed
Wet Read
Queued Prelim
Preliminary
Queued Needs Review
Needs Review
Revised
Queued Final
Final
Cadence Non-Imaging Order
69 SIDE_C_NAME VARCHAR Yes
The documented side of the mark.
May contain organization-specific values: No
Category Entries:
Right
Left
70 MARK_SIZE NUMERIC Yes
The size of the mark.
71 MARK1_POSX INTEGER Yes
The X coordinate for mark 1.
72 MARK1_POSY INTEGER Yes
The Y coordinate for mark 1.
73 MARK2_POSX INTEGER Yes
The X coordinate for mark 2.
74 MARK2_POSY INTEGER Yes
The Y coordinate for mark 2.
75 DRAW1_COORDS VARCHAR Yes
The coordinates of the drawing in view 1 of the breast image.
76 DRAW2_COORDS VARCHAR Yes
The coordinates of the drawing in view 2 of the breast image.
77 OLD_LOCATION_C_NAME VARCHAR Yes
The location of a mark.
May contain organization-specific values: No
Category Entries:
1 O'Clock
2 O'Clock
3 O'Clock
4 O'Clock
5 O'Clock
6 O'Clock
7 O'Clock
8 O'Clock
9 O'Clock
10 O'Clock
11 O'Clock
12 O'Clock
78 OLD_DEPTH NUMERIC Yes
The depth of a mark.
79 MARK1_X_POS INTEGER Yes
The X position of the mark in view 1 of the breast image.
80 MARK1_Y_POS INTEGER Yes
The Y position of the mark in view 1 of the breast image.
81 MARK2_X_POS INTEGER Yes
The X position of the mark in view 2 of the breast image.
82 MARK2_Y_POS INTEGER Yes
The Y position of the mark in view 2 of the breast image.
83 VIEW1_COORDS VARCHAR Yes
The coordinates of the drawing in view 1 of the breast image.
84 VIEW2_COORDS VARCHAR Yes
The coordinates of the drawing in view 2 of the breast image.
85 BI_LESION_REVIEW_C_NAME VARCHAR No
This item indicates whether there is currently review needed on this finding, which can be used to drive notifications in Study Review and before-signing warnings.
May contain organization-specific values: No
Category Entries:
No Review Needed
Review Recommended
Review Required
86 RES_NOTE_TAG VARCHAR No
Used to uniquely identify the sentence that corresponds to the findings from a note.
87 STDY_LVL_FINDING_IDENT VARCHAR No
This column stores a unique identifier for a breast imaging finding on an individual study.
88 MAMMO_PATH_ORDER_ID NUMERIC No
This column stores the order ID that the mammo pathology result is attached to.
89 AUTOLINK_START_DATE DATETIME No
Earliest date for general recommendations where auto-linking is allowed.
90 AUTOLINK_END_DATE DATETIME No
Latest date for general recommendations where auto-linking is allowed.
91 AJCC_VERSION_C_NAME VARCHAR No
The AJCC Version category ID for the pathology result.
May contain organization-specific values: No
Category Entries:
7th Edition
8th Edition
Unknown