OR_LNLG_DIAGNOSIS

Description:

This table contains the Diagnosis information for the Surgical Log (ORL).

Primary Key

Column Name	Ordinal Position
RECORD_ID	1

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	VARCHAR	No
	The unique ID of the line record.
2	DX_ORP_ID	VARCHAR	No
	Procedure associated with this diagnosis.
3	DX_ORP_ID_PROC_NAME	VARCHAR	No
	The name of the surgical procedure record.
4	DX_LATERALITY_C_NAME	VARCHAR	No
	Laterality for the corresponding procedure in the diagnosis information May contain organization-specific values: Yes Category Entries: Left Right Bilateral N/A Default
5	DX_PRIMARY_DX_ID	NUMERIC	No
	The primary diagnosis associated with this procedure.
6	DX_PROC_PANEL	INTEGER	No
	The panel to which this procedure belongs
7	DX_CPT_CODE_2_ID	NUMERIC	No
	The second CPT(R) Code for this diagnosis
8	DX_CPT_CODE_3_ID	NUMERIC	No
	The third CPT(R) Code for this diagnosis
9	DX_QTY	INTEGER	No
	The quantity for this procedure-diagnosis combination.
10	DX_PROC_TYPE_C_NAME	VARCHAR	No
	The procedure type for this diagnosis May contain organization-specific values: Yes No Entries Defined