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
Follow up with specialist
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
T1
T2
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
M1
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
Post-treatment
Recurrent
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
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
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 | SIDE_C_NAME | VARCHAR | Yes |
The documented side of the mark.
May contain organization-specific values: No
Category Entries:
Right
Left
69 | MARK_SIZE | NUMERIC | Yes |
The size of the mark.
70 | MARK1_POSX | INTEGER | Yes |
The X coordinate for mark 1.
71 | MARK1_POSY | INTEGER | Yes |
The Y coordinate for mark 1.
72 | MARK2_POSX | INTEGER | Yes |
The X coordinate for mark 2.
73 | MARK2_POSY | INTEGER | Yes |
The Y coordinate for mark 2.
74 | DRAW1_COORDS | VARCHAR | Yes |
The coordinates of the drawing in view 1 of the breast image.
75 | DRAW2_COORDS | VARCHAR | Yes |
The coordinates of the drawing in view 2 of the breast image.
76 | 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
77 | OLD_DEPTH | NUMERIC | Yes |
The depth of a mark.
78 | MARK1_X_POS | INTEGER | Yes |
The X position of the mark in view 1 of the breast image.
79 | MARK1_Y_POS | INTEGER | Yes |
The Y position of the mark in view 1 of the breast image.
80 | MARK2_X_POS | INTEGER | Yes |
The X position of the mark in view 2 of the breast image.
81 | MARK2_Y_POS | INTEGER | Yes |
The Y position of the mark in view 2 of the breast image.
82 | VIEW1_COORDS | VARCHAR | Yes |
The coordinates of the drawing in view 1 of the breast image.
83 | VIEW2_COORDS | VARCHAR | Yes |
The coordinates of the drawing in view 2 of the breast image.
84 | 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
85 | RES_NOTE_TAG | VARCHAR | No |
Used to uniquely identify the sentence that corresponds to the findings from a note.
86 | STDY_LVL_FINDING_IDENT | VARCHAR | No |
This column stores a unique identifier for a breast imaging finding on an individual study.
87 | MAMMO_PATH_ORDER_ID | NUMERIC | No |
This column stores the order ID that the mammo pathology result is attached to.
88 | AUTOLINK_START_DATE | DATETIME | No |
Earliest date for general recommendations where auto-linking is allowed.
89 | AUTOLINK_END_DATE | DATETIME | No |
Latest date for general recommendations where auto-linking is allowed.
90 | 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
Version 9
Unknown