RESULT_AUDIT
Description:
This table is part of a group of tables that extracts audit information related to a finding. Each row specifies an action performed on the finding, along with the new values recorded for the items being audited. This table is very similar in structure to ORDER_RAD_AUDIT, which stores the audit trail of imaging orders.
The tables RESULT_AUDIT_ITEMS, RESULT_AUD_PATH_CODES, and RESULT_AUD_MALIG_TYPE contain the rest of the finding audit information not found in this table. Join to these three tables from RESULT_AUDIT using the two primary keys FINDING_ID and LINE.

Primary Key
Column Name Ordinal Position
FINDING_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 FINDING_ID NUMERIC No
The unique ID of 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 ACTION_PERFORMED_C_NAME VARCHAR No
The action category ID for the action being audited.
May contain organization-specific values: Yes
Category Entries:
Pathology Result Created
Pathology Result Edited
Pathology Result Deleted
4 ACTION_DTTM DATETIME (UTC) No
The instant at which the audited action was performed.
5 PERFORMING_USER_ID VARCHAR No
The user who performed the audited action.
6 PERFORMING_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
7 LESION_CLASS_C_NAME VARCHAR No
The lesion classification category ID, if any, for the action being audited.
May contain organization-specific values: Yes
Category Entries:
Benign
High Risk
Malignant
Premalignancy - Hyperplasia
Malignant - Non-lung
Clinical - without histology
Non-diagnostic
Other (please specify)
Unknown
8 LESION_SIDE_C_NAME VARCHAR No
The pathology finding side category ID, if any, for the action being audited.
May contain organization-specific values: No
Category Entries:
Right
Left
Both
9 PATH_RESULT_DT DATETIME No
The new value for the pathology finding biopsy date (RES-52340), if any, for the action being audited.