OR_LNLG_IMPLANTS
Description:
This table contains the implants information for the surgical/invasive procedure 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 IMP_NO_INV_ITEM_YN VARCHAR No
Specifies if this implant has no inventory item specified.
May contain organization-specific values: No
Category Entries:
No
Yes
3 IMPLANT_ID VARCHAR No
The unique identifier for the implant record.
4 IMPLANT_ACTION_C_NAME VARCHAR No
The action taken on the implant.
May contain organization-specific values: Yes
Category Entries:
Implanted
Explanted
Wasted
Adjusted
5 IMPLANT_NUM_USED INTEGER No
The number of implants used.
6 IMPLANT_AREA_C_NAME VARCHAR No
The implant area category ID for the implant associated with the procedural log.
May contain organization-specific values: Yes
7 IMPLANT_LATERAL_C_NAME VARCHAR No
The laterality of the area.
May contain organization-specific values: Yes
Category Entries:
Left
Right
Bilateral
N/A
Default
8 IMPLANT_RSN_WSTD_C_NAME VARCHAR No
The reason why the implant was wasted.
May contain organization-specific values: Yes
9 IMPLANT_CREATED_YN VARCHAR No
Was the implant created in the log?
The category values for this column were already listed for column: IMP_NO_INV_ITEM_YN
10 IMP_TRAY_TYPE_C_NAME VARCHAR No
This item stores the instrument type of the implant tray.
May contain organization-specific values: Yes
11 IMP_TRAY_ID NUMERIC No
This item is populated if the current implant row is an implant tray, and stores the tray id.
12 IMP_TRAY_ID_RECORD_NAME VARCHAR No
Name of the implant tray
13 IMPLANT_FLASH_YN VARCHAR No
Indicates whether this implant has been flash-sterilized.
The category values for this column were already listed for column: IMP_NO_INV_ITEM_YN
14 FLSH_AUTCLVE_C_NAME VARCHAR No
The autoclave category number that was used to sterilize this implant.
May contain organization-specific values: Yes
No Entries Defined
15 FLSH_LOAD VARCHAR No
The load batch ID that this implant was flash sterilized in.
16 FLSH_RSN_C_NAME VARCHAR No
The category number of the reason that this implant was flash sterilized.
May contain organization-specific values: Yes
No Entries Defined
17 FLSH_VER_BY_ID VARCHAR No
The unique id of the staff member who was responsible for verifying that this implant was properly flash sterilized.
18 FLSH_RSLT_C_NAME VARCHAR No
The category number of the result of this implants flash sterilization process.
May contain organization-specific values: Yes
No Entries Defined
19 FLSH_PRE_RSN_C_NAME VARCHAR No
The category number of the reason this implant was pre-released in the flash sterilization process.
May contain organization-specific values: Yes
No Entries Defined