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.