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