AP_PROC_ASSOC_DX

Description: |
This table summarizes diagnoses associated with AP claim service lines.
To link this table’s service line information back to a claim header, join this table to AP_CLAIM_PROC_IDS on the TX_ID column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the TX_ID column.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ETR_ID | NUMERIC | No |
The unique ID of the AP Claim procedure transaction.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | DX_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
4 | DX_QUAL_C_NAME | VARCHAR | No |
The diagnosis qualifier category ID associated with this procedure.
May contain organization-specific values: Yes
5 | DX_NUM | INTEGER | No |
The diagnosis number on the AP claim that this row corresponds to. It can be used to access diagnosis details found by joining this column on AP_CLAIM_DX.AP_DX_NUM and the known claim unique identifier on AP_CLAIM_DX.CLAIM_ID.
6 | DX_RANK | INTEGER | No |
The rank of this diagnosis compared to the other diagnoses on the service.