MAMMO_RESPONSIBLE_PHYS

Description:

This table stores information regarding physicians responsible for breast imaging outcomes.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	MAMMO_RESP_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
4	PHYS_ASMT_C_NAME	VARCHAR	No
	The overall assessment category ID for the order made by the responsible physician. 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
5	PHYS_RIGHT_ASMT_C_NAME	VARCHAR	No
	The right assessment category ID for the order made by a responsible physician. The category values for this column were already listed for column: PHYS_ASMT_C_NAME
6	PHYS_LEFT_ASMT_C_NAME	VARCHAR	No
	The left assessment category ID for the order made by a responsible physician. The category values for this column were already listed for column: PHYS_ASMT_C_NAME