OR_IMP_ACCESSORIES

Description:

This table stores information about implant accessories.

Primary Key

Column Name	Ordinal Position
IMPLANT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	IMPLANT_ID	VARCHAR	No
	The unique identifier for the implant record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	IMP_ACCESSORY_EXPIRATION_DATE	DATETIME	No
	This column stores the expiration date for the implant accessory item.
4	IMP_ACCESSORY_TRACKING_NUMBER	VARCHAR	No
	This column stores the tracking number for the implant accessory item.
5	IMP_ACCESSORY_LOT_NUMBER	VARCHAR	No
	This item stores the lot number for the implant accessory item that is being documented.
6	IMP_ACCESSORY_SERIAL_NUMBER	VARCHAR	No
	This item stores the serial number for the implant accessory item that is being documented.
7	IMP_ACCESSORY_RECEIVED_DATE	DATETIME	No
	This item stores the date that the implant accessory item has been received by the patient.