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 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 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 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
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
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 National Cancer Audits Med Access 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.