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	NUMERIC	No
	The unique identifier of the diagnosis record associated with the AP claim procedure. Note: This is not the ICD-9 code for 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.