OR_LNLG_INSTRUMENT
Description:
This table contains the Instruments information for the Surgical Log (ORL).

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 INSTRUMENT_TYPE_C_NAME VARCHAR No
The instrument type.
May contain organization-specific values: Yes
3 INSTRUMENT_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.
4 INSTRUMENT_FLASH_YN VARCHAR No
This item stores whether or not an instrument has been flash-sterilized.
May contain organization-specific values: No
Category Entries:
No
Yes
5 FLSH_AUTCLVE_C_NAME VARCHAR No
The autoclave category number that was used to sterilize this instrument.
May contain organization-specific values: Yes
No Entries Defined
6 FLSH_LOAD VARCHAR No
The load batch ID that this instrument was flash sterilized in.
7 FLSH_RSN_C_NAME VARCHAR No
The category number of the reason that this instrument was flash sterilized.
May contain organization-specific values: Yes
No Entries Defined
8 FLSH_VER_BY_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.
9 FLSH_RSLT_C_NAME VARCHAR No
The category number of the result of this instruments flash sterilization process.
May contain organization-specific values: Yes
No Entries Defined
10 FLSH_PRE_RSN_C_NAME VARCHAR No
The category number of the reason this instrument was pre-released in the flash sterilization process.
May contain organization-specific values: Yes
No Entries Defined
11 FLSH_CYCLE_TYPE_C_NAME VARCHAR No
The category number of the cycle type of the flash autoclave.
May contain organization-specific values: Yes
No Entries Defined
12 FLSH_AUTCLVE_TEMP NUMERIC No
The category number of the temperature of the flash autoclave.
13 FLSH_AUTCLVE_PRES NUMERIC No
The category number of the pressure of the flash autoclave.
14 FLSH_PRES_UNIT_C_NAME VARCHAR No
The category number of the unit of pressure of the flash autoclave.
May contain organization-specific values: No
Category Entries:
Pascal
KiloPascal
Kilogram force/square centimeter
PSI
Bar
Atmosphere
15 FLSH_DURATION VARCHAR No
The duration of time (in minutes) an item was flash sterilized.
16 FLSH_DATE DATETIME No
This item stores the date an instrument was sterilized.
17 FLSH_TIME DATETIME (Attached) No
This item stores the time an instrument was sterilized.
18 FLSH_BIOL_RSLT_TIME DATETIME (Attached) No
This item stores the time a biological growth test was performed for sterile implants.
19 INSTR_BARCODE_ID VARCHAR No
This item is used to document an instrument's barcode ID.
20 FLSH_BIOL_RSLT_USER_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.
21 STERILIZATION_REFERENCE_NUM INTEGER No
The sterilization reference number.
22 STERILIZATION_EXP_DATE DATETIME No
This item is used to store the sterilization expiration date of the equipment or instrument.