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
Unspecified
5 | DX_PRIMARY_DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
6 | DX_PROC_PANEL | INTEGER | No |
The panel to which this procedure belongs
7 | DX_CPT_CODE_2_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
8 | DX_CPT_CODE_3_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
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