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