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.