ORD_ROUTING_INFO

Description:

This table contains the PLF (patient location facility) record and/or department type used to get the routing information for the order record. It will only contain rows that have at least one value in either the ROUTING_DEPT_PLF_ID column or the ROUTING_DEPT_TYPE_C column.

Primary Key

Column Name	Ordinal Position
ORDER_ID	1

Column Information

	Name	Type	Discontinued?
1	ORDER_ID	NUMERIC	No
	The unique identifier for the order record.
2	ROUTING_DEPT_PLF_ID_RECORD_NAME	VARCHAR	No
	The name of the PLF record.
3	ROUTING_DEPT_TYPE_C_NAME	VARCHAR	No
	The phase of care category ID for an order record, used as a routing department to route the order when a specific department is known. May contain organization-specific values: Yes