ORDER_PROC_2

Description: |
The ORDER_PROC_2 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 second table to prevent ORDER_PROC from getting any larger.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_PROC_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_PROC_ID | NUMERIC | No |
The unique ID of the procedure order record.
2 | PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
3 | MOD_BEGIN_TM | DATETIME (Local) | No |
For procedures performed on modalities using Digital Imaging and Communications in Medicine (DICOM), this stores the start date & time of the performed procedure sent from the modality to system.
4 | MOD_END_TM | DATETIME (Local) | No |
For procedures performed on modalities using Digital Imaging and Communications in Medicine (DICOM), this stores the end date & time of the performed procedure sent from the modality to system.
5 | OVERRIDE_TM | DATETIME (Local) | No |
Stores the most recent time a hard stop was overridden at begin or end exam in radiology
6 | RVSN_RSN_C_NAME | VARCHAR | No |
The revision reason category number for the order. This depicts the reason that a radiology transcriptionist marked a study as needing revision.
May contain organization-specific values: Yes
7 | CHANGE_REASON_C_NAME | VARCHAR | No |
The change status reason category ID for the order, which indicates the reason given for reverting an order to a previous radiology status.
May contain organization-specific values: Yes
Category Entries:
Other
Error
8 | CHANGE_CMT | VARCHAR | No |
Stores the comment given for reverting an order to a previous radiology status.
9 | STUDY_INSTANCE | VARCHAR | No |
This column stores the unique identifier for an instance of a DICOM imaging study.
10 | CHARGE_TM | DATETIME (Local) | No |
The date and time a charge was generated by ending a radiology exam.
11 | GRP_ORDER_PROC_ID | NUMERIC | No |
The unique identifier of the master procedure record used for grouped imaging orders.
12 | ORDER_PRIORITY_C_NAME | VARCHAR | No |
Stores the radiology result priority.
May contain organization-specific values: Yes
13 | BALANCE_ADJ_YN | VARCHAR | No |
Stores whether the balance for supplies/drugs is already adjusted.
May contain organization-specific values: No
Category Entries:
Yes
No
14 | IMAGE_LOCATION_C_NAME | VARCHAR | No |
Stores the category ID of the PACS (picture archiving and communication) system has the images for a radiology order.
May contain organization-specific values: Yes
15 | IMAGES_AVAIL_YN | VARCHAR | No |
Stores whether images are available via PACS (picture archiving and communication system) for a radiology order. 'Y' indicates that the images are available, 'N' and NULL indicate that the images are not available.
May contain organization-specific values: No
Category Entries:
No
Yes
16 | PAT_LOC_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
17 | ACT_ORDER_C_NAME | VARCHAR | No |
The active order category ID, which indicates information about the order status.
May contain organization-specific values: No
Category Entries:
Active Medication
Active Procedure
Discontinued Medication
Canceled Procedure
Completed Medication
Completed Procedure
18 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
19 | LET_EOD_PRNT_DATE | DATETIME | No |
The date a letter will be created and printed for this order. This is cleared after the letter has been created and printed.
20 | ORDER_SOURCE_C_NAME | VARCHAR | No |
The order source category ID of the order, indicating where in the EHR the order was entered.
May contain organization-specific values: No
Category Entries:
Admission Navigator
Transfer Navigator
Discharge Navigator
Clinician Orders
Order Entry
OrderSet
CUSTOM
Web
Order Review Reorder
Rx Orders
Medication Reorder
Rounding Navigator
Ancillary Orders
OutReach
Pre-Transfer Navigator
Departure Navigator
Arrival Navigator
Treatment Plan Pre-Verify
Results Console
Case/Log Study Auto-generation
Created by Referral
Lab Requisition Entry
Order Review Resulting Agency Modify
Ultrasounds
Specialty Back Office Navigator
Link Health Maintenance
OP Follow-up
Ord Rec Admission Review PTA
Ord Rec Admission Reorder PTA
Ord Rec Admission New Orders
Ord Rec PreTransfer Review Current
Ord Rec PreTransfer Details
Ord Rec PreTransfer Restart
Ord Rec PreTransfer Reorder
Ord Rec PreTransfer New Orders
Ord Rec Arrival Release
Ord Rec Arrival New Orders
Ord Rec Discharge Review Orders
Ord Rec Discharge New Orders
Anesthesia Intra-op
NoteWriter
Invasive Labs Narrator
Medication List
Non-Procedural Narrator One-step Med
Problem List
SmartSet
Ord Rec Interfacility-Transfer Review
Ord Rec Interfacility-Transfer New Orders
Releaser
Anticoagulation tracking section entry
ED Discharge
Ord Rec Admission Restart Previous
Ord Rec Interfacility-Transfer Reorder PTA
Modify from Medications Activity
Modify from Order Review
Modify from Rounding Navigator
Modify from Report
Modify from Rx Sidebar
Modify from Treatment Plan
Modify from Manage Orders
ED Single Screen Disposition
Historical Cervical Cytology
Modify from SxS Admission
HH Remote Client Lab Result
Unlinked Procedure Note Auto-Generation
Rx Refill Request
Anesthesia Ord Rec
Anesthesia Ord Rec New Orders
External Order
OP Visit Taskbar
Surgery Navigator
Surgery Processed
Verify Orders
Surgery Intra-op Navigator
Specimen Collection
Surgery Pick List
Haiku
Haiku for Android
Canto
Canto SmartSet
Rover
Mobile Mass Immunization
Rover for Android
Mobile POCT Duplicate
Mobile POCT On-The-Fly
On-the-fly
Manage Orders
Ord Rec Admission in Manage Orders
OP Orders in Managed Orders
Bulk Orders
Orthopaedic Injection
Interface
Donor Organ Editor
Central Medication Database
ProcDoc Injection
FMK Side by Side
Anticoag Navigator Reorder and Sync
Imm On-the-fly Order
Imaging Protocol Work List
Imaging Meds Admin Navigator Section
Appointment Entry
Appointment Check In
Cadence Decision Tree
RxFill Dispense Review
Automatically Reconciled Lab Result
External Medication Order
Automatically Reconciled MyChart Titer
Automatically Reconciled Imaging Result
Medication Automatic Conversion Utility
Reconcile Outside Information
Ord Rec Admission Review PTA External
Dermatology Exam
Campaigns Orders
MyChart Self-Triage
Social Care Application
HH/HSPC Remote Client Medication
HH/HSPC Remote Client Med Admin
HH/HSPC In Basket Med Reconciliation
BCA Web
Health Maintenance Single Care Gap Closure
Rapid Transfuse
Converted from Case
Dental
Dental Visit
Orders and Results Anywhere Network Interface
Instant Order OPA
Automatically Reordered on Discharge-Readmit
Quick Orders
TDR Printing Workflow Simulation
Imaging and Procedures - One Step Medications
Imaging and Procedures - Performed
Facility Administered Medications
Create CAM
Lab Downtime Specimen Linking
Lab Specimen Update
Haiku iOS Voice Assistant
Ambient
Reorder from Chart Review
Recall
21 | SPECIMN_TAKEN_DATE | DATETIME | No |
The date the specimen was taken.
22 | SPECIMN_TAKEN_TIME | DATETIME (Local) | No |
The time the specimen was taken.
23 | LET_EXPIRE_USER_ID | VARCHAR | No |
The ID of the user who marked order as Let Expire.
24 | LET_EXPIRE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
25 | TIME_LET_EXPIRE | DATETIME (Local) | No |
The time when the physician marked the order as Let Expire.
26 | EXP_AFT_START_TIME | DATETIME (Local) | No |
The date and time an order will be marked as needing review by a physician, based on a defined period of time after the order starts.
27 | EXP_BEF_END_TIME | DATETIME (Local) | No |
The date and time an order will be labeled as expiring, based on a defined period of time before the order's end time.
28 | ORD_COPIED_C_NAME | VARCHAR | No |
The order copy status category ID, indicating whether the order was copied to another visit.
May contain organization-specific values: No
Category Entries:
Not Copied
Copied to Other Encounter
Do not allow Copy
29 | REV_ORD_GRANU_YN | VARCHAR | No |
Determines if an order is reviewed by day or by instant.
May contain organization-specific values: Yes
Category Entries:
By Instant
By Day
30 | EXP_DAYS_YN | VARCHAR | No |
Indicates whether the amount of time determining when an order will expire is in measured in days or instants. '0' indicates that the expiration time is in a number of hours. '1' indicates the expiration time is in a number of days or weeks.
The category values for this column were already listed for column: REV_ORD_GRANU_YN
31 | CHRG_METHOD_ID | VARCHAR | No |
The unique identifier of the charge trigger method associated with the order.
32 | CHRG_METHOD_ID_CHRG_METHOD_NAME | VARCHAR | No |
The name of the charge trigger method.
33 | SPECIMEN_COMMENTS | VARCHAR | No |
This free text item is used to store comments about the specimen source.
34 | SPECIMEN_RECV_DATE | DATETIME | No |
This item stores the date that the specimen was received. It is in the same logical group as the SPECIMEN_RECV_TIME column.
35 | SPECIMEN_RECV_TIME | DATETIME | No |
This item stores the time the specimen was received. It is in the same logical group as the SPECIMEN_RECV_DATE column.
36 | COLLECTOR_IDN | VARCHAR | No |
The name of the user who collected the specimen for the order.
37 | COLLECTOR_USER_ID | VARCHAR | No |
The unique identifier of the user who collected the specimen for the order.
38 | COLLECTOR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
39 | FUTURE_APPROX_DT_YN | VARCHAR | No |
Indicates whether there is an approximate future expected date for this order. 'Y' indicates there is an approximate future expected date. 'N' or NULL indicates that there is not an approximate future expected date.
May contain organization-specific values: No
Category Entries:
Yes
No
40 | LAST_STAND_PERF_DT | DATETIME | No |
The date on which a standing order was last performed.
41 | LAST_STAND_PERF_TM | DATETIME (Local) | No |
The time at which a standing order was last performed.
42 | PERFORMING_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
43 | ORIGINAL_ORD_ID | NUMERIC | No |
When an order record is created as the result of a procedure change workflow, it stores a pointer to the previous order. To reliably find the original order record, refer to ORDER_PROC_5.ORIGINATING_ORD_ID
44 | EXTERNAL_ORD_ID | VARCHAR | No |
Stores the external order ID for the order.
45 | REMARKS_HNO_ID | VARCHAR | No |
Stores the link to the general notes record containing the result remarks. It is networked to General Use Notes record.
46 | SER_ADDRESSID | VARCHAR | No |
Stores the referring provider address ID for referral orders. The format is provider external ID - Address line number. For example, if provider external ID = 123 and Address line = 4, the value would be 123-4. If the referring provider has no address, this will store the provider external ID only. Other columns in the same logical group are: REFG_FACILITY_ID (ORD 3010), REFD_TO_PROV_ID(ORD 3100) and REFERRAL_ID (ORD 3300)
47 | REFG_FACILITY_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
48 | REFD_TO_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
49 | REFERRAL_ID | NUMERIC | No |
Stores the associated referral ID for referral orders. Other columns in the same logical group are: SER_ADDRESSID (ORD 3001), REFG_FACILITY_ID (ORD 3010) and REFD_TO_PROV_ID(ORD 3100)
50 | LAST_RESULT_UPD_TM | DATETIME (Local) | No |
The date and time of the last result date. This item is set based on a time stamp received in the interface. It is also set when results are manually entered or when an order is cancelled.
51 | COLLECTION_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
52 | USER_ID_OF_PROV | VARCHAR | No |
The unique identifier for the authorizing provider of the order record.
53 | LOGIN_DEP_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
54 | PERFS_FILED_INST | DATETIME (Local) | No |
The date and time the order was performed.
55 | CHGS_FILED_INST | DATETIME (Local) | No |
The date and time that charges were filed.
56 | NOCHG_REASON_C_NAME | VARCHAR | No |
Contains the reason that no charges were linked to the order.
May contain organization-specific values: Yes
No Entries Defined
57 | ORD_PRV_ROUT_MTHD_C_NAME | VARCHAR | No |
This item stores the routing method for the ordering provider
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
58 | ORD_PRV_ROUT_ADDR | VARCHAR | No |
The address of the ordering provider which will be used to receive the results of this order.
59 | RIS_SIGN_AGAIN_R_YN | VARCHAR | No |
Indicates whether multi-discipline studies will be sent back to previous signers for review if the result text has been changed for this order. Yes indicates that studies will be sent back. No or Null will indicate that studies will not be sent back. The data is automatically populated when an imaging study reaches Exam Ended or Exam Begun from the value in field "Sign Again if Result Text Changed" in the Radiology/Cardiology Options 3 screen of the linked procedure. If that is null then we look at the same field in the procedure category or the Study review node of the Imaging System Definitions. Users can change the original value by changing the same field in the advanced mode of the Assign Activity.
The category values for this column were already listed for column: IMAGES_AVAIL_YN
60 | ABN_WAIVER_SIGN_YN | VARCHAR | No |
Indicates whether an Advanced Beneficiary Notice waiver form was signed by the patient in the event that the service to be performed was denied by Medicare.
The category values for this column were already listed for column: BALANCE_ADJ_YN
61 | CHECK_OUT_COMMENT | VARCHAR | No |
The check-out comments entered on the order.
62 | RQG_ID | NUMERIC | No |
The unique ID of patient and coverage information for non-participatory lab referrals attached to this order. If this is filled in, then PAT_ID and related columns in the ORDER_PROC table will not be filled in for this order. This column is frequently used to link to the RQG_DB_MAIN table.
63 | SITE_OF_COLLECT_C_NAME | VARCHAR | No |
The site of collection category number for the location on patient in which the specimen was drawn.
May contain organization-specific values: Yes
64 | LAB_CANCEL_REQ_ID | VARCHAR | No |
The unique ID of the user who requested to cancel the order.
65 | LAB_CANCEL_REQ_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
66 | PROTCL_STAT_DT | DATETIME | No |
The date an unscheduled order was placed, or the appointment date for a scheduled order which requires a protocol.
67 | PROTCL_STATE_C_NAME | VARCHAR | No |
The scheduling status for an order which requires a protocol. This column links to the ZC_PROTCL_STATE table.
May contain organization-specific values: Yes
Category Entries:
Unscheduled
Scheduled
68 | LAB_CHG_TRG_YN | VARCHAR | No |
Indicates whether a charge was triggered in lab.
The category values for this column were already listed for column: IMAGES_AVAIL_YN
69 | LAB_ACCOUNT_ID | NUMERIC | No |
The unique ID of the order level account record override associated with this order.
70 | LAB_COVERAGE_ID | NUMERIC | No |
The unique ID of the order level coverage record associated with this order.
71 | LAB_DONT_BIL_INS_YN | VARCHAR | No |
Indicates whether insurance should be billed for this order. 'Y' indicates that insurance should not be billed. 'N' or NULL indicates that insurance should be billed.
The category values for this column were already listed for column: IMAGES_AVAIL_YN
72 | USER_CONTEXT_C_NAME | VARCHAR | No |
Assigns an order a category ID with a user's context. The order can be used for or created for procedure orders.
May contain organization-specific values: Yes
73 | EFQ_OVRD_DAY_TYPE | NUMERIC | No |
The items indicate the override values for cycle length and day type (relative vs weekdays). Specifies what the numeric values in the frequency override days columns represent. If it is 1 then the listed days are relative days. If it is 2 then the listed days are weekdays. Any other value has no meaning.
74 | EFQ_OVRD_CYCL_LEN | NUMERIC | No |
If there is a frequency override specified, this item will contain the length of the relative specified frequency cycle (e.g. hours, days)
75 | CHART_CORRECTION_ID | NUMERIC | No |
The unique identifier of the chart correction audit record for the order.
76 | PARENT_CE_ORDER_ID | NUMERIC | No |
When a cross-encounter order is released, this item stores the ID of the parent order.
77 | CONDITIONAL_C_NAME | VARCHAR | No |
The inpatient conditional order category ID for the order, indicating whether this order should be conditionally initiated.
May contain organization-specific values: No
Category Entries:
No
Yes
Yes - Initiated
Force No Condition
78 | COND_STATUS_C_NAME | VARCHAR | No |
The inpatient conditional status category ID for the order, indicating whether the conditions for the order to be initiated have been satisfied yet.
May contain organization-specific values: No
Category Entries:
Conditions not met
All conditions met
79 | INTERFACE_YN | VARCHAR | No |
Indicates whether this order was resulted through an interface or not. Y indicates that the result came through an interface, N indicates it was not resulted through an interface but rather some other result mechanism or not resulted at all.
May contain organization-specific values: No
Category Entries:
Yes
No
80 | CASE_PANEL_NUM | INTEGER | No |
The surgical panel that this order is associated with.
81 | IS_SAVED_ORDER_YN | VARCHAR | No |
Indicates whether an order has a status of saved. A "Yes" value indicates that the order is in a status of saved. A null value indicates that the order is not in a status of saved. A "No" value will not be populated for this column.
The category values for this column were already listed for column: IMAGES_AVAIL_YN
82 | OVRD_TASK_TEMP_ID | VARCHAR | No |
Contains the override task template ID for overriddem anchored orders, orders attached to a time (for example, a pregnant woman's delivery date).
83 | OVRD_TASK_TEMP_ID_RECORD_NAME | VARCHAR | No |
This column displays the name of the task template record.
84 | SOURCE_OF_PRI_INS_C_NAME | VARCHAR | No |
The source of prioritized date category ID for the order record. Prioritized date is determined by the following hierarchy: collection date and time, result date and time, release date and time (for future and standing orders), order date and time, and encounter date.
May contain organization-specific values: No
Category Entries:
Encounter Date
Ordering Date
Instant of Instantiation
Result Date
Specimen Collected Date
Refill Hx Date
Exam End Date
85 | PRIORITIZED_INST_TM | DATETIME (Local) | No |
The time and date that is used as the prioritized date.
86 | ORDER_QUESN_LIST | VARCHAR | No |
The list of question records associated with this order.
87 | HOME_CARE_TYPE_C_NAME | VARCHAR | No |
This item stores the type of home care episode the order should create if it is a home care referral order.
May contain organization-specific values: Yes
Category Entries:
Obstetrics
Acute Care
Anticoagulation
Transplant
Oncology - Chemotherapy
Oncology - Supportive Care
Oncology - Follow-up
Home Health
Hospice
Obstetrics - Delivery
Blood and Marrow Transplant
Traveler
Obstetrics History
Obstetrics - Delivery History
Patient Administrative Pathway
Billing
Long Term Care
Beacon - Treatment Plan
Therapy Plan
Mechanical Circulatory Support
Patient-Entered Data (Storage)
Patient-Entered Data (View)
Immune Effector Cell Therapy
Fertility
ALS (Amyotrophic Lateral Sclerosis)
Patient Administrative Pathway Parent
Behavioral Health
Care Path
Care/Case Management
Specialty Pharmacy
Radiation Therapy
Research
Compass Rose Program
Compass Rose Service
Dialysis Episode
Cell Therapy Care Path
Medication Management
Home Infusion
Structural Heart
Dialysis Modality
Orthodontics
Patient Care Plan
Lung Nodule Management
Remote Patient Monitoring
Workers' Compensation
National Cancer Audits
Medication Access
Breast Cancer High Risk
Inpatient Rehab
Outpatient Rehab
DBC
Medication for Opioid Use Disorder Treatment
Intermediate Care
Tapestry Cross-Claim Pricing
88 | SPECIMEN_BARCODE | VARCHAR | No |
Stores the barcode data scanned during specimen collection.