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.