ORD_DICOM_SCHED_PROC_STEP
Description:
This table contains information about orders' DICOM scheduled procedure step.

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 SPS_ID VARCHAR No
The DICOM Scheduled Procedure Step ID.
4 SPS_MOD_ID VARCHAR No
The identifier (ID) of the provider (SER) record of the modality that this scheduled procedure step was generated for.
5 SPS_PROC_ID NUMERIC No
The identifier (ID) of the procedure (OPE) record of the modality that this scheduled procedure step was generated for.
6 SPS_APPT_PAT_ENC_CSN_ID NUMERIC No
The contact serial number of the appointment that this scheduled procedure step was generated for.