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