AP_CLAIM_REAL_TM_INTERF

Description:

This table contains data for each service line from the real time claims interface such as ethical price, contract adjustment, and provider discount. To link this table’s service line information back to a claim header, join this table to AP_CLAIM_PROC_IDS on the TX_ID column. If you need to report on claim service lines specific to Cost Sharing Reduction (CSR), join this table instead to AP_CLAIM_PROC_IDS_CSR on the TX_ID column.

Primary Key

Column Name	Ordinal Position
TX_ID	1

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique ID of the AP Claim procedure transaction.
2	ETHICAL_PRICE	NUMERIC	No
	This column stores the ethical price for the service line.
3	CONTRACT_ADJ	NUMERIC	No
	This column stores the contract adjustment for the service line.
4	MMAP_PRICE	NUMERIC	No
	This column stores the maximum medical aid price (MMAP) for the service line.
5	MMAP_ADJ	NUMERIC	No
	This column stores the maximum medical aid price (MMAP) adjustment for the service line.
6	BULK_BREAK_ADJ	NUMERIC	No
	This column stores the bulk break adjustment for the service line.
7	PROVIDER_DISCOUNT	NUMERIC	No
	This column stores the provider discount for the service line.
8	ADMINISTRATIVE_FEE	NUMERIC	No
	This column stores the administrative fee for the service line.