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