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 NUM_OF_PANELS INTEGER No
The number of panels in the surgical log.
8 REQUEST_PERSON VARCHAR No
The name of the person requesting the surgery
9 TOTAL_TIME_NEEDED INTEGER No
The total time needed for the log in minutes
10 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.
11 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
12 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.
13 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
14 EXPIRED_WHERE_C_NAME VARCHAR No
If needed, indicates where the patient expired.
May contain organization-specific values: Yes
15 EXPIRED_TIME DATETIME (Local) No
If needed, records the time at which the patient expired
16 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
17 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
18 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
19 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
20 EST_BLOOD_LOSS NUMERIC No
The estimated amount of blood lost during the surgery.
21 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.
22 LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
23 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
24 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
25 SERVICE_C_NAME VARCHAR No
The service category ID for the surgical log.
May contain organization-specific values: Yes
26 SCHED_START_TIME DATETIME (Local) No
The date and time at which the surgery in the surgical log was performed.
27 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
28 CHECKIN_INSTANT DATETIME (Local) No
The date and time at which the log was checked-in.
29 PATIENT_ESCORT VARCHAR No
The person escorting the patient for the surgery. This is a free text value.
30 CASE_REQUEST_ID VARCHAR No
The unique ID of the surgical case attached to this log.
31 RECORD_CREATE_DATE DATETIME No
The creation date of this surgical log.
32 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
33 PACU1_LOC_C_NAME VARCHAR No
The category value which represents the patient's location in the PACU.
May contain organization-specific values: Yes
34 REASON_OVER_C_NAME VARCHAR No
The category value which represents the reason for overnight stay.
May contain organization-specific values: Yes
35 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
36 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.
37 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
38 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
39 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
40 BLOOD_BAND_NUMBER VARCHAR No
The number of the patient's blood band.
41 INTRAOP_DISCH_TO_C_NAME VARCHAR No
The category value which indicates to where the patient was discharged.
May contain organization-specific values: Yes
42 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.
43 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.
44 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.
45 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.
46 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.
47 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.
48 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.
49 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.
50 VOID_COMMENTS VARCHAR No
The free text comments entered when the log was voided.
51 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
52 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
53 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
54 PROC_NOT_PERF_COM VARCHAR No
Stores the comments, if the procedure not performed.
55 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
56 CASE_ID VARCHAR No
This column stores the case ID (ORC) for this log.
57 BLOOD_LOSS_UNIT_C_NAME VARCHAR No
Unit of measure of blood loss.
May contain organization-specific values: Yes
58 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
59 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
60 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
61 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
62 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
63 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
64 FORM_ID_COUNTER INTEGER No
Annotated images form ID counter.
65 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
66 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.