ORDER_RAD_ASMT
Description:
This table stores mammography assessment-related information for an order.

Primary Key
Column Name Ordinal Position
ORDER_PROC_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 ORDER_PROC_ID NUMERIC No
The unique ID of the order record associated with this procedure order.
2 CONTACT_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 ASSESSMENT_C_NAME VARCHAR No
The mammography assessment category number for the order.
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
4 RIGHT_ASMT_C_NAME VARCHAR No
The mammography right assessment category number for the order.
The category values for this column were already listed for column: ASSESSMENT_C_NAME
5 LEFT_ASMT_C_NAME VARCHAR No
The mammography left assessment category number for the order.
The category values for this column were already listed for column: ASSESSMENT_C_NAME
6 MAM_OV_ASMT_CALC_YN VARCHAR No
A Boolean value that indicates whether overall assessment is auto-calculated.
May contain organization-specific values: No
Category Entries:
No
Yes
7 MAM_LT_ASMT_CALC_YN VARCHAR No
A Boolean value that indicates whether left assessment is auto-calculated.
The category values for this column were already listed for column: MAM_OV_ASMT_CALC_YN
8 MAM_RT_ASMT_CALC_YN VARCHAR No
A Boolean value that indicates whether right assessment is auto-calculated.
The category values for this column were already listed for column: MAM_OV_ASMT_CALC_YN