STMT_ETR_MATCH_DETAIL

Description:

This table contains information about Professional Billing transaction matching for a given statement.

Primary Key

Column Name	Ordinal Position
PRINT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PRINT_ID	NUMERIC	No
	The unique identifier (.1 item) for the statement print or detail bill record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	TX_ID	NUMERIC	No
	Professional Billing transaction ID in matched transaction table.
4	MATCH_TX_ID	NUMERIC	No
	Matched Professional Billing transaction ID in matched transaction table.
5	MATCH_DATE	DATETIME	No
	Matched date in matched transaction table.
6	UNMATCH_DATE	DATETIME	No
	Unmatched date in matched transaction table.
7	AMOUNT	NUMERIC	No
	Amount (self pay + insurance) matched or unmatched in matched transaction table.
8	INS_AMT	NUMERIC	No
	Insurance amount matched or unmatched in matched transaction table.
9	SP_AMT	NUMERIC	No
	Self-pay amount matched or unmatched in matched transaction table.