ORD_SPECIALTY_SIGNATURES
Description:
This table stores information about the required specialties for an order.

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier (.1 item) for the order record.
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 NUM_SIG_REQ_BY_SPECIALTY INTEGER No
This column stores the number of signatures required by a given specialty.
4 BILLING_SPECIALTY_YN VARCHAR No
Indicates if providers of the given specialty can also be the billing provider. 'Y' indicates that the provider can also be the billing provider, 'N' or NULL indicates that they can not.
May contain organization-specific values: No
Category Entries:
Yes
No
5 REQ_SPECIALTIES_C_NAME VARCHAR No
The Reading Physician Roles category ID for the specialties required for resulting the study.
May contain organization-specific values: Yes
Category Entries:
Other
Radiology
Cardiology
Ophthalmology
Obstetrics
Test Supervisor
ECG Reader
Echo Reader
SPECT Reader