HSP_BFH_HOSP_TXS

Description: |
Table contains Hospital Billing payments that have been matched to a billing activity history record.

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 | HB_TX_ID | NUMERIC | No |
This column stores the unique identifier for the payment transaction that this activity helped to generate.
4 | HB_MATCHED_AMOUNT | NUMERIC | No |
Hospital Billing self-pay payment amount credited to this activity.
5 | HB_MATCHED_INS_AMOUNT | NUMERIC | No |
Hospital Billing insurance payment amount credited to this activity.
6 | HB_MATCHED_DATE | DATETIME | No |
The date on which the payment was matched to the billing activity.