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