ORDER_RAD_STUDY

Description: |
This table stores information about actions performed on the study in imaging departments.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_PROC_ID | NUMERIC | No |
The unique ID of the order record associated with this procedure order.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | STUDY_MODE_C_NAME | VARCHAR | No |
The mode category ID for this study (Study Review, Transcription Entry).
May contain organization-specific values: No
Category Entries:
Study Review
Transcription Entry
Tech Entry
Revise Results
Wet Read
Procedure Documentation
Reading Work List
External Order
4 | USER_ID | VARCHAR | No |
The user ID of the user performing the study action.
5 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
7 | STUDY_CHAR_CNT | INTEGER | No |
The character count for the current study. Typically used to track transcriptionist productivity.
8 | AUDIT_ACT_C_NAME | VARCHAR | No |
The action category ID for the study (sent to transcription, signed, etc.)
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
9 | STUDY_TIME | INTEGER | No |
The amount of time (in seconds) the study was open.
10 | DISCREPANCY_C_NAME | VARCHAR | No |
The discrepancy category ID, populated when another physician has a discrepancy with the previous result for this exam.
May contain organization-specific values: Yes
Category Entries:
Discrepancy
No Discrepancy
11 | DISCREPANCY_CMNT | VARCHAR | No |
A free text comment associated with a discrepancy.
12 | DISCREPANCY_READ_YN | VARCHAR | No |
Indicates whether a discrepancy has been acted on for this order. 'Y' indicates the discrepancy has been acted upon.
May contain organization-specific values: No
Category Entries:
No
Yes
13 | STUDY_LINE_CNT | INTEGER | No |
This stores the number of imaging result text lines added with the contact. It is intended to be used in imaging transcription productivity reporting. STUDY_CHAR_CNT and STUDY_WORD_CNT can also be used for character and word counts of result text added in any given contact. All contacts should be reported on, not just the most recent contact.
14 | STUDY_FINDING_SDE_COUNT | INTEGER | No |
Total number of SmartData elements from study findings documented on the contact.
15 | IMAGING_STUDY_USER_TYPE_C_NAME | VARCHAR | No |
The imaging study user type category ID for this user for this order's contact from Study Review.
May contain organization-specific values: No
Category Entries:
Finalizing Provider
Reading Provider
Non-Reading User
16 | PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
17 | POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.