OR_CASE
Description:
The OR_CASE table contains OR management system case records.

Primary Key
Column Name Ordinal Position
OR_CASE_ID 1

Column Information
Name Type Discontinued?
1 OR_CASE_ID VARCHAR No
The unique ID of the procedural case record.
2 CASE_NAME VARCHAR No
The name of the surgical case record.
3 SURGERY_DATE DATETIME No
The date on which the surgery is scheduled to take place.
4 CASE_TYPE_C_NAME VARCHAR No
The case type category number for the case. Example case types include elective and emergency. This column is frequently used to link to ZC_OR_CASE_TYPE.
May contain organization-specific values: Yes
5 CASE_CLASS_C_NAME VARCHAR No
The case classification category number for the case. Example case types include elective and trauma. This column is frequently used to link to ZC_OR_CASE_CLASS.
May contain organization-specific values: Yes
6 PAT_ID VARCHAR No
The unique ID of the patient associated with the procedural case record.
7 PAT_AGE INTEGER No
The age of the patient associated with the surgical case.
8 PAT_CLASS_C_NAME VARCHAR No
The category value which represents the type of the patient associated with the surgical case record.
May contain organization-specific values: Yes
9 SERVICE_C_NAME VARCHAR No
The category value which identifies the surgical service of the case record.
May contain organization-specific values: Yes
10 NUM_OF_PANELS INTEGER No
The total number of procedure panels in the surgical case record. A panel is a grouping of surgical procedures performed together.
11 EXP_DATE DATETIME No
The date on which this surgical case expires. The case should be scheduled on or before this date.
12 REQUESTED_BY VARCHAR No
The name of the person who requested that the surgical case be created.
13 SETUP_OFFSET INTEGER No
The amount of time in minutes required to set up at the beginning of the case.
14 CLEANUP_OFFSET INTEGER No
The amount of time in minutes required to clean up at the end of the case.
15 START_AT_OR_AFTER DATETIME (Local) No
The time of day before which the case cannot begin.
16 START_AT_OR_BEFORE DATETIME (Local) No
The time of day after which the case cannot begin.
17 TOTAL_TIME_NEEDED INTEGER No
The total amount of time required to perform the case.
18 REFERRING_PROV_ID VARCHAR No
The unique ID of the physician who referred the patient associated with the case.
19 PREOP_XRAYS_YN VARCHAR No
Yes/No flag which indicates whether or not x-rays were taken before the surgery was performed.
May contain organization-specific values: No
Category Entries:
Yes
No
20 PREOP_VISIT_YN VARCHAR No
Yes/No flag which indicates whether or not the patient completed a pre-op clinic visit.
The category values for this column were already listed for column: PREOP_XRAYS_YN
21 LATEX_ALLERGIC_YN VARCHAR No
Yes/No flag which indicates whether or not the patient has a latex allergy.
The category values for this column were already listed for column: PREOP_XRAYS_YN
22 OR_ID VARCHAR No
The unique ID of the room the case is scheduled to be performed. This column is frequently used to link to CLARITY_SER.
23 LOC_ID NUMERIC No
The unique ID of the location where the procedure is scheduled to be performed. This column is frequently used to link to CLARITY_LOC.
24 PRIORITY_C_NAME VARCHAR No
The category value which represents the priority of the case.
May contain organization-specific values: No
Category Entries:
Low
Normal
High
25 ADD_ON_CASE_YN VARCHAR No
Indicates whether a case is an add-on. Y indicates that the add-on check box is checked, and this is done manually by the scheduler for cases that have been scheduled after the usual scheduling window is closed. N or null indicates that the case is not an add-on.
May contain organization-specific values: No
Category Entries:
No
Yes
26 SCHED_STATUS_C_NAME VARCHAR No
The category number for the case scheduling status.
May contain organization-specific values: Yes
Category Entries:
Scheduled
Canceled
Not Scheduled
Missing Information
Voided
Pending
Arrived
Completed
No Show
Pending Unscheduled
27 CASE_PROGRESS_C_NAME VARCHAR No
The category value which represents the current progress status of the case as it proceeds.
May contain organization-specific values: Yes
28 CANCEL_REASON_C_NAME VARCHAR No
The category number of the most recent reason the case was canceled or removed from the schedule. This column will remain populated even if the case is put back on the schedule. This column is frequently used to link to ZC_OR_CANCEL_RSN.
May contain organization-specific values: Yes
29 CANCEL_USER_ID VARCHAR No
The unique ID of the user who most recently canceled the case or removed it from the schedule. This column will remain populated even if the case is put back on the schedule. This column is frequently used to link to CLARITY_EMP.
30 CANCEL_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
31 CANCEL_COMMENTS VARCHAR No
The comments entered by the user that canceled the case.
32 TIME_SCHEDULED DATETIME (Local) No
The date and time at which the case is scheduled to be performed on the surgery date.
33 VOID_REASON_C_NAME VARCHAR No
The category number for the reason the case was voided. This column is frequently used to link to ZC_OR_VOID_REASON.
May contain organization-specific values: Yes
34 CANCEL_CHKIN_RSN_C_NAME VARCHAR No
The category value which represents the reason the check-in was canceled.
May contain organization-specific values: Yes
35 CHECKIN_INSTANT DATETIME (Local) No
The date and time at which the case was checked-in.
36 PATIENT_ESCORT VARCHAR No
The person escorting the patient for the surgery. This is a free text value.
37 PANEL1_START_AT INTEGER No
Indicates at what time within the case panel 1 should begin. This is measured in minutes relative to the beginning of the case.
38 PANEL1_LENGTH INTEGER No
The total amount of time required for panel 1 to be performed. This includes the times of all the procedures within the panel.
39 PANEL2_START_AT INTEGER No
Indicates at what time within the case panel 2 should begin. This is measured in minutes relative to the beginning of the case.
40 PANEL2_LENGTH INTEGER No
The total amount of time required for panel 2 to be performed. This includes the times of all the procedures within the panel.
41 PANEL3_START_AT INTEGER No
Indicates at what time within the case panel 3 should begin. This is measured in minutes relative to the beginning of the case.
42 PANEL3_LENGTH INTEGER No
The total amount of time required for panel 3 to be performed. This includes the times of all the procedures within the panel.
43 PANEL4_START_AT INTEGER No
Indicates at what time within the case panel 4 should begin. This is measured in minutes relative to the beginning of the case.
44 PANEL4_LENGTH INTEGER No
The total amount of time required for panel 4 to be performed. This includes the times of all the procedures within the panel.
45 PANEL5_START_AT INTEGER No
Indicates at what time within the case panel 5 should begin. This is measured in minutes relative to the beginning of the case.
46 PANEL5_LENGTH INTEGER No
The total amount of time required for panel 5 to be performed. This includes the times of all the procedures within the panel.
47 RECORD_CREATE_DATE DATETIME No
The date on which the case was created.
48 REC_CREATE_USER_ID VARCHAR No
The unique ID of the user who created the case.
49 REC_CREATE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
50 ADT_CSN NUMERIC No
Contact serial number for an Admission Discharge Transfer (ADT) admit contact.
51 CASE_REQST_USER_ID VARCHAR No
The unique ID of the user who placed the web request.
52 CASE_REQST_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
53 SHUFFLE_USER_ID VARCHAR No
The unique ID of the user who placed the case in the shuffle depot.
54 SHUFFLE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
55 FORMS_PRINTED_YN VARCHAR No
Yes/No flag indicating whether or not forms have been printed.
The category values for this column were already listed for column: ADD_ON_CASE_YN
56 CONFIDENTIAL_YN VARCHAR No
Yes/No flag indicating whether or not the case is confidential.
The category values for this column were already listed for column: ADD_ON_CASE_YN
57 PAT_LEVEL_C_NAME VARCHAR No
The category value representing the patient level in the case.
May contain organization-specific values: Yes
58 INTL_PATIENT_YN VARCHAR No
Yes/No flag which indicates whether or not the patient is international.
The category values for this column were already listed for column: PREOP_XRAYS_YN
59 PAIN_MGMT_C_NAME VARCHAR No
The category value which represents the patient's participation in pain management.
May contain organization-specific values: Yes
60 ADMIT_DATE DATETIME No
The date on which the patient was admitted.
61 LENGTH_OF_STAY INTEGER No
The length of the patient's stay while admitted.
62 RESEARCH_IND_C_NAME VARCHAR No
The category value which represents the candidacy of the case for research.
May contain organization-specific values: Yes
63 WEIGHT NUMERIC No
The approximate weight of the patient in pounds.
64 ADMIT_SOURCE_C_NAME VARCHAR No
The category value which indicates the admit source for the patient's stay.
May contain organization-specific values: Yes
65 ADMITTING_SRVC_C_NAME VARCHAR No
The category value which indicates the admitting service for the patient's stay.
May contain organization-specific values: Yes
66 ADMITTING_PHYS_ID VARCHAR No
The unique ID of the admitting physician.
67 ADMIT_BED_TYPE_C_NAME VARCHAR No
The category value which indicates the admitting bed type.
May contain organization-specific values: Yes
68 ADD_ON_DATE DATETIME No
The date the case first shows up as an add-on.
69 MODIFIED_CASE_LEN INTEGER No
The length of the case, in minutes, if it has been shortened or lengthened.
70 PAT_TOTAL_TIME INTEGER No
The amount of time in minutes for which the patient is present.
71 BUMPED_CASE_YN VARCHAR No
Yes/No flag indicating whether or not the case has been bumped.
The category values for this column were already listed for column: ADD_ON_CASE_YN
72 BUMPED_INSTANT DATETIME (Local) No
The date and time at which the case was bumped.
73 VOID_COMMENTS VARCHAR No
The free text comments entered when the case was voided.
74 CASE_ACCEPTED_YN VARCHAR No
Yes/No flag indicating whether or not the case was accepted in Case Entry.
The category values for this column were already listed for column: PREOP_XRAYS_YN
75 PROJ_START_INST DATETIME (Local) No
The projected date and time for the start of this case.
76 PROJ_END_INST DATETIME (Local) No
The projected date and time for the end of this case.
77 REAL_TIME_OR_ID VARCHAR No
Store the surgery case's operating room according to the log.
78 PANEL1_IS_COMB_YN VARCHAR No
Indicates whether the time for Panel 1 is the procedures' combination time from procedure time averaging. Y indicates that the time is from the procedures' combination procedure time average; N indicates it is not. A null value indicates the panel was not added in the case.
The category values for this column were already listed for column: ADD_ON_CASE_YN
79 PANEL2_IS_COMB_YN VARCHAR No
Indicates whether the time for Panel 2 is the procedures' combination time from procedure time averaging. Y indicates that the time is from the procedures' combination procedure time average; N indicates it is not. A null value indicates the panel was not added in the case.
The category values for this column were already listed for column: ADD_ON_CASE_YN
80 PANEL3_IS_COMB_YN VARCHAR No
Indicates whether the time for Panel 3 is the procedures' combination time from procedure time averaging. Y indicates that the time is from the procedures' combination procedure time average; N indicates it is not. A null value indicates the panel was not added in the case.
The category values for this column were already listed for column: ADD_ON_CASE_YN
81 PANEL4_IS_COMB_YN VARCHAR No
Indicates whether the time for Panel 4 is the procedures' combination time from procedure time averaging. Y indicates that the time is from the procedures' combination procedure time average; N indicates it is not. A null value indicates the panel was not added in the case.
The category values for this column were already listed for column: ADD_ON_CASE_YN
82 PANEL5_IS_COMB_YN VARCHAR No
Indicates whether the time for Panel 5 is the procedures' combination time from procedure time averaging. Y indicates that the time is from the procedures' combination procedure time average; N indicates it is not. A null value indicates the panel was not added in the case.
The category values for this column were already listed for column: ADD_ON_CASE_YN
83 PANEL1_DEF_LEN NUMERIC No
The panel length defaulted by the system for Panel 1.
84 PANEL2_DEF_LEN NUMERIC No
The panel length defaulted by the system for Panel 2.
85 PANEL3_DEF_LEN NUMERIC No
The panel length defaulted by the system for Panel 3.
86 PANEL4_DEF_LEN NUMERIC No
The panel length defaulted by the system for Panel 4.
87 PANEL5_DEF_LEN NUMERIC No
The panel length defaulted by the system for Panel 5.
88 PANEL1_LEN_MOD_YN VARCHAR No
Indicates whether the length of the panel 1 was modified by the user.
The category values for this column were already listed for column: ADD_ON_CASE_YN
89 PANEL2_LEN_MOD_YN VARCHAR No
Indicates whether the length of the panel 2 was modified by the user.
The category values for this column were already listed for column: ADD_ON_CASE_YN
90 PANEL3_LEN_MOD_YN VARCHAR No
Indicates whether the length of the panel 3 was modified by the user.
The category values for this column were already listed for column: ADD_ON_CASE_YN
91 PANEL4_LEN_MOD_YN VARCHAR No
Indicates whether the length of the panel 4 was modified by the user.
The category values for this column were already listed for column: ADD_ON_CASE_YN
92 PANEL5_LEN_MOD_YN VARCHAR No
Indicates whether the length of the panel 5 was modified by the user.
The category values for this column were already listed for column: ADD_ON_CASE_YN
93 REQUESTED_DATE DATETIME No
The preferred date requested for this case.
94 REQUESTED_TIME DATETIME (Local) No
The time (of the day) requested for this case.
95 EXP_ADM_DTE_OFFSET INTEGER No
Stores the number of days prior to the day of surgery, the patient is expected to be admitted.
96 PAT_ALLERGIES_YN VARCHAR No
Indicates if the patient has Allergies.
The category values for this column were already listed for column: ADD_ON_CASE_YN
97 PAT_HEALTH_ISSUE_YN VARCHAR No
Indicates if patient has health issues.
The category values for this column were already listed for column: ADD_ON_CASE_YN
98 FILMS_FOR_SURGER_YN VARCHAR No
Indicates if the patient is bringing films to surgery.
The category values for this column were already listed for column: ADD_ON_CASE_YN
99 PREOP_VISIT_NEED_YN VARCHAR No
Indicates if a PreOp Visit is needed.
The category values for this column were already listed for column: ADD_ON_CASE_YN
100 PREOP_VISIT_COMP_YN VARCHAR No
Indicates if PreOp Visit has been completed.
The category values for this column were already listed for column: ADD_ON_CASE_YN
101 LOG_ID VARCHAR No
This columns stores the log ID for this case.
102 CASE_ACCEPT_NEED_YN VARCHAR No
Stores whether the case accept programming point needs to be fired. Used when a case was created from a order to fire the accept programming points before the case can be scheduled.
The category values for this column were already listed for column: ADD_ON_CASE_YN
103 IS_CLINICAL_TRL_YN VARCHAR No
Indicates if the case is a clinical trial case.
The category values for this column were already listed for column: ADD_ON_CASE_YN
104 PEND_STATUS_C_NAME VARCHAR No
The status of a pending web request.
May contain organization-specific values: Yes
Category Entries:
Approve
Deny
More Info Required
105 POSTOP_DEST_C_NAME VARCHAR No
The patient's post-operative destination.
May contain organization-specific values: Yes
106 TRANSLATOR_C_NAME VARCHAR No
The category value of the language of the case translator.
May contain organization-specific values: Yes
107 PTA_LAST_UPD_DATE DATETIME No
Stores the date the procedure time was last updated in the case
108 CASE_BEGIN_INSTANT DATETIME (Local) No
Stores the datetime instant in which the case began.
109 CASE_END_INSTANT DATETIME (Local) No
Stores the datetime instant in which the case ended.
110 MULT_PROC_COMP_YN VARCHAR No
Indicates whether there were multiple procedures used in calculation of procedure time for this case.
The category values for this column were already listed for column: PREOP_XRAYS_YN
111 USING_EAP_YN VARCHAR No
This item defines whether this case is using the Procedure master file (EAP) for scheduling procedures? Default value is 'No'.
The category values for this column were already listed for column: ADD_ON_CASE_YN
112 ANESTHESIA_C_NAME VARCHAR No
The anesthesia type category number for the case.
May contain organization-specific values: Yes
113 CASE_SOURCE_DEPL_ID VARCHAR No
ID of the source deployment that created the case through cross deployment scheduling.
114 PRIMARY_PHYSICIAN_ID VARCHAR No
The primary surgeon from panel 1 of the case, as scheduled. This column is frequently used to link to CLARITY_SER.