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.