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