ORDER_PROC

Description: |
The ORDER_PROC table enables you to report on the procedures ordered in the clinical system. We have also included patient and contact identification information for each record.

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 order record associated with this procedure order.
2 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this order. This column is frequently used to link to the PATIENT table.
3 | PAT_ENC_DATE_REAL | FLOAT | No |
A unique, internal contact date in decimal format. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
4 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across patients and encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
5 | RESULT_LAB_ID | NUMERIC | No |
The unique ID of the lab or other resulting agency, such as radiology, that provided the order results.
6 | RESULT_LAB_ID_LLB_NAME | VARCHAR | No |
Interface laboratory name.
7 | ORDERING_DATE | DATETIME | No |
The date when the procedure order was placed.
8 | ORDER_TYPE_C_NAME | VARCHAR | No |
The order type category number for the procedure order.
May contain organization-specific values: Yes
Category Entries:
Medications
9 | PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
10 | DESCRIPTION | VARCHAR | No |
A brief summary of the procedure order.
11 | ORDER_CLASS_C_NAME | VARCHAR | No |
The order class category number of the procedure order.
May contain organization-specific values: Yes
Category Entries:
Normal
12 | AUTHRZING_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.
13 | ABNORMAL_YN | VARCHAR | No |
Indicates whether or not this order contains abnormal results. This column will contain a Y if there are abnormal results and an N or null if it does not. For orders with lab component results, if any one component of this order has an abnormal result value then this will hold a Y.
May contain organization-specific values: No
Category Entries:
Abnormal
Normal
14 | BILLING_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.
15 | ORD_CREATR_USER_ID | VARCHAR | No |
The unique identifier of the user who signed the order, or the last person who performed a sign and hold or release action for a signed and held order.
16 | ORD_CREATR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
17 | LAB_STATUS_C_NAME | VARCHAR | No |
The category number for the status of results for an order, as of the date and time the record was extracted.
May contain organization-specific values: No
Category Entries:
In process
Preliminary result
Final result
Edited
Edited Result - FINAL
18 | ORDER_STATUS_C_NAME | VARCHAR | No |
The order status category number of the procedure order.
May contain organization-specific values: No
Category Entries:
Pending
Sent
Resulted
Canceled
Completed
Holding for Referral
Denied Approval
Suspend
Discontinued
Verified
Dispensed
Pending Verify
19 | MODIFIER1_ID | VARCHAR | No |
The unique ID of the modifier record. This is the first modifier entered for the procedure and affects how the procedure is billed.
20 | MODIFIER1_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
21 | MODIFIER2_ID | VARCHAR | No |
The unique ID of the modifier record. This is the second modifier entered for the procedure and affects how the procedure is billed.
22 | MODIFIER2_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
23 | MODIFIER3_ID | VARCHAR | No |
The unique ID of the modifier record. This is the third modifier entered for the procedure and affects how the procedure is billed.
24 | MODIFIER3_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
25 | MODIFIER4_ID | VARCHAR | No |
The unique ID of the modifier record. This is the fourth modifier entered for the procedure and affects how the procedure is billed.
26 | MODIFIER4_ID_MODIFIER_NAME | VARCHAR | No |
The name of the modifier record.
27 | QUANTITY | INTEGER | No |
The number of procedures authorized for this order.
28 | REASON_FOR_CANC_C_NAME | VARCHAR | No |
The reason for cancellation category number for the procedure order.
May contain organization-specific values: Yes
29 | FUTURE_OR_STAND | VARCHAR | No |
This column indicates whether an order is a future (F) or standing (S) order.
May contain organization-specific values: No
Category Entries:
Standing
Future
30 | STANDING_EXP_DATE | DATETIME | No |
The date when a recurring procedure order expires.
31 | FUT_EXPECT_COMP_DT | DATETIME | No |
The date by which each future procedure order should be completed. Displayed in calendar format.
32 | STANDING_OCCURS | INTEGER | No |
The number of individual occurrences remaining for this procedure order.
33 | STAND_ORIG_OCCUR | INTEGER | No |
The total number of occurrences that a recurring order was authorized for.
34 | REFERRING_PROV_ID | VARCHAR | No |
The unique ID of the provider who has referred this order, i.e. the referring provider.
35 | REFERRING_PROV_ID_REFERRING_PROV_NAM | VARCHAR | No |
The name of the referral source.
36 | REFD_TO_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
37 | REFD_TO_SPECLTY_C_NAME | VARCHAR | No |
The category value for the medical specialty of the provider to which the patient is referred. This field does not contain data for referral orders created within Epic.
May contain organization-specific values: Yes
38 | REQUESTED_SPEC_C_NAME | VARCHAR | No |
The medical specialty category number of the provider to which the patient was referred for the procedure order.
May contain organization-specific values: Yes
39 | RFL_CLASS_C_NAME | VARCHAR | No |
The referral class category number for the procedure order.
May contain organization-specific values: No
Category Entries:
Internal
Incoming
Outgoing
40 | RFL_TYPE_C_NAME | VARCHAR | No |
The referral type category number for the procedure order.
May contain organization-specific values: Yes
41 | RSN_FOR_RFL_C_NAME | VARCHAR | No |
The reason for referral category number for the procedure order.
May contain organization-specific values: Yes
42 | RFL_NUM_VIS | INTEGER | No |
The number of visits this referral order is authorized for.
43 | RFL_EXPIRE_DT | DATETIME | No |
The expiration date for this referral order.
44 | ABN_NOTE_ID | VARCHAR | No |
The unique ID of the notes record representing the Advanced Beneficiary Notice form associated with this order.
45 | RADIOLOGY_STATUS_C_NAME | VARCHAR | No |
The category ID for the imaging study status (e.g. technician ended the exam, reading physician finalized the exam) of the procedure order.
May contain organization-specific values: No
Category Entries:
Ordered
No Show
Scheduled
Arrived
Exam Begun
Procedure Started
Discontinued
Procedure Finished
Exam Ended
----- BEGIN READING PALETTE STATUSES -----
Tech Complete
Tech Revise
Resident Revise
Saved
Queued In Trans
In Transcription
Incomplete Transcription
Transcribed
Wet Read
Queued Prelim
Preliminary
Queued Needs Review
Needs Review
Revised
Queued Final
Final
Cadence Non-Imaging Order
46 | INT_STUDY_C_NAME | VARCHAR | No |
The category ID for denoting the reason a study is worth being marked for later review, as in for an educational case or for group reading physician review.
May contain organization-specific values: Yes
Category Entries:
Teaching Case
47 | INT_STUDY_USER_ID | VARCHAR | No |
The unique ID of the employee record who denoted a study as worth being marked for later review, as in for an educational case or for group reading physician review.
48 | INT_STUDY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
49 | TECHNOLOGIST_ID | VARCHAR | No |
The unique ID of the employee record of the technologist who performed this procedure.
50 | TECHNOLOGIST_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
51 | PROC_BGN_TIME | DATETIME (Local) | No |
The date and time when the procedure order (exam) is to begin.
52 | RIS_TRANS_ID | VARCHAR | No |
The unique ID of the user record of the transcriptionist for this order.
53 | RIS_TRANS_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
54 | ORDER_INST | DATETIME (Local) | No |
The instant when the order was created.
55 | DISPLAY_NAME | VARCHAR | No |
The name of the order as it appears in the patient's record.
56 | HV_HOSPITALIST_YN | VARCHAR | No |
Indicates whether or not this order was placed by a hospitalist. ‘Y’ indicates that this order was placed by a hospitalist. ‘N’ or NULL indicate that this order was not placed by a hospitalist.
May contain organization-specific values: No
Category Entries:
Yes
No
57 | ORDER_PRIORITY_C_NAME | VARCHAR | No |
The overall priority category number for the procedure order.
May contain organization-specific values: Yes
58 | CHRG_DROPPED_TIME | DATETIME (Local) | No |
The date and time when the charge was generated for the procedure order.
59 | PANEL_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
60 | STAND_INTERVAL | VARCHAR | No |
The time interval set for a recurring order, indicating the time between one instance of the order and the next instance.
61 | DISCRETE_INTERVAL_NAME | VARCHAR | No |
The discrete interval for the order. This is extracted as the category title.
May contain organization-specific values: Yes
62 | INSTANTIATED_TIME | DATETIME | No |
The date and time of instantiation when a child order is generated from a standing or future order.
63 | INSTNTOR_USER_ID | VARCHAR | No |
The unique ID of the user who instantiated the order.
64 | INSTNTOR_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
65 | DEPT_REF_PROV_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
66 | SPECIALTY_DEP_C_NAME | VARCHAR | No |
The category value for the requested medical specialty of the department to which the patient is referred.
The category values for this column were already listed for column: REFD_TO_SPECLTY_C_NAME
67 | SPECIMEN_TYPE_C_NAME | VARCHAR | No |
The specimen type category number for the procedure order.
May contain organization-specific values: Yes
68 | SPECIMEN_SOURCE_C_NAME | VARCHAR | No |
The source category number for the procedure order.
May contain organization-specific values: Yes
69 | ORDER_TIME | DATETIME (Local) | No |
The date and time when the procedure order was placed.
70 | RESULT_TIME | DATETIME (Local) | No |
The most recent date and time when the procedure order was resulted.
71 | IS_PENDING_ORD_YN | VARCHAR | No |
Indicates whether or not the order has a pending status. 'Y' indicates that the order has a pending status. 'N' or NULL indicates that the order does not have a pending status.
May contain organization-specific values: No
Category Entries:
Yes
72 | PROC_START_TIME | DATETIME (Local) | No |
The date and time when the procedure order is to start.
73 | PROBLEM_LIST_ID | NUMERIC | No |
The unique ID of the problem list record that is associated with this order. This column is mainly used for immunization orders.
74 | RSLTS_INTERPRETER | VARCHAR | No |
The name of the principal results interpreter, the person who reviewed and interpreted the results.
75 | PROC_ENDING_TIME | DATETIME (Local) | No |
The date and time when the procedure order is to end.
76 | SPECIFIED_FIRST_TM | DATETIME (Local) | No |
The first occurrence time specified by a user, if the order was signed with a frequency record containing a schedule of specified dates and times.
77 | SCHED_START_TM | DATETIME (Local) | No |
This column stores the scheduling start instant used when the order was last scheduled.
78 | SESSION_KEY | VARCHAR | No |
The unique key associated with the order at the time of signing. Other orders will share this key if they were signed at the same time.
79 | LABCORP_BILL_TYPE_C_NAME | VARCHAR | No |
The reference lab bill type category ID for the order record, indicating how reference labs should bill for services performed.
May contain organization-specific values: Yes
Category Entries:
Client
Patient
Third-Party
80 | LABCORP_CLIENT_ID | VARCHAR | No |
The client ID or account ID assigned by the reference lab.
81 | LABCORP_CONTROL_NUM | INTEGER | No |
Required information for LabCorp requisition and order messages.
82 | CHNG_ORDER_PROC_ID | NUMERIC | No |
The unique ID of the changed or reordered procedure order that this procedure replaced. This column is frequently used to link back to ORDER_PROC table.