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
Began Exam
Ended Exam
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
Claim Study
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
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 fatty
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.