AP_CLAIM_PROC_IDS_CSR

Description:

This table stores the linkages between AP claims (CLM records) and service lines (ETR records) that store adjudication results for cost-sharing reduction (CSR) reconciliation. A common use case for this table is to link from claim-level summary tables to service-line-level summary tables. For example, one path is to join AP_CLAIM to AP_CLAIM_PROC_IDS_CSR on CLAIM_ID and AP_CLAIM_PROC_IDS_CSR to AP_CLAIM_PROC on TX_ID.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The ID for the claim record.
2	LINE	INTEGER	No
	The service line number of the claim this row corresponds to, as stored in Chronicles CLM item 19250.
3	TX_ID	NUMERIC	No
	The ID of the transaction record that stores all service line information for cost-sharing reduction (CSR) reconciliation calculations. These records are commonly referred to as procedures, services, transactions, or service lines.