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_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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.