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.