OR_LNLG_GENERAL

Description: |
This table contains the general information about the surgical log line (ORM) record. This table also contains the information that can apply to several different types of surgical log line records.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | VARCHAR | No |
The unique ID associated with the line record for this row.
2 | RECORD_NAME | VARCHAR | No |
The name of the line record.
3 | RECORD_STATE_C_NAME | VARCHAR | No |
The status category number for the line record. A null status means that the record is active.
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
4 | PREALL_REC_TYPE_C_NAME | VARCHAR | No |
The pre-allocated record type category number for the line record.
May contain organization-specific values: No
Category Entries:
Pre-Allocated Record
Shell Record
5 | PREALLOCATED_LOG_ID | VARCHAR | No |
The surgical log to which this record has been pre-allocated. If record is in use or was pre-allocated by the pre-allocation process, this item will not be populated.
6 | ORM_REC_TYPE_C_NAME | VARCHAR | No |
The surgical log data type category number for the line record. For example, the types of data stored in line records include delays, staff, and equipment.
May contain organization-specific values: Yes
Category Entries:
Anesthesia Staff
Anesthesia Equipment
Additional Anesthesia Staff
Anesthesia Complications
Blood Info
Adverse Events
Complications
Delays
Staff
Equipment
Instruments
Pre-op Prep
Pre-op Skin
Tourniquet Info
Post-op Prep
Post-op Skin
Visitors
Other Equipment
Pre-surgery Events
Counts
Pre-op Appointments
Post-op Appointments
Patient Positioning
Diagnosis/Procedure Info
Electro-surgery Devices
SCD Devices
X-Ray Devices
Laser Devices
Warming Devices
Specimens
Medications
Catheters, Drains, Packings
Implants
Arrival Therapies
Anesthesia/Diagnosis Info
OR Billing History
LLM Surgical Procedure Suggestions
LLM Surgical Case Length Estimation
7 | MARKED_FOR_DEL_YN | VARCHAR | No |
Indicates whether the line record has been marked for deletion. Y indicates the record has been marked for deletion. A null value indicates that the record has not been marked for deletion. An N will not be populated for this column.
May contain organization-specific values: No
Category Entries:
No
Yes
8 | LOG_ID | VARCHAR | No |
ID of the log to which this ORM record belongs.
9 | PRESERVE_RECORD_YN | VARCHAR | No |
Determines whether the ORM resource needs to be preserved during rebuild since it has been documented in the log.
The category values for this column were already listed for column: MARKED_FOR_DEL_YN
10 | MAN_ENTERED_TM_SEC | NUMERIC | No |
The manually entered total time that a resource was used in seconds.
11 | LOANED_EQUIP_YN | VARCHAR | No |
Indicates if a particular piece of equipment is loaned or rented. Y indicates that the piece of equipment is loaned or rented. N indicates that the piece of equipment is not loaned or rented. A null value indicates that the line record is not any type of equipment or the value is not populated.
The category values for this column were already listed for column: MARKED_FOR_DEL_YN
12 | LOANED_EQUIP_ID | VARCHAR | No |
The ID of the loaned or rented piece of equipment that does not have a provider record in Epic.
13 | EQUIP_POSITION_DTTM | DATETIME (Local) | No |
The date and time a piece of equipment was positioned for use in a procedure.
14 | EQUIP_PRESSURE | NUMERIC | No |
General item for storing the recorded equipment pressure, e.g. as measured on a CO2 Insufflator.
15 | CASE_ID | VARCHAR | No |
The unique ID of the case whose log will contain this line of documentation.
16 | CREATED_EXTERNAL_YN | VARCHAR | No |
Indicates whether this line of log documentation was created in an external system.
The category values for this column were already listed for column: MARKED_FOR_DEL_YN
17 | PREP_AREA_MOD_C_NAME | VARCHAR | No |
This column displays the modifier for the prep area to allow a more discrete documentation of laterality.
May contain organization-specific values: Yes
No Entries Defined
18 | DEVICE_TEST_DTTM | DATETIME (UTC) | No |
Item to document time at which device was tested.
19 | TTL_DISSIPATD_ENRGY | NUMERIC | No |
The cumulative dissipated energy used by the equipment.
20 | EQUIP_FLOW_RATE | NUMERIC | No |
The flow rate for the equipment.
21 | EQUIP_TOTAL_ENERGY | NUMERIC | No |
The total energy used by the equipment.
22 | MAN_ENTERED_TM_MIN | INTEGER | No |
The total length of time the tourniquet was inflated (in minutes).
23 | DEFIB_NUM_APPLIED | INTEGER | No |
Stores the number of times the defibrillator was used on the patient.
24 | EQUIP_MEASURED_LEN | NUMERIC | No |
This item stores the length measured by a piece of equipment.
25 | FREQUENCY | INTEGER | No |
This column stores the equipment frequency.
26 | STAFF_NOTIFIED_DTTM | DATETIME (UTC) | No |
This item stores the time that staff were notified.
27 | BACKGROUND_READING | NUMERIC | No |
Reading of the background radiation
28 | FREQUENCY_AVERAGE | NUMERIC | No |
This item is to document the frequency average.