HSP_BFH_PROF_TXS
Description:
Table contains Professional Billing payments that have been matched to a billing activity history record. Professional Billing self-pay payments are matched to billing activity history records only in service areas with Single Billing Office enabled.

Primary Key
Column Name Ordinal Position
BFH_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 BFH_ID NUMERIC No
This column stores the unique identifier for the billing activity history 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 PB_MATCHED_DATE DATETIME No
Date the Professional Billing payment was credited to the performed activity.
4 PB_TX_ID NUMERIC No
This column stores the unique identifier for the Professional Billing transaction that this follow-up activity helped to generate.
5 PB_MATCHED_AMOUNT NUMERIC No
Self-pay amount from the Professional Billing transaction that this follow-up activity was credited with generating. Professional Billing self-pay payments are matched to billing activity records only in service areas with Single Billing Office enabled.
6 PB_TX_MATCH_HX_LINE INTEGER No
Match line in the Professional Billing transaction matching history that is credited to this activity.
7 PB_MATCHED_INSURANCE_AMOUNT NUMERIC No
This column stores the insurance amount from the professional billing transactions that are credited to this activity.