ORDER_RAD_READING
Description:
This table stores reading physician information for imaging procedures.

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 reading radiologists for an order.
3 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.
4 READING_DT DATETIME No
The date that the study was read by the reading radiologist (PROV_ID) -- i.e., the date that the radiologist performed any action on the study.
5 READ_PHYS_SPEC_C_NAME VARCHAR No
The reading physician roles category ID for the order.
May contain organization-specific values: Yes
Category Entries:
Other
Radiology
Cardiology
Ophthalmology
Obstetrics
Test Supervisor
ECG Reader
Echo Reader
SPECT Reader
6 READING_RESIDENT_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.
7 READ_UTC_DTTM DATETIME (UTC) No
The date and time in UTC format when the reading physician made a change to the study.