OR_IMP_EXPLANT

Description: |
The OR_IMP_EXPLANT table contains OR management system explant information for implants.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
IMPLANT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | IMPLANT_ID | VARCHAR | No |
The unique ID of the implant record.
2 | LINE | INTEGER | No |
The number of the line of the explant information for the implant.
3 | EXPLANTED_DATE | DATETIME | No |
The date the implant was explanted.
4 | EXPLANT_LOG_ID | VARCHAR | No |
The unique ID of the log in which the implant was explanted.
5 | EXPL_MANF_NOTF_DT | DATETIME | No |
The date the manufacturer was notified that the implant was explanted.
6 | EXPLANTED_TIME | DATETIME (Local) | No |
The time when implant was explanted.
7 | EXPLANT_STAFF_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 | NUM_EXPLANTED | INTEGER | No |
The number of items that were explanted.