OR_LOG_DIAG_CODES

Description:

The OR_LOG_DIAG_CODES table contains OR management system log diagnosis codes.

Primary Key

Column Name	Ordinal Position
LOG_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	LOG_ID	VARCHAR	No
	The unique ID of the surgical log of the surgery that the diagnosis refers to.
2	LINE	INTEGER	No
	The number of the line of the diagnosis in the surgical log.
3	DX_CODES_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.
4	DIAG_ASSOC_YN	VARCHAR	No
	A yes/no flag indicating whether the diagnosis is associated in the surgical log. May contain organization-specific values: No Category Entries: Yes No
5	DIAGNOSIS_PROC_ID	VARCHAR	No
	The unique ID of the diagnosis attached to the procedure in the log.
6	DIAGNOSIS_PROC_ID_PROC_NAME	VARCHAR	No
	The name of the surgical procedure record.
7	DIAGNOSIS_PANEL	INTEGER	No
	The number of the panel for the procedure.
8	PRIMARY_DX_YN	VARCHAR	No
	Yes/No flag indicating whether or not this diagnosis is the primary diagnosis. May contain organization-specific values: No Category Entries: No Yes