CLM_DX

Description: |
All values associated with a claim are stored in the Claim External Value record. The CLM_DX table holds the diagnoses for the claim.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | NUMERIC | No |
The unique identifier for the Claim Info record.
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | CLM_DX_QUAL | VARCHAR | No |
This item holds the qualifier identifying the code set for the claim diagnoses.
4 | CLM_DX | VARCHAR | No |
This item holds the diagnoses for the claim. The principal diagnosis is stored on the first line and the other diagnoses are on subsequent lines.
5 | CLM_DX_POA | VARCHAR | No |
This item identifies if the diagnosis was present when the patient was admitted.
6 | CLM_DX_CODE_SET_OID | VARCHAR | No |
The object ID (OID) for the diagnosis code set.
7 | CLM_DX_RANK | INTEGER | No |
This item holds the explicit rank of the diagnoses when it is present in the raw claims data.
8 | CLM_DX_FROM_HEADER_YN | VARCHAR | No |
Indicates whether the diagnosis was received at the header level.
May contain organization-specific values: No
Category Entries:
No
Yes
9 | RX_DX_QUAL | VARCHAR | No |
This item holds the qualifier identifying the code set for the claim diagnoses on a pharmacy claim.
10 | CLM_AP_DX_POA_C_NAME | VARCHAR | No |
The present on admission (POA) indicator code for the diagnosis.
May contain organization-specific values: No
Category Entries:
1 - Unreported/Not used
Y - Yes
N - No
U - Unknown
W - Clinically undetermined
11 | DX_TYPE | VARCHAR | No |
This item stores the diagnosis type of the claim.
12 | DX_INFO_TYPE | VARCHAR | No |
This item stores the information type of the diagnosis info code.