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.