ORDER_PROC_7

Description:

The ORDER_PROC_7 table enables you to report on the procedures ordered in the clinical system. This procedure table has the same basic structure as ORDER_PROC, but was created as a seventh table to prevent ORDER_PROC_6 from getting any larger.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier (.1 item) for the order record.
2	CLINICAL_SEX_PARAM_C_NAME	VARCHAR	No
	The "Sex Parameter for Clinical Use" (sex categorization that aligns most with the patient in the context of the current order) category ID for the order. May contain organization-specific values: No Category Entries: Female-Typical Male-Typical Complex Unknown
3	CLINICAL_SEX_PARAM_COMMENT	VARCHAR	No
	The "Sex Parameter for Clinical Use" (sex categorization that aligns most with the patient in the context of the current order) comments entered in the Order Composer.
4	CLINICAL_SEX_PARAM_UTC_DTTM	DATETIME (UTC)	No
	Last update date and time in UTC for Sex Parameter for Clinical Use, the sex categorization that aligns most with the patient in the context of the current order.