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.