|
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 |
|
|
|
|
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_PROV_NAME |
VARCHAR |
No |
|
|
|
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
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 |
|
|