ORDER_RAD_AUDIT

Description: |
ORDER_RAD_AUDIT stores information about imaging audit actions logged on procedure records.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_PROC_ID | NUMERIC | No |
The unique ID of the procedure order record.
2 | LINE | INTEGER | No |
The line count for this table as determined by the number of audit actions performed on an order.
3 | AUDIT_ACT_C_NAME | VARCHAR | No |
The auditing category ID for the radiology action that took place.
May contain organization-specific values: No
Category Entries:
Appointment Scheduled
Exam Begun
Exam Ended
Physicians Assigned
Saved
Signed
Status Changed
Appointment Canceled
Appt Rescheduled
Sent to Transcription
Transcribed
Marked as Preliminary
Marked as Queued Prelim
Sent to Queued Trans
Queued Signed
Status Coordinated
Unlinked from Appointment
Linked to Appointment
Needs Review
Queued Needs Review
Procedure Changed
Accession Number Changed
Modifier Changed
Appointment Reassigned
Removed
Procedure Started
Procedure Finished
Procedure Discontinued
DICOM Message Linked
System Removed
Override Begin/End Stop
Order Released
Finalized Protocol
Cleared Protocol
EOD Processing
Final by Administrator
Background Processing
Sent for Resident Revision
External Read Added to Work List
Permanent Transfer Added To Study History
Back to Lists
Unlinked from Study
Linked to Study
Study Claimed - Reading Physician
Move Result
DICOM SR Results Filed
Revise Final Study
Marked as Wet Read
Marked as No Protocols Needed
Saved in Update Asmt/Recs Activity
Flagged For Scheduling
Signed After Procedure Changed
Procedure Changed After Final
Sent for Tech Revision
Reassigned Protocol
Completed by Tech
Routed Protocol
Documented by Tech
Result Tracking Updated
Result Tracking Required
Result Tracking Completed
Provider Changed After Final
Auto Finalized
Procedure Correction
Screening Form Created
Screening Form Completed
Order Canceled
Updated Protocol
Letter Needed
Letter Not Needed
CC Recipients Changed
QT Elements Edited
Updated Image Availability
Refreshed Mammo Reporting Data
Images Linked to Order
Images Unlinked from Order
Study Marked as Reviewed
Sign Order
Change Order
Order Updated by Interface
Patient Contact Mover
Last Procedure Changed
Mammo History Updated
Synchronized Protocol
Screening Form Created From Order Sign
Ordering Provider Changed
Ordering Department Changed
Diagnosis Changed
Resulting Agency Change
Performable Changed After Final
Order Created
Findings Copied from a Previous Study
Verified Findings Copied from a Previous Study
Study Restored
Order Note
Automatic Comparison Selection
Update Comparison Studies
Correct ECG Scheduling
Reading Physician Updated
Updated By Conversion
Created By Care Everywhere Order Reconciliation
Updated by Administrative Utility
NLP Results Added
NLP Results Modified
NLP Results Verified
NLP Results Removed
NLP Results Removed via Interface
NLP Status Changed
Self-Referred Value Changed
Study Details Changed After Final
SmartData Element Updated By Code
NLP Results Verified And Routed
AFM Rule Evaluated
PCP Excluded from Unverified Results Routing by Rule
Dental Procedure Change
Dental Procedure Completion
Endo Quality Metrics Backfilled by AI
Hemodynamics Data Changed After Final
External Images Requested
External Images Received
Study Claimed - Technologist
Study Unclaimed - Technologist
Study Assigned - Technologist
Marked as Path Not Needed
Undo Path Not Needed
NLP Results Excluded
4 | AUDIT_TM | DATETIME (Local) | No |
The date and time that an audit action took place.
5 | USER_ID | VARCHAR | No |
The user that performed the audited action.
6 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | AUDIT_ORDER_STAT_C_NAME | VARCHAR | No |
The study status category number for the order at the time of the audited event.
May contain organization-specific values: No
Category Entries:
Ordered
No Show
Scheduled
Arrived
Exam Begun
Procedure Started
Discontinued
Procedure Finished
Exam Ended
----- BEGIN READING PALETTE STATUSES -----
Tech Complete
Tech Revise
Resident Revise
Saved
Queued In Trans
In Transcription
Incomplete Transcription
Transcribed
Wet Read
Queued Prelim
Preliminary
Queued Needs Review
Needs Review
Revised
Queued Final
Final
Cadence Non-Imaging Order
8 | AUD_TECH_USER_ID | VARCHAR | No |
The unique identifier of the user that was the technologist user related to the audit action. The source item is located at ORDER_PROC.TECHNOLOGIST_ID.
9 | AUD_TECH_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | AUD_TRANS_USER_ID | VARCHAR | No |
The unique identifier of the user that is the transcriptionist related to the audit action. The source item is located at ORDER_PROC.RIS_TRANS_ID.
11 | AUD_TRANS_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | AUD_CHG_STAT_REASON_C_NAME | VARCHAR | No |
The change status reason category ID for the audited order. The source item is located at ORDER_PROC_2.CHANGE_REASON_C.
May contain organization-specific values: Yes
Category Entries:
Other
Error
13 | AUD_EXAM_BG_DTTM | DATETIME (Attached) | No |
This column contains the audited information about the begin exam date and time. The source item is located at ORDER_PROC.PROC_BGN_TIME.
14 | AUD_EXAM_END_DTTM | DATETIME (Attached) | No |
This column contains the audited information about the end exam date and time. The source item is located at ORDER_PROC.PROC_END_TIME.
15 | AUD_PROC_BEG_DTTM | DATETIME (Local) | No |
This column contains the audited information about the begin date and time for the procedure. The source item is located at ORDER_PROC_2.MOD_BEGIN_TM.
16 | AUD_PROC_END_DTTM | DATETIME (Local) | No |
This column contains the audited information about the end date and time for the procedure. The source item is located at ORDER_PROC_2.MOD_END_TM.
17 | AUD_OVRD_BGNEND_HS_DTTM | DATETIME (Attached) | No |
This column contains the audit information for the last time a user overrode a hard stop at begin/end. The source item is located at ORDER_PROC_2.OVERRIDE_TM.
18 | AUD_CHG_STAT_CMT | VARCHAR | No |
This column contains comments about the change status reason. The source item is located at ORDER_PROC_2.CHANGE_CMT.
19 | AUD_RSLT_PRTY_C_NAME | VARCHAR | No |
The priority category ID of the result priority of the audited order. The source item is located at ORDER_PROC_2.ORDER_PRIORITY_C.
May contain organization-specific values: Yes
20 | AUD_RELEASED_ORD | VARCHAR | No |
This column contains the audited information about the future/standing order released child instant. The source item is located at ORDER_PROC.INSTANTIATED_TIME.
21 | AUD_NUM_SIG_REQ | INTEGER | No |
This column contains the audited information about the number of signatures required for the study. The source item is located at ORDER_PROC_3.NUM_SIG_REQ.
22 | AUD_GROUPER_ORDER_ID | NUMERIC | No |
The unique identifier of the order that represents the MOPS (Multiple Orders Per Study) Order ID. The source item is located at ORDER_PROC_2.GRP_ORDER_PROC_ID.
23 | AUD_OVERALL_BRST_DENS_C_NAME | VARCHAR | No |
The overall breast density category ID for the audited order. The source item is located at ORDER_STATUS.OVRL_BREAST_DENS_C.
May contain organization-specific values: Yes
Category Entries:
Almost entirely fatty
Scattered fibroglandular density
Heterogeneously dense
Extremely dense
Unknown
24 | AUD_RIGHT_BRST_DENS_C_NAME | VARCHAR | No |
The right breast density category ID for the audited order. The source item is located at ORDER_STATUS.RIGHT_BREAST_DENS_C.
The category values for this column were already listed for column: AUD_OVERALL_BRST_DENS_C_NAME
25 | AUD_LEFT_BRST_DENS_C_NAME | VARCHAR | No |
The left breast density category ID for the audited order. The source item is located at ORDER_STATUS.LEFT_BREAST_DENS_C.
The category values for this column were already listed for column: AUD_OVERALL_BRST_DENS_C_NAME
26 | AUD_OVERALL_ASMT_C_NAME | VARCHAR | No |
The overall assessment category ID for the audited order. The source item is located at ORDER_RAD_ASMT.ASSESSMENT_C.
May contain organization-specific values: Yes
Category Entries:
Need Additional Imaging Evaluation
Negative
Benign
Probably Benign
Suspicious
Highly Suggestive of Malignancy
Known Biopsy-Proven Malignancy
Post-Procedure Mammogram for Marker Placement
Need Prior Mammograms for Comparison
Low Suspicion for Malignancy
Moderate Suspicion for Malignancy
High Suspicion for Malignancy
27 | AUD_RIGHT_ASMT_C_NAME | VARCHAR | No |
The right assessment category ID for the audited order. The source item is located at ORDER_RAD_ASMT.RIGHT_ASMT_C.
The category values for this column were already listed for column: AUD_OVERALL_ASMT_C_NAME
28 | AUD_LEFT_ASMT_C_NAME | VARCHAR | No |
The left assessment category ID for the audited order. The source item is located at ORDER_RAD_ASMT.LEFT_ASMT_C.
The category values for this column were already listed for column: AUD_OVERALL_ASMT_C_NAME
29 | AUD_READING_PRI_C_NAME | VARCHAR | No |
The priority category ID of the imaging reading priority for the audited order. The source item is located at ORDER_PROC_2.READING_PRIORITY_C.
The category values for this column were already listed for column: AUD_RSLT_PRTY_C_NAME
30 | AUD_MAM_LTR_TMPLT_SMARTTEXT_ID | VARCHAR | No |
This column contains the audited information about the result letter template. The source item is located at ORDER_STATUS.RIS_LET_TEMPLT_ID.
31 | AUD_MAM_LTR_TMPLT_SMARTTEXT_ID_SMARTTEXT_NAME | VARCHAR | No |
The name of the SmartText record.
32 | AUD_OVRL_TC_C_NAME | VARCHAR | No |
The overall tissue composition category ID for the audited order. The source item is located at ORDER_STATUS.OVRL_TISSUE_COMP_C.
May contain organization-specific values: No
Category Entries:
Homogeneous background echotexture - fat
Homogeneous background echotexture - fibroglandular
Heterogeneous background echotexture
33 | AUD_RIGHT_TC_C_NAME | VARCHAR | No |
The right tissue composition category ID for the audited order. The source item is located at ORDER_STATUS.RIGHT_TISSUE_COMP_C.
The category values for this column were already listed for column: AUD_OVRL_TC_C_NAME
34 | AUD_LEFT_TC_C_NAME | VARCHAR | No |
The left tissue composition category ID for the audited order.The source item is located at ORDER_STATUS.LEFT_TISSUE_COMP_C.
The category values for this column were already listed for column: AUD_OVRL_TC_C_NAME
35 | AUD_OVRL_FGT_C_NAME | VARCHAR | No |
The overall amount of fibroglandular tissue category ID for the audited order. The source item is located at ORDER_STATUS.OVRL_FGT_C.
May contain organization-specific values: No
Category Entries:
Almost entirely fat
Scattered fibroglandular tissue
Heterogeneous fibroglandular tissue
Extreme fibroglandular tissue
36 | AUD_RIGHT_FGT_C_NAME | VARCHAR | No |
The right amount of fibroglandular tissue category ID for the audited order. The source item is located at ORDER_STATUS.RIGHT_FGT_C.
The category values for this column were already listed for column: AUD_OVRL_FGT_C_NAME
37 | AUD_LEFT_FGT_C_NAME | VARCHAR | No |
The left amount of fibroglandular tissue category ID for the audited order. The source item is located at ORDER_STATUS.LEFT_FGT_C.
The category values for this column were already listed for column: AUD_OVRL_FGT_C_NAME
38 | AUD_OVRL_BPE_C_NAME | VARCHAR | No |
The overall background parenchymal enhancement category ID for the audited order. The source item is located at ORDER_STATUS.OVRL_BPE_C.
May contain organization-specific values: No
Category Entries:
Minimal
Mild
Moderate
Marked
39 | AUD_RIGHT_BPE_C_NAME | VARCHAR | No |
The right background parenchymal enhancement category ID for the audited order. The source item is located at ORDER_STATUS.RIGHT_BPE_C.
The category values for this column were already listed for column: AUD_OVRL_BPE_C_NAME
40 | AUD_LEFT_BPE_C_NAME | VARCHAR | No |
The left background parenchymal enhancement category ID for the audited order. The source item is located at ORDER_STATUS.LEFT_BPE_C.
The category values for this column were already listed for column: AUD_OVRL_BPE_C_NAME
41 | AUD_SYMMETRIC_BPE_C_NAME | VARCHAR | No |
The symmetric background parenchymal enhancement category ID for the audited order. The source item is located at ORDER_STATUS.SYMMETRIC_BPE_C.
May contain organization-specific values: No
Category Entries:
Symmetric
Asymmetric
42 | AUD_IL_PRI_ORDER_ID | NUMERIC | No |
The unique identifier of the order that is the image linked primary order. The source item is located at ORDER_PROC_4.IMG_PRIMARY_ORD_ID.
43 | AUD_HORMONES_NO_HISTORY | VARCHAR | No |
Audit of the 'No Hormone History' item for hormones relevant to breast imaging exams captured in the hormone history navigator. The source item is located at ORDER_PROC_4.MAM_HORMONE_NONE_YN.