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 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 NLP Results Verified And Routed AFM Rule Evaluated PCP Excluded from Unverified Results Routing by Rule Dental Procedure Change Dental Procedure Completion Hemodynamics Data Changed After Final
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.