ORDER_APPT_INFO
Description:
This table stores appointment-level exam information.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique ID of the order record associated with this procedure order.
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 APPT_STUDY_STATUS_C_NAME VARCHAR No
The imaging study status category ID for an order linked to an appointment (Ordered, No Show, Scheduled, etc).
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
4 APPT_EXAM_BGN_DATE DATETIME No
The beginning date for an appointment exam.
5 APPT_EXAM_BGN_TIME DATETIME (Local) No
The beginning time for an appointment exam.
6 APPT_EXAM_END_DATE DATETIME No
The exam end date for multiple appointments scheduled with a single order (such as in nuclear medicine, where a single order would be associated with two exams, for an image and a delayed image).
7 APPT_EXAM_END_TIME DATETIME (Local) No
The exam end time for multiple appointments scheduled with a single order (such as in nuclear medicine, where a single order would be associated with two exams, for an image and a delayed image).
8 APPT_TECH_ID VARCHAR No
The unique identifier for the lead technologist for multiple appointments scheduled with a single order (such as in nuclear medicine, where a single order would be associated with two exams, for an image and a delayed image).
9 APPT_TECH_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.