OR_CASE_ALL_PROC
Description:
The OR_CASE_ALL_PROC table contains OR management system case procedures.

Primary Key
Column Name Ordinal Position
OR_CASE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 OR_CASE_ID VARCHAR No
The unique ID of the case record.
2 LINE INTEGER No
The number of the line of the procedure within the case.
3 OR_PROC_ID VARCHAR No
The unique ID of the procedure record.
4 OR_PROC_ID_PROC_NAME VARCHAR No
The name of the surgical procedure record.
5 POS_C_NAME VARCHAR No
The category value which represents the position in which the patient should be placed when performing the surgery.
May contain organization-specific values: Yes
6 LRB_C_NAME VARCHAR No
The category value which represents the side of the body the procedure on which the procedure is being performed.
May contain organization-specific values: Yes
Category Entries:
Left
Right
Bilateral
N/A
Default
7 ANES_TYPE_C_NAME VARCHAR No
The category value which represents the type of anesthesia used for this procedure.
May contain organization-specific values: Yes
8 OP_REG_C_NAME VARCHAR No
The category value which indicates the region of the body that will be operated on during the surgery.
May contain organization-specific values: Yes
9 TOTAL_LENGTH INTEGER No
The total amount of time required for the case. This includes all procedures in all panels as well as the setup and cleanup times for the case.
10 PANEL INTEGER No
The procedure panel within which this procedure is contained. This is a numeric value between 1 and 5.
11 COMMENTS VARCHAR No
The free text comments for this procedure.
12 DEFAULTED_LENGTH NUMERIC No
The length defaulted for this procedure by the system in minutes.
13 RESOURCE_PREF_ID VARCHAR No
The procedure or preference card ID used to default the resources in the case for this procedure.
14 RESOURCE_PREF_ID_PROC_NAME VARCHAR No
The name of the surgical procedure record.
15 PICKLIST_PREF_ID VARCHAR No
The procedure or preference card ID used to default the pick list in the case for this procedure.
16 PICKLIST_PREF_ID_PROC_NAME VARCHAR No
The name of the surgical procedure record.
17 LENGTH_MODIFIED_YN VARCHAR No
Indicates whether the procedure length was modified by the user. Y indicates that the procedure length was modified. A null value indicates that the length was not modified. An N will not be populated for this column.
May contain organization-specific values: No
Category Entries:
No
Yes
18 MATCHED_PREF_ID VARCHAR No
This item stores the preference card that has been selected to override the defaulted preference card.
19 MATCHED_PREF_ID_PROC_NAME VARCHAR No
The name of the surgical procedure record.
20 POSSIBLE_PROC_YN VARCHAR No
Indicates whether the procedure was flagged as a possible procedure. Y indicates that the procedure was flagged as a possible procedure. N or null indicates that the procedure was not flagged as a possible procedure.
The category values for this column were already listed for column: LENGTH_MODIFIED_YN
21 DBC_EPISODE_ID NUMERIC No
Stores the Diagnose Behandel Combinatie (DBC) episode associated with the current procedure. Used in billing.
22 PROC_EAP_ID NUMERIC No
Stores the ordered procedure (EAP) associated with the preference card.
23 ALL_PROC_AS_ORDERED VARCHAR No
Specify the procedure name as exactly ordered by the surgeon/provider.
24 ALL_PROC_CODE_ID NUMERIC No
This item stores the procedure (EAP) linked to the procedure code. This column is only populated for older surgical cases which were created and last modified before upgrading to the Epic Nov 2022 version. For newer surgical cases, codes are in OR_OPE_PROC_CODE.PROC_CODE_ID. OR_CASE_ALL_PROC joins to OR_OPE_PROC_CODE on column ALL_PANEL_ADDL_OPE_ID.
25 ALL_DEF_OR_PROC_ID VARCHAR No
This item stores the defaulted preference card.
26 ALL_DEF_OR_PROC_ID_PROC_NAME VARCHAR No
The name of the surgical procedure record.
27 ALL_PANEL_ADDL_OPE_ID NUMERIC No
Stores the pointer to the procedure additional data record for all panels.