OR_CASE_2
Description:
The OR_CASE_2 table enables you to report on surgical and procedural case data. This table has the same basic structure as OR_CASE, but was created as a second table to prevent OR_CASE 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 ID for the case request record.
2 SURGICAL_RISK_C_NAME VARCHAR No
The surgical risk level category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
3 POTENTL_BLOODLOSS_C_NAME VARCHAR No
The potential blood loss category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
4 AWARENESS_DT DATETIME No
This column contains the date the patient was made aware of the surgery in the case record.
5 READY_TO_SCHED_C_NAME VARCHAR No
The ready to schedule category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
6 SURGEON_REQ_LEN INTEGER No
This column contains the surgeon requested length for the case in the case record.
7 PAT_PAGER_NUM VARCHAR No
This column contains the patient pager number assigned in the case record.
8 SPEC_NEED_RESOLV_DT DATETIME No
This column contains the date special needs were resolved in the case record.
9 AUTH_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
10 PAT_START_TIME DATETIME (Local) No
Shows the time the patient is scheduled to arrive at the OR.
11 OB_CSECT_TYPE_C_NAME VARCHAR No
The c-section type category ID for the surgical case.
May contain organization-specific values: Yes
12 CASE_PULLED_C_NAME VARCHAR No
The case picking status category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
13 RSN_RETURN_OR_C_NAME VARCHAR No
The reason why a patient returns to the OR category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
14 INTER_BETWEEN_CASES INTEGER No
The number of days that should be between two cases.
15 PAT_FIRST_AVAIL_DT DATETIME No
The date the patient is first available for surgery.
16 PAT_COMPLEXITY_C_NAME VARCHAR No
The patient complexity category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
17 ANES_APPROVAL_DATE DATETIME No
The date anesthesia was approved.
18 APPROX_HEIGHT NUMERIC No
The approximate height of the patient in inches.
19 INS_SELF_PAY_YN VARCHAR No
This item contains whether the patient's insurance is self-pay.
May contain organization-specific values: No
Category Entries:
No
Yes
20 PRE_OP_BED_ID VARCHAR No
The patient's pre-op bed can be entered in the case, prior to their arrival.
21 PRE_OP_BED_ID_BED_LABEL VARCHAR No
The name of the bed.
22 INTRAOP_XRAYS_CMT VARCHAR No
This column displays the comment about intraop x-ray needs in a case.
23 TRANSLATN_NEEDS_CMT VARCHAR No
This column displays the comment about translation needs in a case.
24 LASER_NEEDS_COMMENT VARCHAR No
This column displays the comment about specific laser needs in a case.
25 READY_TO_SCHED_DTTM DATETIME (Local) No
This column displays the date and time that a case was marked as ready to schedule in order to help end-users prioritize cases when scheduling.
26 IOP_XRAYS_C_NAME VARCHAR No
The intraop x-rays needed category ID for the surgical case.
May contain organization-specific values: Yes
Category Entries:
Yes
No
27 ARE_PROPH_AB_REQ_C_NAME VARCHAR No
The prophylactic antibiotics required category ID for the surgical case.
May contain organization-specific values: Yes
Category Entries:
Yes
No
28 PAT_SCHED_NOTICE INTEGER No
Store number of days notice patient needs before surgery.
29 CLASS_APPROP_C_NAME VARCHAR No
The case classification appropriateness category ID for the surgical case.
May contain organization-specific values: Yes
Category Entries:
Yes
No
30 REVISD_CASE_CLASS_C_NAME VARCHAR No
The revised case classification category ID for the surgical case.
May contain organization-specific values: Yes
31 PREOP_VISIT_STAT_C_NAME VARCHAR No
The pre-op visit status category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
32 ADMIT_TYPE_C_NAME VARCHAR No
The admit type category ID for the surgical case.
May contain organization-specific values: Yes
33 CANCELED_AT_LAST_MINUTE_YN VARCHAR No
Indicates whether the case was canceled for a non-clinical reason at the last minute (i.e., on the day of surgery or on the day of admission).
May contain organization-specific values: No
Category Entries:
Yes
No
34 CANCEL_TARGET_DT DATETIME No
Stores the target date associated with the last minute canceled case. The target date is the date by which the last minute canceled case should be rescheduled to avoid a breach.
35 IGNORE_TARGET_DATE_YN VARCHAR No
Stores whether the target date for rescheduling a case should be ignored. If this item is set to Yes, the case will be ignored when reporting on target date breaches for last minute canceled cases.
The category values for this column were already listed for column: CANCELED_AT_LAST_MINUTE_YN
36 IGNORE_TARGET_DATE_REASON_C_NAME VARCHAR No
The category ID of the last minute cancel reason for ignoring the target date for the surgical case. The target date is the date by which the last minute canceled case should be rescheduled to avoid a breach.
May contain organization-specific values: Yes
No Entries Defined
37 TARGET_IGNORE_SET_BY_USER_ID VARCHAR No
Stores the ID of the user who flags the last minute canceled case to ignore the target date. The target date is the date by which the last minute canceled case should be rescheduled to avoid a breach.
38 TARGET_IGNORE_SET_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
39 LAST_MIN_CANC_ORIGINAL_SURG_DT DATETIME No
Stores the original surgery date associated with the last minute canceled case. Original surgery date is the scheduled surgery date when the case is canceled at the last minute for the first time.
40 IN_OR_TO_PROC_LEN INTEGER No
Records the estimated time to prep the patient from the time wheeled into the room until the procedure starts.
41 CLOSE_TO_OUT_OR_LEN INTEGER No
Records the estimated time between the procedure ending and the patient being wheeled out of the room.
42 POSTOP_BED1_TYPE_C_NAME VARCHAR No
The first post-op bed category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
43 POSTOP_BED1_DAYS_NEEDED INTEGER No
The length in days the first post-op bed will be needed.
44 POSTOP_BED1_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
45 POSTOP_BED2_TYPE_C_NAME VARCHAR No
The second post-op bed category ID for the surgical case.
The category values for this column were already listed for column: POSTOP_BED1_TYPE_C_NAME
46 POSTOP_BED2_DAYS_NEEDED INTEGER No
The length in days the second post-op bed will be needed.
47 POSTOP_BED2_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
48 CUSTOM_STATUS_C_NAME VARCHAR No
The custom status category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
49 FOLLOWUP_APPT_DTTM DATETIME (Local) No
This item stores the time and date of a patient's post surgical follow-up appointment.
50 WTIS_DX_CAT_C_NAME VARCHAR No
The WTIS diagnosis category ID for the surgical case.
May contain organization-specific values: Yes
51 WTIS_INTENT_SURGERY_C_NAME VARCHAR No
The WTIS intent of surgery category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
52 WTIS_PEDIATRIC_YN VARCHAR No
This item determines whether or not a case is considered pediatric for WTIS purposes. This item is only respected if the patient's age is between 18 and 23 as of the Decision to Treat Date (I ORC 8001). If a patient is under 18 the case will always be considered pediatric. If the patient is over 23 the case will never be considered pediatric.
The category values for this column were already listed for column: INS_SELF_PAY_YN
53 WTIS_SERVICE_AREA_C_NAME VARCHAR No
The WTIS service area category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
54 WTIS_SERVICE_DETAIL_1_C_NAME VARCHAR No
The WTIS service detail 1 category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
55 WTIS_SERVICE_DETAIL_2_C_NAME VARCHAR No
The WTIS service detail 2 category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
56 WTIS_PROC_CODE VARCHAR No
This item contains the full WTIS procedure code for a case.
57 WTIS_WAIT_LIST_ID VARCHAR No
Stores the wait list ID of the WTIS wait list for the case. This item is automatically generated by the system based on the case ID. The wait list ID is in the format <case ID> or <case ID>.<unique number>.
58 WTIS_WAIT_LIST_CREATED_YN VARCHAR No
Stores whether the WTIS create wait list message was already sent for the case. This is used by interfaces to suppress sending other update messages for the case, if the create message has not been sent yet.
The category values for this column were already listed for column: INS_SELF_PAY_YN
59 PREOP_REQUESTED_VISIT_DTTM DATETIME (UTC) No
This column stores the date/time for the requested pre-op visit.
60 GRAVIDITY INTEGER No
The number of times the patient has been pregnant.
61 PARITY INTEGER No
The number of pregnancies the patient has carried to viable gestational age.
62 DESIRED_DTTM DATETIME (UTC) No
The desired date and time to schedule the patient's planned C-section.
63 EST_DUE_DATE DATETIME No
The expected date of delivery/estimated date of confinement.
64 DESIRED_DATE_GEST_AGE NUMERIC No
The gestational age, in weeks, of the baby at the time of the desired date of the patient's planned C-section.
65 WTIS_CODE_PROC_C_NAME VARCHAR No
The Wait Time Information System (WTIS) procedure code category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
66 SERVICE_TARGET_EFFORT_YN VARCHAR No
Flag to indicate that additional effort was needed on behalf of staff to work this encounter in order to meet service targets.
The category values for this column were already listed for column: INS_SELF_PAY_YN
67 P_CATS_CODE_C_NAME VARCHAR No
The Pediatric Canadian Access Targets for Surgery (P-CATS) diagnosis code category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
68 EXPECTED_ADMISSION_TIME DATETIME (Local) No
This item stores the time the patient is expected to be admitted for surgery, as documented in the surgical case in I ORC 7617 - EXPECTED ADMISSION TIME. Column PAT_ENC_HSP__EXP_ADMISSION_TIME should be used to report on the expected admission date and time for the admission linked to the surgery (I EPT 10301 - EXPECTED ADMISSION DATE and I EPT 10300 - EXPECTED ADMISSION TIME). If a time is set in I ORC 7617, the expected admission time in the linked admission is set to that time. If I ORC 7617 is not set, the expected admission time in the linked admission is calculated as the scheduled surgery time (OR_CASE__TIME_SCHEDULED) minus the number of hours in OR_CASE_2__EXPECTED_ADMISSION_TIME_OFFSET. If multiple cases are linked to the same admission, the earliest time from the list of linked cases will be set as the expected admission time on the linked admission.
69 OPERATION_INTENTION_C_NAME VARCHAR No
The operation intention category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
70 TRIAGE_SCORE INTEGER No
Stores a triage score for the case. This information would be obtained from a third-party.
71 REGISTRY_SCORE INTEGER No
Stores a registry score for the case. This information would be obtained from a third-party.
72 ACATS_CODE_C_NAME VARCHAR No
The Adult Coding Access Targets for Surgery (ACATS) code diagnosis category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
73 EXTERNAL_STATUS_C_NAME VARCHAR No
The external systems case status category ID for the surgical case.
May contain organization-specific values: Yes
No Entries Defined
74 PREP_TIME_MOD_YN VARCHAR No
Has patient prep time been modified by user
The category values for this column were already listed for column: INS_SELF_PAY_YN
75 POSTOP_LEVEL_OF_CARE_C_NAME VARCHAR No
The planned post-op level of care category ID for the surgical case.
May contain organization-specific values: Yes
76 CASE_ACCESS_UTC_DTTM DATETIME (UTC) No
Date and time of the last time case entry was opened.
77 RECORD_STATUS_C_NAME VARCHAR No
Record status flag. Used in conjunction with record archived flag for encounter archiving.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
78 CLASS_REVIEW_DATE DATETIME No
The most recent time clinical prioritization was reviewed.
79 CLINICAL_SAFE_DATE DATETIME No
How long clinical prioritization is valid.
80 NHSN_TRAUMA_ORC_YN VARCHAR No
This is used to indicate whether the case qualifies as an NHSN trauma case (blunt or penetrating injury).
The category values for this column were already listed for column: INS_SELF_PAY_YN
81 TRAUMA_CASE_ORC_YN VARCHAR No
This is used to indicate whether the case should be classified as a trauma case.
The category values for this column were already listed for column: CANCELED_AT_LAST_MINUTE_YN
82 NHSN_EMERG_ORC_YN VARCHAR No
This is used to indicated whether the case qualifies as an NHSN emergency case (unplanned or unscheduled).
The category values for this column were already listed for column: INS_SELF_PAY_YN
83 CENTRAL_INTAKE_NUMBER VARCHAR No
This stores the Central Intake Number also called RAC number.
84 CASE_VERIFIED_C_NAME VARCHAR No
Whether the case has been verified.
May contain organization-specific values: Yes
Category Entries:
No
Yes