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