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