OR_LNLG_OTH_EQUIP
Description:
This table contains the Other Equipment information for the procedural log.

Primary Key
Column Name Ordinal Position
RECORD_ID 1

Column Information
Name Type Discontinued?
1 RECORD_ID VARCHAR No
The unique ID of the line record.
2 OTHER_EQUIP_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.
3 OTHER_EQUIP_SET_T_NAME VARCHAR No
The setting type for the other equipment.
May contain organization-specific values: Yes
4 OTHER_EQUIP_SET_HI NUMERIC No
The high setting for the equipment.
5 OTHER_EQUIP_SET_LO NUMERIC No
The low setting for the equipment
6 OTH_EQUIP_TYPE_C_NAME VARCHAR No
The type of the other equipment.
May contain organization-specific values: Yes
7 HYST_PUMP_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.
8 HYST_PUMP_PRESSURE NUMERIC No
The pressure setting (mmHg) for the hysteroscopy pump.
9 HYST_PUMP_DEFICIT NUMERIC No
The deficit setting (mL) for the hysteroscopy pump.
10 HYST_PUMP_T_INFLOW NUMERIC No
The total inflow setting (mL) for the hysteroscopy pump.
11 LAP_SCN_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.
12 CELL_SAVER_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.
13 CELL_SAVER_NUM VARCHAR No
The numeric or alphanumeric identifier for the cell saver machine.
14 HYST_PUMP_ALM_SE_YN VARCHAR No
Indicates whether the hysteroscopy pump alarm settings are within limits. Y indicates that the alarm settings are within limits. N indicates that the alarm settings are not within limits.
May contain organization-specific values: No
Category Entries:
No
Yes
15 LAP_SCN_PRERD_C_NAME VARCHAR No
The category title of the pre-op reading (intact/compromised/NA) for the laparoscopic instrument scan.
May contain organization-specific values: Yes
Category Entries:
Intact
Compromised
N/A
16 LAP_SCN_POSTRD_C_NAME VARCHAR No
The category title of the post-op reading (intact/compromised/NA) for the laparoscopic instrument scan.
The category values for this column were already listed for column: LAP_SCN_PRERD_C_NAME
17 OTHER_EQUIP_LAT_C_NAME VARCHAR No
This item stores laterality for other equipment.
May contain organization-specific values: Yes
Category Entries:
Left
Right
Bilateral
N/A
Default
18 OTHER_EQUIP_CAV_WID NUMERIC No
Document the cavity width measurement, as measured by other equipment type.
19 OTHER_EQUIP_CAV_LEN NUMERIC No
Document the cavity length measurement, as measured by other equipment type.
20 OTHER_EQUIP_PWR_LOW INTEGER No
Document the low power for other equipment type.
21 OTHER_EQUIP_PWR_HI INTEGER No
Document the high power for other equipment type.
22 OTH_EQUIP_PWR_UNI_C_NAME VARCHAR No
Document the power unit for other equipment type.
May contain organization-specific values: Yes
No Entries Defined
23 HYST_PUMP_T_OUTFLOW NUMERIC No
The total outflow setting (mL) for the hysteroscopy pump.
24 CELL_SVR_VOL_PROC INTEGER No
This column contains information about the number of milliliters of blood processed during surgery.
25 CELL_SVR_VOL_REINFU INTEGER No
This column contains information about the number of milliliters of blood reinfused during surgery.
26 NUMBER_OF_CYCLES INTEGER No
This item stores the number of cycles setting for a piece of ablation equipment.
27 NUMBER_OF_SITES INTEGER No
This item stores the number of ablation sites to which this piece of equipment was applied.
28 TEMPERATURE NUMERIC No
This item stores the temperature for a piece of ablation equipment.
29 OTHER_EQUIP_VOLUME NUMERIC No
This item stores the volume, as measured by other equipment type.
30 OTHER_EQUIP_SER_NUM NUMERIC No
This item stores the serial number of other equipment type.
31 AVERAGE_POWER NUMERIC No
The average power used.
32 OTHER_EQUIP_SOUNDING_LEN NUMERIC No
This column stores the sounding length measurement in centimeters, as measured by a piece of equipment.
33 OTHER_EQUIP_SETTING_ADDITIONAL NUMERIC No
This column stores additional equipment settings.
34 CELL_SVR_VOL_NOT_PROCESSED INTEGER No
The milliliters of blood not processed.
35 CELL_SVR_VOL_WASTED INTEGER No
The milliliters of blood wasted.
36 CELL_SVR_IRRIGATION_VOL NUMERIC No
This column stores the Irrigation volume used for cell saver.
37 CELL_SVR_ANTICOAG_VOL NUMERIC No
This column stores the anti-coagulant volume used for cell saver.
38 IMPLANT_ON_CART_YN VARCHAR No
If there was an implant not on the cart. Used for comprehensive steam sterilization (IUSS) documentation.
The category values for this column were already listed for column: HYST_PUMP_ALM_SE_YN