HSP_BFH_ACTIVITY
Description:
History of billing activities performed.

Primary Key
Column Name Ordinal Position
BFH_ID 1

Column Information
Name Type Discontinued?
1 BFH_ID NUMERIC No
This column stores the unique identifier for the billing activity history record.
2 HB_ACTIVITY_ATM_ID_ATM_NAME VARCHAR No
The name of the billing activity.
3 HB_CONTEXT_C_NAME VARCHAR No
Stores the hospital billing context (hospital account, guarantor, and others) category number that the activity was performed from.
May contain organization-specific values: No
Category Entries:
Hospital/Visit Account
Transaction
Bucket
Denial/Correspondence/Discrepancy
Guarantor
PB Insurance Follow-up
PB Invoice
PB Claim Line
PB Transaction
Hospital Pending Transaction
PB Temporary Transaction
PB Visit
Member
Coverage
Premium Billing Account
AP Claim
4 ACTIVITY_DATE DATETIME No
Stores the date an activity was performed.
5 ACTIVITY_INST_DTTM DATETIME (Local) No
Stores the instant an activity was performed.
6 HSP_ACCOUNT_ID NUMERIC No
This column stores the unique identifier for the Hospital Account that this activity was performed on.
7 BUCKET_ID NUMERIC No
This column stores the unique identifier for the liability bucket that this action was performed on.
8 ACCOUNT_ID NUMERIC No
This column stores the unique identifier for the guarantor that this activity was performed on. This column is only populated for activities performed in a guarantor context.
9 USER_ID VARCHAR No
This column stores the unique identifier for the user who performed this action.
10 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 SYSTEM_YN VARCHAR No
Stores whether this was a system auto action or not.
May contain organization-specific values: No
Category Entries:
No
Yes
12 BDC_ID NUMERIC No
Stores the follow-up record the activity was performed on.
13 HB_MATCHED_SP_AMOUNT NUMERIC No
The total hospital billing matched self-pay amount for the billing activity.
14 HB_MATCHED_INS_AMOUNT NUMERIC No
The total hospital billing matched insurance amount for the billing activity.
15 PB_MATCHED_SP_AMOUNT NUMERIC No
The total professional billing matched self-pay amount for the billing activity.
16 SCHED_PMT_ID NUMERIC No
Stores the scheduled payment record on which a billing activity was performed.
17 ACTIVITY_ID_NUMBER INTEGER No
This column stores the unique identifiers for follow-up activities caused by this billing activity. All resultant follow-up activities will have this ID in their System Activity ID (FOL 257) item.
18 PB_TOTAL_MATCHED_INS_AMOUNT NUMERIC No
Stores the total Professional Billing matched insurance amount for the billing activity.
19 TOTAL_MATCHED_SP_AMOUNT NUMERIC No
Stores the total matched self-pay amount for the billing activity.
20 TOTAL_MATCHED_INS_AMOUNT NUMERIC No
Stores the total matched insurance amount for the billing activity.
21 MC_PB_ACCT_ID VARCHAR No
This column stores the Premium Billing Account this action was performed on.