AP_CLAIM_PROC_IDS

Description: |
This table stores the linkages between AP claims (CLM records) and their service lines (ETR records). 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 on CLAIM_ID and AP_CLAIM_PROC_IDS 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 for of the claim this row corresponds to, as stored in Chronicles CLM item 18250.
3 | TX_ID | NUMERIC | No |
The ID of the transaction (ETR) record that stores all service line information. The ETR records are commonly referred to as procedures, services, transactions, or service lines.