ORDER_PROC_6

Description: |
The ORDER_PROC_6 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 sixth table to prevent ORDER_PROC_5 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 for the order record.
2 | FIRST_CHART_USER_ID | VARCHAR | No |
The unique ID of the user who first made results available on the chart.
3 | FIRST_CHART_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
4 | FIRST_CHART_UTC_DTTM | DATETIME (UTC) | No |
The date and time results were first made available on the chart.
5 | LAST_CHART_USER_ID | VARCHAR | No |
The unique ID of the user who last made results available on the chart.
6 | LAST_CHART_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | LAST_CHART_UTC_DTTM | DATETIME (UTC) | No |
The date and time results were last made available on the chart.
8 | FIRST_FINAL_USER_ID | VARCHAR | No |
The unique ID of the user who first made final results available on the chart.
9 | FIRST_FINAL_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | FIRST_FINAL_UTC_DTTM | DATETIME (UTC) | No |
The date and time final results were first made available on the chart.
11 | LAST_FINAL_USER_ID | VARCHAR | No |
The unique ID of the user who last made final results available on the chart.
12 | LAST_FINAL_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
13 | LAST_FINAL_UTC_DTTM | DATETIME (UTC) | No |
The date and time final results were last made available on the chart.
14 | FIRST_CORR_USER_ID | VARCHAR | No |
The unique ID of the user who first authorized a correction to the result on this order.
15 | FIRST_CORR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
16 | FIRST_CORR_UTC_DTTM | DATETIME (UTC) | No |
The date and time the results of this order were first corrected.
17 | LAST_CORR_USER_ID | VARCHAR | No |
The unique ID of the user who last authorized a correction to the results of this order.
18 | LAST_CORR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
19 | LAST_CORR_UTC_DTTM | DATETIME (UTC) | No |
The date and time the results of this order were last corrected.
20 | IMG_EXAM_PAT_WT | NUMERIC | No |
Most recent patient weight (grams) preceding the end exam instant, within the system's age-based weight lookback range. Exams missing an end exam instant, as well as exams taking place too long after the last recorded patient weight, will not populate this item.
21 | IMG_EXAM_PAT_HT | NUMERIC | No |
Most recent patient height (centimeters) preceding the end exam instant, within the system's age-based height lookback range. Exams missing an end exam instant, as well as exams taking place too long after the last recorded patient height, will not populate this item.
22 | IMG_EXAM_PAT_BMI | NUMERIC | No |
Most recent patient BMI preceding the end exam instant, within the system's age-based height and weight lookback ranges. Exams missing an end exam instant, as well as exams taking place too long after the last recorded patient height or weight, will not populate this item.
23 | FOLLICLE_STDY_MIN_THRSHLD_NUM | INTEGER | No |
The minimum threshold from I LSD 53002 at the time of the study. This value is stored in millimeters.
24 | UNIQUE_IDENT | VARCHAR | No |
The unique ID generated by the organization that originally created this order.
25 | ACCT_SERIAL_NUM | INTEGER | No |
The account serial number associated with the order.
26 | RSLT_TRANSMTL_DTTM | DATETIME (Local) | No |
The date and time the order was placed on the result transmittal queue.
27 | RSLT_TRANSMTL_ENTRY_IDENT | VARCHAR | No |
The unique ID used for the result transmittal queue entry associated with the order.
28 | ADD_ON_SPECIMEN_ID | VARCHAR | No |
The unique ID of the specimen that the order was added onto.
29 | NO_PAT_CLASS_REASON_C_NAME | VARCHAR | No |
This holds a reason that the patient class was stripped from the order. If this value is blank, it can mean either that the procedure didn't have a patient class or that the reason the patient class was stripped isn't a reason that's audited.
May contain organization-specific values: No
Category Entries:
The patient's hospital account did not allow the new patient class.
Could not find an ADT event to check the new patient class against.
The accommodation code, accommodation reason, service, or level of care were not allowed in this patient's location.
Morrisey Concurrent Care Manager accounts do not allow the new patient class.
Home Health accounts do not allow the new patient class.
Hospice accounts do not allow the new patient class.
The filter LPPs in EAF 62550 do not allow the new patient class.
Either the new patient class was not mapped in HB or the patient's HAR did not allow it.
The patient's facility did not allow the new patient class.
The new patient class was the same as the patient's current patient class.
The ordering user did not have appropriate security for the patient class change.
The facility did not allow changing from the patient's current patient class to the new patient class.
The patient had an update effective after this order's effective instant and the facility did not allow changing from the order's patient class to the patient class effective later.
30 | PRIORITIZED_INST_DTTM | DATETIME (Local) | No |
This item stores the prioritized instant (date and time) for an order in local time zone. It represents the most relevant date and time an action was taken on an order.
31 | INTENDED_SMOKE_QUIT_DATE | DATETIME | No |
The date a patient plans to quit smoking. This value is populated by filing an order-specific question.
32 | PRIORITIZED_INST_UTC_DTTM | DATETIME (UTC) | No |
This item stores the prioritized instant (date and time) for an order in UTC time zone. It represents the most relevant date and time an action was taken on an order.
33 | RSLT_UPD_UTC_DTTM | DATETIME (UTC) | No |
Stores the last update instant for a result in UTC
34 | RECEIVED_EXT_AUTH_PROV | VARCHAR | No |
This item holds the free-text for the received authorizing provider's name. It is free text and not linked to a provider record because we do not want to generate provider records for all received external result orders.
35 | DICOM_LAST_UPD_DTTM | DATETIME (UTC) | No |
The instant of the last time the UIDs were updated.
36 | STUDY_LAST_OPENED_DTTM | DATETIME (Local) | No |
The column contains the time the study was last opened in edit mode.
37 | PATH_NARRATIVE_NOTE_ID | VARCHAR | No |
This column contains the pathology result narrative ID and only supports historical data.
38 | IMG_CHGEAP_LOADED_YN | VARCHAR | No |
Indicates whether default chargeable Associated Procedures have been added to the Imaging Charge Capture Navigator. 'Y' indicates that default chargeable Associated Procedures have been added, 'N' or NULL indicate they have not.
May contain organization-specific values: No
Category Entries:
No
Yes
39 | DEF_BNDL_CODE_YN | VARCHAR | No |
Indicates historical data about whether the default bundle codes are used for charges. 'Y' indicates that default bundle codes were used for charges, 'N' or NULL indicate that default bundle codes were not used.
May contain organization-specific values: No
Category Entries:
Yes
No
40 | REF_PRV_ROUT_MTHD_C_NAME | VARCHAR | No |
The 'Encounter Communication Sent - Method' category ID for the routing method that will be used for automated results routing. The method is determined when placing an order in Ancillary Order Entry.
May contain organization-specific values: Yes
Category Entries:
In Basket
Fax
Mail
Phone Call
MyChart
Network Printer
Courier Service
Outside Provider Messaging
Print Locally
EDI
Opt Out
E-mail
FHIR
Save to File
Electronic Authorization Message
Suppress Result Routing
Payer Platform Notification
Internal Payer Notification
41 | BATCH_PRINTED_UTC_DTTM | DATETIME (UTC) | No |
This column holds the instant the results report was printed through batch printing routine RISBSREP or through results routing.
42 | STUDY_READ_DATE | DATETIME | No |
Stores the last time an imaging order had a status change of "SAVED" or higher.
43 | IMG_ADDEND_IN_EPIC_DATE | DATETIME | No |
This column stores when the addendum is updated in Epic (addendum sign date if using an Epic workflow, otherwise whenever received over the interface)
44 | IMG_LAST_UPDATE_IN_EPIC_DATE | DATETIME | No |
This column stores when the result is updated in Epic (sign date if using an Epic workflow, otherwise whenever received over the interface)
45 | REI_FOLLICLE_ROUNDING_C_NAME | VARCHAR | No |
The measurement rounding method for ovarian follicle averages. This indicates whether follicle measurement averages are rounded to the nearest whole-millimeter or half-millimeter. This is only set for studies that contain ovarian follicle measurements. Also only used for averages, not follicle diameters which always round to the nearest tenth.
May contain organization-specific values: No
Category Entries:
Whole Millimeter
Half Millimeter
46 | MYC_BATCH_RELEASE_DTTM | DATETIME (Local) | No |
Server time instant after which a result will be released to MyChart by the batch job
47 | ORDER_DOMAIN_C_NAME | VARCHAR | No |
Used to semantically group types of procedure orders.
May contain organization-specific values: Yes
48 | PERFORM_BY_DATE | DATETIME | No |
Unbuffered perform-by date used in automatic order cancellation batch job.
49 | SEQ_DOC_LAST_UPD_UTC_DTTM | DATETIME (UTC) | No |
The instant when the linked sequencing documents were last updated, represented in UTC.
50 | SEQ_DOC_LAST_UPD_DTTM | DATETIME (Local) | No |
The instant when the linked sequencing documents were last updated, represented in the local time of the system that made the change.
51 | DISCON_LOC_DTTM | DATETIME (Local) | No |
The instant the order was discontinued or canceled in the local timezone.
52 | FIRST_FINAL_LOC_DTTM | DATETIME (Local) | No |
The instant final results were first made available on the chart. This is the result contact instant (ORD-1970) from the first contact where the procedure result status (ORD-115) is 3-Final result.
53 | SND_ORG_PAT_MRN | VARCHAR | No |
This item stores the patient's MRN ID from the organization that sent this order.
54 | REFD_TO_PROV_CARE_TEAM_ID | NUMERIC | No |
This item tracks the IP provider team associated with a consult/referral order.
55 | REFD_TO_PROV_CARE_TEAM_ID_RECORD_NAME | VARCHAR | No |
The name of the record.
56 | ORD_GRP_RULE_ID | VARCHAR | No |
The unique identifier (.1 item) for the rule that identifies this order group
57 | ORD_GRP_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.
58 | ORD_GRP_SESS_UTC_DTTM | DATETIME (UTC) | No |
The date and time that identifies this order group, in UTC.
59 | RFL_PRIM_CONDITION_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
60 | RFL_PRIM_TREATMENT_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
61 | RFL_PRIM_SPECIALTY_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
62 | RFL_PRIM_SUBSPEC_GROUPER_ID_GROUPER_NAME | VARCHAR | No |
Record name
63 | INFUSION_DURATION_AT_SCHED | INTEGER | No |
This item stores the calculated infusion duration in minutes for infusion visit orders at the time of scheduling.
64 | SELF_REFERRED_YN | VARCHAR | No |
Indicates whether an order is self-referred. 'Y' indicates that an order is self-referred. 'N' indicates that an order was manually marked as not self-referred. NULL indicates that an order was not automatically marked as self-referred and not manually marked as being either self-referred or not self-referred.
The category values for this column were already listed for column: IMG_CHGEAP_LOADED_YN
65 | UPD_ASMT_RECOM_TIME | INTEGER | No |
Stores the total number of seconds spent by clinicians updating discrete data in the Update Assessment/Recommendations activity.
66 | NO_RFL_PROV_TEAM_YN | VARCHAR | No |
This item stores whether the "No Group" checkbox to allow placing a referral without an associated provider team has been checked.
The category values for this column were already listed for column: IMG_CHGEAP_LOADED_YN
67 | RIS_RSLT_RPT_PRNT_DATE | DATETIME | No |
The date that a result report for a self-referred order should print.
68 | NLP_AFM_LINK_OUTCOME_C_NAME | VARCHAR | No |
The outcome of links between AFM findings and AFM recommendations created using NLP. This is only calculated when both the AFM Findings Model and the AFM Recommendations Model reach a verified status and is blank otherwise. This can be used to measure the accuracy of NLP links.
May contain organization-specific values: No
Category Entries:
True Positive
Positive With Modification
False Positive
True Negative
False Negative
Error
69 | ORD_OR_GEN_SUBMITTER_ID | NUMERIC | No |
The unique ID of the external site (submitter) associated with the order. The submitter will typically be copied on results, and could also be billed (depending on configuration). This will include a generic submitter that is placed on orders that were placed at your organization and collected at an EpicCare Link site.
70 | ORD_OR_GEN_SUBMITTER_ID_RECORD_NAME | VARCHAR | No |
The name of the submitter record.
71 | MYC_CUSTOM_FILTERED_YN | VARCHAR | No |
This item determines if the result should be filtered from results release metrics based on a custom rule. 'Y' indicates that it should be filtered, whereas 'N' and NULL indicate that the row does not need to be filtered.
The category values for this column were already listed for column: IMG_CHGEAP_LOADED_YN
72 | PRODUCT_RECEIVED_YN_NAME | VARCHAR | No |
Indicates whether or not the requested product has been received.
The category values for this column were already listed for column: IMG_CHGEAP_LOADED_YN
73 | RIS_SELF_REF_RSN_C_NAME | VARCHAR | No |
The reason why the self-referred item is set to its current value.
May contain organization-specific values: No
Category Entries:
N/A - Cleared
Visit type
Authorizing provider
Procedure
Rule
Question
74 | RIS_SELF_REF_RSN_IDENT | VARCHAR | No |
The ID of the record that caused the self-referred item to be populated.
75 | DENTAL_ASSOCIATED_TEETH | VARCHAR | No |
Represents the associated teeth on an order.
76 | DENTAL_REFERRAL_STATUS_C_NAME | VARCHAR | No |
The Dental Referral Status category ID for the order record.
May contain organization-specific values: No
Category Entries:
Referred
Completed
Removed
77 | OP_PRN_STATUS_YN | VARCHAR | No |
PRN status of a procedure order (OP order mode only).
The category values for this column were already listed for column: IMG_CHGEAP_LOADED_YN
78 | OP_PRN_STATUS_CMT | VARCHAR | No |
Comments about PRN status of a procedure order (OP order mode only).
79 | OP_FU_WITH_C_NAME | VARCHAR | No |
Who or what entity is responsible for a follow-up.
May contain organization-specific values: Yes
Category Entries:
Me
Me or My Team
Encounter Provider
Encounter Provider or Their Team
PCP
Specific Provider
Subspecialty
My Team
80 | OP_FU_VISIT_MODE_C_NAME | VARCHAR | No |
Visit mode of a follow-up order.
May contain organization-specific values: No
Category Entries:
No Preference
In-Person
Video
Telephone
Clinic-to-Clinic Video
81 | OUTPAT_FLEX_TYPE_C_NAME | VARCHAR | No |
The procedure flexibility type with category values of "Now," "Anytime," "Date range," and "Target date."
May contain organization-specific values: No
Category Entries:
Now
Anytime
Date range
Target date
82 | OUTPAT_LATEST_DATE | DATETIME | No |
Stores the latest date that a procedure should be scheduled at.
83 | OUTPAT_LATEST_DATE_COMMENT_C_NAME | VARCHAR | No |
The category values used for the Once procedure latest date (ORD 664).
May contain organization-specific values: Yes
Category Entries:
On Date
Other (specify)
Today
Tomorrow
1 Week
2 Weeks
3 Weeks
4 Weeks
5 Weeks
6 Weeks
1 Month
2 Months
3 Months
4 Months
5 Months
6 Months
7 Months
8 Months
9 Months
10 Months
11 Months
12 Months
13 Months
14 Months
15 Months
16 Months
17 Months
18 Months
1 Year
2 Years
3 Years
4 Years
Before Surgery
Before Surgery
Before Next Appt
84 | OP_FU_PCP_TYPE_C_NAME | VARCHAR | No |
The type of PCP to follow up with if a PCP of a patient is responsible for a follow-up.
May contain organization-specific values: Yes
Category Entries:
General
85 | ORDER_START_TM | DATETIME (Local) | No |
The time when the procedure order is to start.
86 | IMG_IS_ORD_LD_BALANCED_YN | VARCHAR | No |
Whether or not the order was ever run through the Radiant Load Balancer.
The category values for this column were already listed for column: IMG_CHGEAP_LOADED_YN
87 | PRODUCT_COST_NUM | NUMERIC | No |
The cost of the requested product.
88 | AUTO_ORD_REC_STATUS_C_NAME | VARCHAR | No |
The category ID indicating whether this order was created via automatic order reconciliation and whether it needs review, has been reviewed, or has otherwise been acted on.
May contain organization-specific values: No
Category Entries:
Automatically continued
Automatically continued, no review needed
Reviewed
Modified
Discontinued
Held