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