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 | 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
3 | 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
4 | 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.
5 | 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
6 | 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.
7 | 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.
8 | 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
9 | 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.
10 | 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.
11 | TODAYS_FOCUS_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | 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
13 | LAST_MAMMO_WT_SRC_C_NAME | VARCHAR | No |
Indicates the source of the last mammo weight value.
May contain organization-specific values: No
Category Entries:
Patient Manually Reported
Device Reported
14 | EXAM_MAMMO_WT_SRC_C_NAME | VARCHAR | No |
Indicates the source of this exam's mammo weight value.
The category values for this column were already listed for column: LAST_MAMMO_WT_SRC_C_NAME
15 | PROC_CODE_DESC | VARCHAR | No |
The Procedure Code Description - Stores Additional Information about the Procedure