ARPB_TX_MATCH_HX

Description:

Matching History Transaction Related Items. A line is added to this related group whenever two transactions are matched together.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction 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	MTCH_TX_HX_DT	DATETIME	No
	This item stores the date that a transaction was matched to this transaction.
4	MTCH_TX_HX_ID	NUMERIC	No
	This item stores the transaction that this transaction was matched to. If the MTCH_TX_HX_UN_DT is null, then the transaction is still currently matched to this transaction.
5	MTCH_TX_HX_AMT	NUMERIC	No
	This item stores the (insurance+self-pay) amount for which this transaction is matched to the transaction in column MTCH_TX_HX_ID.
6	MTCH_TX_HX_INS_AMT	NUMERIC	No
	This item stores the insurance amount for which this transaction is matched to the transaction in column MTCH_TX_HX_ID.
7	MTCH_TX_HX_PAT_AMT	NUMERIC	No
	This item stores the self-pay amount for which this transaction is matched to the transaction in column MTCH_TX_HX_ID.
8	MTCH_TX_HX_COMMENT	VARCHAR	No
	This item holds the comment for the matching of this transaction to the transaction in column MTCH_TX_HX_ID. This item is typically only populated by the system and not user entered comments.
9	MTCH_TX_HX_UN_DT	DATETIME	No
	This item holds the date that the transaction was unmatched from the transaction in column MTCH_TX_HX_ID.
10	MTCH_TX_HX_D_CVG_ID	NUMERIC	No
	This item stores the coverage ID at the time that the transaction was matched to the transaction in column MTCH_TX_HX_ID.
11	MTCH_TX_HX_DSUSR_ID	VARCHAR	No
	This item stores the users who matched this transaction to the transaction from column MTCH_TX_HX_ID.
12	MTCH_TX_HX_DSUSR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
13	MTCH_TX_HX_UDUSR_ID	VARCHAR	No
	This item stores the user that unmatched this transaction from the transaction in the MTCH_TX_HX_ID column.
14	MTCH_TX_HX_UDUSR_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
15	MTCH_TX_HX_INV_NUM	VARCHAR	No
	This item stores the invoice associated with the debit transaction in the matching group.
16	MTCH_TX_HX_UN_COM	VARCHAR	No
	This item stores the comment entered when the transaction is undistributed.
17	MTCH_TX_HX_UN_CV_ID	NUMERIC	No
	This is the coverage of the debit transaction at the time of unmatch.
18	MTCH_TX_HX_LINE	INTEGER	No
	This item stores the corresponding line from the matched transaction.
19	MTCH_TX_HX_DTTM	DATETIME (UTC)	No
	The UTC date and time the transaction was matched.
20	MTCH_TX_HX_UN_DTTM	DATETIME (UTC)	No
	The UTC date and time the transaction was unmatched.