RESULT_AUD_MALIG_TYPE

Description:

This table contains the malignancy types that were changed during a finding record audit action. For one audit action there can be multiple malignancy types that were changed; this corresponds to the third primary key in this table, VALUE_LINE. This table will likely be joined to from RESULT_AUDIT, which holds the majority of the finding audit information.

Primary Key

Column Name	Ordinal Position
FINDING_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	FINDING_ID	NUMERIC	No
	The unique ID of the finding record.
2	GROUP_LINE	INTEGER	No
	The line number of the associated audit information in this finding record. Together with FINDING_ID, this forms the foreign key to the RESULT_AUDIT table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple malignancy types that are associated with the finding audit information from the RESULT_AUDIT table.
4	MALIGNANCY_TYPE_C_NAME	VARCHAR	No
	The malignancy type category ID, if any, for the action being audited. May contain organization-specific values: Yes Category Entries: Invasive Non-Invasive Other Invasive and In Situ