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