OR_CASE_IMP_TRAY

Description:

This table contains the implant trays information for the surgical case (ORC) record.

Primary Key

Column Name	Ordinal Position
CASE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CASE_ID	VARCHAR	No
	The unique ID of the procedural case record.
2	LINE	INTEGER	No
	The Line Count
3	IMP_TRAY_ID	NUMERIC	No
	Specifies the implant trays to be used in this surgery.
4	IMP_TRAY_ID_RECORD_NAME	VARCHAR	No
	Name of the implant tray
5	IMP_TRAY_DEFAULT_YN	VARCHAR	No
	Specifies whether this implant tray was defaulted by the system, or added/edited by the user. May contain organization-specific values: No Category Entries: No Yes
6	IMPL_TRAY_REQ_YN	VARCHAR	No
	Holds whether the implant tray is required May contain organization-specific values: No Category Entries: Yes No
7	IMP_TRAY_CMT	VARCHAR	No
	A free-text comment about an implant tray.