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
Outside Authorization Message
Suppress Result Routing
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
No Entries Defined
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 NUMERIC No
Primary condition for which the patient is being referred as a Search Condition MAG record.
60 RFL_PRIM_TREATMENT_GROUPER_ID NUMERIC No
Primary treatment for which the patient is being referred as a Search Treatment MAG record.
61 RFL_PRIM_SPECIALTY_GROUPER_ID NUMERIC No
Primary specialty to which the patient is being referred as a Search Specialty MAG record.
62 RFL_PRIM_SUBSPEC_GROUPER_ID NUMERIC No
Primary subspecialty to which the patient is being referred as a Search Subspecialty MAG record.
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 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
73 RIS_SELF_REF_RSN_IDENT VARCHAR No
The ID of the record that caused the self-referred item to be populated.