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