OR_LNLG_IMP_TRAYCM
Description:
This table contains the Implant Tray Component information for the Surgical Log (ORL).

Primary Key
Column Name Ordinal Position
RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 RECORD_ID VARCHAR No
The unique ID of the line record.
2 LINE INTEGER No
The line number of the component record
3 TRAY_COMP_ORIG_NUM INTEGER No
This item stores the original number of components of this inventory item type which were present in the tray.
4 TRAY_COMP_SUP_KEY VARCHAR No
This item stores a key containing the unique tray number and inventory item.
5 TRAY_COMP_ORM_ID VARCHAR No
The pointer to the implant row record for this tray component.