OR_LOG
Description:
The OR_LOG table contains information about surgical and procedural log (ORL) records.

Primary Key
Column Name Ordinal Position
LOG_ID 1

Column Information
Name Type Discontinued?
1 LOG_ID VARCHAR No
The unique ID of the procedural log record for this row.
2 SURGERY_DATE DATETIME No
The date on which the case was performed.
3 CASE_TYPE_C_NAME VARCHAR No
The category value which identifies the type of the surgical log.
May contain organization-specific values: Yes
4 CASE_CLASS_C_NAME VARCHAR No
The classification category ID for the surgical log.
May contain organization-specific values: Yes
5 TRAUMA_CASE_YN VARCHAR No
Yes/no flag which indicates whether this is a trauma case.
May contain organization-specific values: No
Category Entries:
Yes
No
6 PAT_ID VARCHAR No
The unique ID of the patient associated with the procedural log record.
7 POSTOP_CONSCIOUS_C_NAME VARCHAR No
The category value which represents the consciousness level of the patient during post-op.
May contain organization-specific values: Yes
8 PREOP_CONSCIOUS_C_NAME VARCHAR No
The category value which represents the consciousness level of the patient during pre-op.
The category values for this column were already listed for column: POSTOP_CONSCIOUS_C_NAME
9 PREOP_BED_ID VARCHAR No
The unique ID of the bed to which the patient is to be assigned for pre-op.
10 PREOP_BED_ID_BED_LABEL VARCHAR No
The name of the bed.
11 PACU_BED_ID VARCHAR No
The unique ID of the bed to which the patient is to be assigned for post-op.
12 PACU_BED_ID_BED_LABEL VARCHAR No
The name of the bed.
13 NUM_OF_PANELS INTEGER No
The number of panels in the surgical log.
14 REQUEST_PERSON VARCHAR No
The name of the person requesting the surgery
15 TOTAL_TIME_NEEDED INTEGER No
The total time needed for the log in minutes
16 REFER_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.
17 PAT_PREOP_COND_C_NAME VARCHAR No
The category value which indicates the patient's condition before the surgery in the surgical log.
May contain organization-specific values: Yes
18 PAT_POSTOP_COND_C_NAME VARCHAR No
The category value which indicates the patient's condition after the surgery in the surgical log.
May contain organization-specific values: Yes
19 ASA_RATING_C_NAME VARCHAR No
The patient's ASA rating category number for the procedure. ASA stands for American Society of Anesthesiologists. This column is frequently used to link to ZC_OR_ASA_RATING.
May contain organization-specific values: Yes
20 DISCHARGE_TO_C_NAME VARCHAR No
The category list which indicates where the patient was discharged to in the surgical log.
May contain organization-specific values: Yes
21 DISPOSITION_TIME DATETIME (Local) No
The time at which the patient was discharged. NOTE: Only the time value of this field is to be used. The date should always be 1/1/1900 for historical reasons.
22 EXPIRED_YN VARCHAR No
Yes/no flag which indicates whether the patient died during the surgery.
The category values for this column were already listed for column: TRAUMA_CASE_YN
23 EXPIRED_WHERE_C_NAME VARCHAR No
If needed, indicates where the patient expired.
May contain organization-specific values: Yes
24 EXPIRED_TIME DATETIME (Local) No
If needed, records the time at which the patient expired
25 X_RAYS_TAKEN_YN VARCHAR No
Yes/no flag which indicates whether X-rays were taken in the surgical log.
The category values for this column were already listed for column: TRAUMA_CASE_YN
26 PREOP_XRAYS_YN VARCHAR No
Yes/no flag which indicates whether pre-op X-rays were taken in the surgical log.
The category values for this column were already listed for column: TRAUMA_CASE_YN
27 PREOP_VISIT_YN VARCHAR No
Yes/no flag which indicates whether there was a pre-Op Visit for the surgical log.
The category values for this column were already listed for column: TRAUMA_CASE_YN
28 LATEX_ALLERGIC_YN VARCHAR No
Yes/no flag which indicates for the surgical log if the patient has a latex allergy.
The category values for this column were already listed for column: TRAUMA_CASE_YN
29 EST_BLOOD_LOSS NUMERIC No
The estimated amount of blood lost during the surgery.
30 ROOM_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.
31 LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
32 PRIORITY_C_NAME VARCHAR No
The category list which represents the priority of the surgical log
May contain organization-specific values: No
Category Entries:
Low
Normal
High
33 STATUS_C_NAME VARCHAR No
The category ID for the log status (Posted, Unposted, Voided, etc.) associated with the log record. This column is frequently used to link to ZC_OR_STATUS.
May contain organization-specific values: Yes
Category Entries:
Missing Information
Posted
Unposted
Voided
Completed
Canceled
34 SERVICE_C_NAME VARCHAR No
The service category ID for the surgical log.
May contain organization-specific values: Yes
35 SCHED_START_TIME DATETIME (Local) No
The date and time at which the surgery in the surgical log was performed.
36 VOID_REASON_C_NAME VARCHAR No
A category list which indicates the reason the log was voided. It is entered by the user that voided that log.
May contain organization-specific values: Yes
37 CHECKIN_INSTANT DATETIME (Local) No
The date and time at which the log was checked-in.
38 PATIENT_ESCORT VARCHAR No
The person escorting the patient for the surgery. This is a free text value.
39 CASE_REQUEST_ID VARCHAR No
The unique ID of the surgical case attached to this log.
40 RECORD_CREATE_DATE DATETIME No
The creation date of this surgical log.
41 RESEARCH_IND_C_NAME VARCHAR No
The category value which represents the candidacy of the surgical log for research.
May contain organization-specific values: Yes
42 PACU1_LOC_C_NAME VARCHAR No
The category value which represents the patient's location in the PACU.
May contain organization-specific values: Yes
43 REASON_OVER_C_NAME VARCHAR No
The category value which represents the reason for overnight stay.
May contain organization-specific values: Yes
44 POSTOP_DEST_C_NAME VARCHAR No
The category value which represents the patient's post-op destination.
May contain organization-specific values: Yes
45 IS_CONFIDENTIAL_YN VARCHAR No
Yes/No flag which indicates whether the log is confidential or not (yes indicates confidential).
May contain organization-specific values: No
Category Entries:
No
Yes
46 ADDENDA_COUNT INTEGER No
The number of addenda on posted logs. This will return the number of addenda on the log if the log status is posted, otherwise, returns null.
47 PATIENT_ID_VERB_YN VARCHAR No
Yes/No value indicating whether or not the patient was identified verbally.
The category values for this column were already listed for column: TRAUMA_CASE_YN
48 PAT_HAS_ID_BAND_YN VARCHAR No
Yes/No value indicating whether or not the patient has an ID band.
The category values for this column were already listed for column: TRAUMA_CASE_YN
49 PAT_BLOOD_BAND_YN VARCHAR No
Yes/No value indicating whether or not the patient has a blood band.
The category values for this column were already listed for column: TRAUMA_CASE_YN
50 BLOOD_BAND_NUMBER VARCHAR No
The number of the patient's blood band.
51 DESTINATION VARCHAR No
The free text destination of the other report.
52 INTRAOP_DISCH_TO_C_NAME VARCHAR No
The category value which indicates to where the patient was discharged.
May contain organization-specific values: Yes
53 SURGEON_COST NUMERIC No
The cost associated with the surgeons. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
54 ANES_STAFF_COST NUMERIC No
The cost associated with the anesthesia staff. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
55 OR_COST NUMERIC No
The cost associated with the operating room. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
56 SURG_STAFF_COST NUMERIC No
The cost associated with the surgical staff. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
57 SURG_EQUIP_COST NUMERIC No
The cost associated with the surgical equipment. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
58 ANES_EQUIP_COST NUMERIC No
The cost associated with the anesthesia equipment. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
59 INSTR_COST NUMERIC No
The cost associated with the surgical instruments. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
60 PROC_COST NUMERIC No
The cost associated with the procedures. The item from which this column extracts is no longer populated in released workflows, but may include historical data.
61 VOID_COMMENTS VARCHAR No
The free text comments entered when the log was voided.
62 LOG_ACCEPTED_YN VARCHAR No
Yes/No flag indicating whether or not the log was accepted in Log Entry.
The category values for this column were already listed for column: TRAUMA_CASE_YN
63 PROC_LEVEL_C_NAME VARCHAR No
Level of the procedure for the log.
May contain organization-specific values: Yes
64 OR_TIME_EVTS_ENT_C_NAME VARCHAR No
Indicates the timing events status of the case. This is used to see if the case is not started, in progress or done.
May contain organization-specific values: No
Category Entries:
Not Started
In Progress
Completed
65 PROC_NOT_PERF_C_NAME VARCHAR No
The category number for the reason why the procedure was not performed.
May contain organization-specific values: Yes
Category Entries:
Procedure Aborted
66 PROC_NOT_PERF_COM VARCHAR No
Stores the comments, if the procedure not performed.
67 LOG_TYPE_C_NAME VARCHAR No
The type of log category number for the log.
May contain organization-specific values: No
Category Entries:
Surgical Log
Procedure Log
68 PHASE_TWO_BED_ID VARCHAR No
The unique ID of the bed to which the patient is to be assigned for Post-Op Phase II.
69 PHASE_TWO_BED_ID_BED_LABEL VARCHAR No
The name of the bed.
70 CASE_ID VARCHAR No
This column stores the case ID (ORC) for this log.
71 IS_CLINICAL_TRL_YN VARCHAR No
Indicates if the log is a clinical trial log.
The category values for this column were already listed for column: IS_CONFIDENTIAL_YN
72 BLOOD_LOSS_UNIT_C_NAME VARCHAR No
Unit of measure of blood loss.
May contain organization-specific values: Yes
73 SCHED_INSTR_EDIT_YN VARCHAR No
Stores whether the scheduling instructions were edited.
The category values for this column were already listed for column: IS_CONFIDENTIAL_YN
74 PAT_INSTR_EDITED_YN VARCHAR No
Stores whether the patient instructions were edited.
The category values for this column were already listed for column: IS_CONFIDENTIAL_YN
75 NURSE_NOTES_EDIT_YN VARCHAR No
Stores whether the nursing notes have been edited.
The category values for this column were already listed for column: IS_CONFIDENTIAL_YN
76 POSITION_NOTES_E_YN VARCHAR No
Stores whether the positioning notes have been edited.
The category values for this column were already listed for column: IS_CONFIDENTIAL_YN
77 EMERG_STATUS_YN VARCHAR No
Indicates whether there is an emergency status for this log. If the log does have an emergency status, this column will display Y. The column will display N if there is not an emergency status and null if the status was not set.
The category values for this column were already listed for column: TRAUMA_CASE_YN
78 IS_JOINT_RVSN_YN VARCHAR No
This item documents whether the log is for a revision of a joint procedure. It is used for Surgical Care Improvement Project (SCIP) reports.
The category values for this column were already listed for column: IS_CONFIDENTIAL_YN
79 RECORD_STATUS_C_NAME VARCHAR No
The record status category number for this log.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Deleted
Inactive and Deleted
Hidden
Inactive and Hidden
Deleted and Hidden
Inactive Deleted and Hidden
80 FORM_ID_COUNTER INTEGER No
Annotated images form ID counter.
81 CHRGS_AT_ADDEND_YN VARCHAR No
This item is populated as Yes or No when an addendum is filed, or when log charges are calculated, to indicate whether there are charges to be sent. This item will be set to 1-Yes if there are any new charges, charges to be updated, or charges to be cancelled, or if there are any charge errors or warnings. Otherwise, this item will be set to 2-No. If this item is blank, the log charges will be calculated on the fly by the Log Charges Work List to evaluate whether to include the log in the report.
The category values for this column were already listed for column: IS_CONFIDENTIAL_YN
82 PRIMARY_PHYS_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.