OR_IMP_IMPLANT

Description:

The OR_IMP_IMPLANT table contains implantation information for implants that were marked as being implanted for a surgery or invasive procedure .

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 implant information for the implant.
3	IMPLANTED_DATE	DATETIME	No
	The date the implant was implanted.
4	IMPLANT_LOG_ID	VARCHAR	No
	The unique ID of the log in which the implant was implanted.
5	MANUF_NOTIFY_DATE	DATETIME	No
	The date the manufacturer was notified of the implantation of the implant.
6	IMPLANTED_TIME	DATETIME (Local)	No
	The time when the listed implant was marked as implanted.
7	IMP_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_IMPLANTED	INTEGER	No
	The number of items implanted.
9	IMPLANT_LOG_REF_IDENT	VARCHAR	No
	This item stores the reference ID of the implant surgical log used to generate this data.