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.
5 TODAYS_FOCUS_YN VARCHAR No
This items tracks whether the order is today's focus, indicating that a provider is waiting on the order to advance the patient to their next step of care. This item can be set through Patient Availability print group.
May contain organization-specific values: No
Category Entries:
No
Yes
6 TODAYS_FOCUS_UTC_DTTM DATETIME (UTC) No
Instant that a user marked the order as today's focus, indicating that a provider is waiting on the order to advance the patient to the next step of care. This instant is stored in UTC.
7 TODAYS_FOCUS_USER_ID VARCHAR No
User who marked the order as today's focus, indicating that a provider is waiting on the order to advance the patient to the next step of care.
8 TODAYS_FOCUS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 HISTORICAL_ORDER_YN VARCHAR No
Whether the order class or procedure was marked as historical at signing.
The category values for this column were already listed for column: TODAYS_FOCUS_YN
10 RAD_THERAPY_GOAL_C_NAME VARCHAR No
This item stores the goal for prescribed radiation therapy treatment.
May contain organization-specific values: Yes
Category Entries:
Control
Curative
Maintenance
Palliative
Supportive
Diagnostic
Prophylactic
Preventative
Benign
Guidance
Consolidative
Screening
Definitive
Forensic
11 RT_EPISODE_OPTION_C_NAME VARCHAR No
Indicates if the procedure should generate a new radiation therapy episode, update an existing episode, or have no interaction with an episode.
May contain organization-specific values: No
Category Entries:
None
New
Existing
12 ASSOCIATED_RAD_THP_EPISODE_ID NUMERIC No
The existing radiation therapy episode this order should be associated with. The radiation therapy details documented in the order will be added to the episode.