OR_CASE_3
Description:
The OR_CASE_3 table enables you to report on surgical and procedural case data. This table has the same basic structure as OR_CASE and OR_CASE_2, but was created as a second table to prevent OR_CASE and OR_CASE_2 from getting any larger.

Primary Key
Column Name Ordinal Position
CASE_ID 1

Column Information
Name Type Discontinued?
1 CASE_ID VARCHAR No
The unique identifier (.1 item) for the case request record.
2 SETUP_TIME_MOD_YN VARCHAR No
This item tracks whether the setup time for a case has been modified by the user.
May contain organization-specific values: No
Category Entries:
No
Yes
3 DFLT_SETUP_MINS INTEGER No
This item stores the setup time defaulted by the system.
4 DFLT_CLEANUP_MINS INTEGER No
This item stores the clean up time defaulted by the system.
5 DFLT_PREP_MINS INTEGER No
This item stores the patient prep time defaulted by the system.
6 DFLT_WRAPUP_MINS INTEGER No
This item stores the wrap-up time defaulted by the system.
7 CLEANUP_TIME_MOD_YN VARCHAR No
This item tracks whether the clean up time for a case has been modified by the user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
8 WRAPUP_TIME_MOD_YN VARCHAR No
This item tracks whether the wrap-up time for a case has been modified by the user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
9 CASE_LEN_MOD_YN VARCHAR No
This item indicates whether the length of a procedure or panel has been modified by a user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
10 LEN_MOD_USER_ID VARCHAR No
This item tracks the last user to modify a length of a procedure or panel such that a length doesn't use the defaulted length.
11 LEN_MOD_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
12 PAN1_PAN_DLFT_SNG_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there is only a single procedure in this panel.
May contain organization-specific values: No
Category Entries:
Match procedure, provider, and location.
Match procedure and provider; all locations.
Match procedure and location; all providers.
Match procedure; all locations and providers.
Match procedure, provider, and location. Include multiple procedure cases.
Match procedure and provider; all locations. Include multiple procedure cases.
Match procedure and location; all providers. Include multiple procedure cases.
Match procedure; all locations and providers. Include multiple procedure cases.
Use time when performed with other procedures from preference card.
Use time when performed as a single procedure from preference card.
13 PAN1_PAN_DLFT_MLT_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple procedures on this panel.
May contain organization-specific values: No
Category Entries:
Match procedure combination, provider, and location.
Match procedure combination and provider; all locations.
Match procedure combination and location; all providers.
Match procedure combination; All locations and providers.
Match procedure combination, provider, and location. Include multi-panel cases.
Match procedure combination and provider; all locations. Include multi-panel cases.
Match procedure combination and location; all providers. Include multi-panel cases.
Match procedure combination; All locations and providers. Include multi-panel cases.
Use individual procedures. Match provider and location.
Use individual procedures. Match provider; all locations.
Use individual procedures. Match location; all providers.
Use individual procedures. All locations and providers.
Individual procedures. Match provider and location. Include single procedure cases.
Individual procedures. Match provider; all locations. Include single procedure cases.
Individual procedures. Match location; all providers. Include single procedure cases.
Individual procedures. All locations and providers. Include single procedure cases.
Use times when performed with other procedures from preference cards.
Use times when performed as single procedures from preference cards.
14 PAN1_PAN_DLFT_PAN_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple panels on this case.
May contain organization-specific values: No
Category Entries:
Match procedure combination, provider, and location.
Match procedure combination and provider; all locations.
Match procedure combination and location; all providers.
Match procedure combination; All locations and providers.
Match procedure combination, provider, and location. Include single panel cases.
Match procedure combination and provider; all locations. Include single panel cases.
Match procedure combination and location; all providers. Include single panel cases.
Match procedure combination; All locations and providers. Include single panel cases.
Use individual procedures. Match provider and location.
Use individual procedures. Match provider; all locations.
Use individual procedures. Match location; all providers.
Use individual procedures. All locations and providers.
Individual procedures. Match provider and location. Include single procedure cases.
Individual procedures. Match provider; all locations. Include single procedure cases.
Individual procedures. Match location; all providers. Include single procedure cases.
Individual procedures. All locations and providers. Include single procedure cases.
Use times when performed with other procedures from preference cards.
Use times when performed as single procedures from preference cards.
15 PAN2_PAN_DLFT_SNG_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there is only a single procedure in this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_SNG_TYP_C_NAME
16 PAN2_PAN_DLFT_MLT_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple procedures on this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_MLT_TYP_C_NAME
17 PAN2_PAN_DLFT_PAN_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple panels on this case.
The category values for this column were already listed for column: PAN1_PAN_DLFT_PAN_TYP_C_NAME
18 PAN3_PAN_DLFT_SNG_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there is only a single procedure in this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_SNG_TYP_C_NAME
19 PAN3_PAN_DLFT_MLT_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple procedures on this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_MLT_TYP_C_NAME
20 PAN3_PAN_DLFT_PAN_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple panels on this case.
The category values for this column were already listed for column: PAN1_PAN_DLFT_PAN_TYP_C_NAME
21 PAN4_PAN_DLFT_SNG_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there is only a single procedure in this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_SNG_TYP_C_NAME
22 PAN4_PAN_DLFT_MLT_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple procedures on this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_MLT_TYP_C_NAME
23 PAN4_PAN_DLFT_PAN_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple panels on this case.
The category values for this column were already listed for column: PAN1_PAN_DLFT_PAN_TYP_C_NAME
24 PAN5_PAN_DLFT_SNG_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there is only a single procedure in this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_SNG_TYP_C_NAME
25 PAN5_PAN_DLFT_MLT_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple procedures on this panel.
The category values for this column were already listed for column: PAN1_PAN_DLFT_MLT_TYP_C_NAME
26 PAN5_PAN_DLFT_PAN_TYP_C_NAME VARCHAR No
This item stores the defaulting method used for generating procedure time estimates for this panel when there are multiple panels on this case.
The category values for this column were already listed for column: PAN1_PAN_DLFT_PAN_TYP_C_NAME
27 PAN1_REQ_PROC_MINS INTEGER No
This item holds the requested total number of minutes for all the procedures in a panel.
28 PAN2_REQ_PROC_MINS INTEGER No
This item holds the requested total number of minutes for all the procedures in a panel.
29 PAN3_REQ_PROC_MINS INTEGER No
This item holds the requested total number of minutes for all the procedures in a panel.
30 PAN4_REQ_PROC_MINS INTEGER No
This item holds the requested total number of minutes for all the procedures in a panel.
31 PAN5_REQ_PROC_MINS INTEGER No
This item holds the requested total number of minutes for all the procedures in a panel.
32 PAN1_REQ_PROC_CMTS VARCHAR No
This item holds the comments regarding the requested total procedure length in minutes.
33 PAN2_REQ_PROC_CMTS VARCHAR No
This item holds the comments regarding the requested total procedure length in minutes.
34 PAN3_REQ_PROC_CMTS VARCHAR No
This item holds the comments regarding the requested total procedure length in minutes.
35 PAN4_REQ_PROC_CMTS VARCHAR No
This item holds the comments regarding the requested total procedure length in minutes.
36 PAN5_REQ_PROC_CMTS VARCHAR No
This item holds the comments regarding the requested total procedure length in minutes.
37 PAN1_REQ_PROC_ACT_C_NAME VARCHAR No
This item stores the action taken in regards to the requested total procedure length in minutes for this panel.
May contain organization-specific values: Yes
Category Entries:
No Action
Accepted
Rejected
Automatically Used
38 PAN2_REQ_PROC_ACT_C_NAME VARCHAR No
This item stores the action taken in regards to the requested total procedure length in minutes for this panel.
The category values for this column were already listed for column: PAN1_REQ_PROC_ACT_C_NAME
39 PAN3_REQ_PROC_ACT_C_NAME VARCHAR No
This item stores the action taken in regards to the requested total procedure length in minutes for this panel.
The category values for this column were already listed for column: PAN1_REQ_PROC_ACT_C_NAME
40 PAN4_REQ_PROC_ACT_C_NAME VARCHAR No
This item stores the action taken in regards to the requested total procedure length in minutes for this panel.
The category values for this column were already listed for column: PAN1_REQ_PROC_ACT_C_NAME
41 PAN5_REQ_PROC_ACT_C_NAME VARCHAR No
This item stores the action taken in regards to the requested total procedure length in minutes for this panel.
The category values for this column were already listed for column: PAN1_REQ_PROC_ACT_C_NAME
42 PAN1_PANEL_CONFIDENCE_C_NAME VARCHAR No
This item stores the confidence in Epic's estimated panel length for panel 1
May contain organization-specific values: No
Category Entries:
No Data
Modified
Low Confidence
Medium Confidence
High Confidence
Low - Preference Card
Low - Individual Procedures
Low - No Cases
Low - High Variability
Low - Few Stored Cases
Low - Possible Procedures
Medium - Moderate Variability
High - Low Variability
43 PAN2_PANEL_CONFIDENCE_C_NAME VARCHAR No
This item stores the confidence in Epic's estimated panel length for panel 2
The category values for this column were already listed for column: PAN1_PANEL_CONFIDENCE_C_NAME
44 PAN3_PANEL_CONFIDENCE_C_NAME VARCHAR No
This item stores the confidence in Epic's estimated panel length for panel 3
The category values for this column were already listed for column: PAN1_PANEL_CONFIDENCE_C_NAME
45 PAN4_PANEL_CONFIDENCE_C_NAME VARCHAR No
This item stores the confidence in Epic's estimated panel length for panel 4
The category values for this column were already listed for column: PAN1_PANEL_CONFIDENCE_C_NAME
46 PAN5_PANEL_CONFIDENCE_C_NAME VARCHAR No
This item stores the confidence in Epic's estimated panel length for panel 5
The category values for this column were already listed for column: PAN1_PANEL_CONFIDENCE_C_NAME
47 PAT_CONF_CASE_YN VARCHAR No
Whether the patient confirmed their case or not. Set to Yes by 2-way text confirmation or by OR staff.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
48 CASE_CONF_UTC_DTTM DATETIME (UTC) No
The most recent instant of a patient's case confirmation. Part of the patient case confirmation workflow. Updated each time the patient confirms and reset to null when case is rescheduled to different date or OR location.
49 CASE_CONF_PAT_ID VARCHAR No
The patient ID of the patient if they texted to confirm their own case.
50 CONF_PAT_RELATIONSHIP_ID NUMERIC No
The Guardian (RLA networked ID) that confirmed the patient's case through text.
51 CASE_CONF_USER_ID VARCHAR No
The employee ID (EMP networked) that confirmed the patient's case.
52 CASE_CONF_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
53 PAN1_TOTAL_PROC_MIN INTEGER No
The total number of minutes required for all of the procedures on this panel.
54 PAN1_DFLT_PROC_MINS INTEGER No
The total number of minutes required for all of the procedures on this panel as calculated by the system using procedure length estimates, preference cards, and procedure records.
55 PAN1_PROC_MIN_MOD_YN VARCHAR No
Whether the total number of minutes required for all of the procedures on this panel has been modified from the defaulted value calculated by the system. This does not track whether the lengths of any of the individual procedures on the panel have been modified.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
56 PAN1_PROC_START INTEGER No
The time at which this panel's procedures should begin. This is measured in minutes relative to the beginning of the case.
57 PAN1_PRC_STRT_MOD_YN VARCHAR No
Whether the time at which this panel's procedures should begin has been manually edited by a user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
58 PAN1_REQ_MINS_USER_ID VARCHAR No
The id of the user who requested a total procedure length for this panel in minutes.
59 PAN1_REQ_MINS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
60 PAN2_TOTAL_PROC_MIN INTEGER No
The total number of minutes required for all of the procedures on this panel.
61 PAN2_DFLT_PROC_MINS INTEGER No
The total number of minutes required for all of the procedures on this panel as calculated by the system using procedure length estimates, preference cards, and procedure records.
62 PAN2_PROC_MIN_MOD_YN VARCHAR No
Whether the total number of minutes required for all of the procedures on this panel has been modified from the defaulted value calculated by the system. This does not track whether the lengths of any of the individual procedures on the panel have been modified.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
63 PAN2_PROC_START INTEGER No
The time at which this panel's procedures should begin. This is measured in minutes relative to the beginning of the case.
64 PAN2_PRC_STRT_MOD_YN VARCHAR No
Whether the time at which this panel's procedures should begin has been manually edited by a user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
65 PAN2_REQ_MINS_USER_ID VARCHAR No
The id of the user who requested a total procedure length for this panel in minutes.
66 PAN2_REQ_MINS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
67 PAN3_TOTAL_PROC_MIN INTEGER No
The total number of minutes required for all of the procedures on this panel.
68 PAN3_DFLT_PROC_MINS INTEGER No
The total number of minutes required for all of the procedures on this panel as calculated by the system using procedure length estimates, preference cards, and procedure records.
69 PAN3_PROC_MIN_MOD_YN VARCHAR No
Whether the total number of minutes required for all of the procedures on this panel has been modified from the defaulted value calculated by the system. This does not track whether the lengths of any of the individual procedures on the panel have been modified.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
70 PAN3_PROC_START INTEGER No
The time at which this panel's procedures should begin. This is measured in minutes relative to the beginning of the case.
71 PAN3_PRC_STRT_MOD_YN VARCHAR No
Whether the time at which this panel's procedures should begin has been manually edited by a user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
72 PAN3_REQ_MINS_USER_ID VARCHAR No
The id of the user who requested a total procedure length for this panel in minutes.
73 PAN3_REQ_MINS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
74 PAN4_TOTAL_PROC_MIN INTEGER No
The total number of minutes required for all of the procedures on this panel.
75 PAN4_DFLT_PROC_MINS INTEGER No
The total number of minutes required for all of the procedures on this panel as calculated by the system using procedure length estimates, preference cards, and procedure records.
76 PAN4_PROC_MIN_MOD_YN VARCHAR No
Whether the total number of minutes required for all of the procedures on this panel has been modified from the defaulted value calculated by the system. This does not track whether the lengths of any of the individual procedures on the panel have been modified.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
77 PAN4_PROC_START INTEGER No
The time at which this panel's procedures should begin. This is measured in minutes relative to the beginning of the case.
78 PAN4_PRC_STRT_MOD_YN VARCHAR No
Whether the time at which this panel's procedures should begin has been manually edited by a user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
79 PAN4_REQ_MINS_USER_ID VARCHAR No
The id of the user who requested a total procedure length for this panel in minutes.
80 PAN4_REQ_MINS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
81 PAN5_TOTAL_PROC_MIN INTEGER No
The total number of minutes required for all of the procedures on this panel.
82 PAN5_DFLT_PROC_MINS INTEGER No
The total number of minutes required for all of the procedures on this panel as calculated by the system using procedure length estimates, preference cards, and procedure records.
83 PAN5_PROC_MIN_MOD_YN VARCHAR No
Whether the total number of minutes required for all of the procedures on this panel has been modified from the defaulted value calculated by the system. This does not track whether the lengths of any of the individual procedures on the panel have been modified.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
84 PAN5_PROC_START INTEGER No
The time at which this panel's procedures should begin. This is measured in minutes relative to the beginning of the case.
85 PAN5_PRC_STRT_MOD_YN VARCHAR No
Whether the time at which this panel's procedures should begin has been manually edited by a user.
The category values for this column were already listed for column: SETUP_TIME_MOD_YN
86 PAN5_REQ_MINS_USER_ID VARCHAR No
The id of the user who requested a total procedure length for this panel in minutes.
87 PAN5_REQ_MINS_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
88 CASE_CONF_MYPT_ID VARCHAR No
The MyChart user (WPR networked ID) that confirmed the patient's case through text.