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
16 | ENTRY_START_LOCAL_DTTM | DATETIME (Local) | No |
This table contains the date and time when the user initiates a new session to create orders. This is currently populated only for orders placed from Ancillary Orders and is used to report transcription time for imaging orders that are manually transcribed from scanned documents.
17 | RFL_START_DATE | DATETIME | No |
The start date of the referral. Can be set in the Service Period display item in order entry and is used to set the service start dates for the referral and authorizations associated with the order.
18 | CARE_ORD_SCOPE_C_NAME | NUMERIC | No |
The scope of care for a specific service. The selectable values are unique to the service.
May contain organization-specific values: Yes
Category Entries:
Other
19 | CARE_PROB_TEMPLATE_PROBLEM_ID | NUMERIC | No |
The potential barriers for completing a specific service. The selectable values are unique to the service.
20 | CARE_PROB_TEMPLATE_PROBLEM_ID_TEMPLATE_PROB_NAME | VARCHAR | No |
This column displays the template problem name.
21 | RECOMMENDED_UNITS_PER_PERIOD | INTEGER | No |
The number of recommended units per period for a referral procedure order.
22 | REFERRAL_CHANGE_TYPE_C_NAME | NUMERIC | No |
Tracks the type of referral order being requested based on how the requested units compare to the recommended units.
May contain organization-specific values: No
Category Entries:
Recommendation (No Change)
Reduction
Addition
23 | REFERRAL_CHANGE_REASON_C_NAME | NUMERIC | No |
The reason a unit amount different than the recommended units was requested.
May contain organization-specific values: Yes
No Entries Defined
24 | REFERRAL_CHANGE_COMMENT | VARCHAR | No |
Additional comments to explain why the requested units differ from the recommended units.
25 | PROV_DETERMINES_SVC_SCHED_YN | VARCHAR | No |
Stores a flag indicating that the provider determines the schedule for the units of a service instead of the care manager recommending a specific schedule.
The category values for this column were already listed for column: TODAYS_FOCUS_YN