|
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. |
|
|