ORDER_RES_LESION

Description: |
The ORDER_RES_LESION table contains information about breast imaging findings and pathology results. Specifically, the MAMMO_LESION_ID column contains the lesion associated with the breast imaging finding or the pathology result. A lesion may be linked to multiple findings if the lesion was evaluated on multiple imaging exams. A lesion may be linked to multiple pathology results if the lesion was biopsied multiple times.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique identifier for the finding 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_LESION_ID | NUMERIC | No |
This column contains breast lesion IDs. In mammography, each lesion might have more than one finding record that contains information such as radiologist findings and pathology results. All finding records that are for the same lesion are linked to the lesion record using lesion IDs.