AP_CLAIM_DX

Description: |
The AP_CLAIM_DX table contains one record for each diagnosis on an accounts payable claim.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CLAIM_ID | NUMERIC | No |
The unique identifier of the accounts payable claim record for this diagnosis.
2 | LINE | INTEGER | No |
The line number of the diagnosis for this claim record. For example, if a claim has two associated diagnoses, two AP_CLAIM_DX records will be generated: one with a line number of 1, the other with a line number of 2.
3 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
4 | AP_DX_NUM | INTEGER | No |
The number of the diagnosis associated with this record.
5 | AP_DX_QUALIFIER_C_NAME | VARCHAR | No |
The qualifier related to the diagnosis associated with this record.
May contain organization-specific values: Yes
6 | AP_DX_POA_C_NAME | VARCHAR | No |
Present on Admission (POA) for the diagnosis code.
May contain organization-specific values: No
Category Entries:
1 - Unreported/Not used
Y - Yes
N - No
U - Unknown
W - Clinically undetermined
7 | AP_DX_RANK | INTEGER | No |
The rank of this diagnosis compared to the other diagnoses on the claim.
8 | CLAIM_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