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
HB Transaction
Bucket
Denial/Correspondence/Discrepancy
Guarantor
PB Insurance Follow-up
Invoice
Claim Line
PB Transaction
HB Pending Transaction
PB Pending Transaction
Visit
Claim
Remittance
Cash Management
Cash Control Group
Member
Coverage
Plan Billing Account
AP Claim
Payment Posting Batch
Universal Charge Line
Universal Charge Session
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:
Staff
System
Patient
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.
22 ACTIVITY_COMM_ID VARCHAR No
Contact (CAL) ID to be attached if there is currently a CRM Sidebar open when the Billing Action takes place.
23 HB_TX_ID NUMERIC No
Stores the Hospital Transaction that this action was performed on.
24 CLAIM_PRINT_ID NUMERIC No
ID of the claim record the action acted on.
25 BILLING_SYSTEM_C_NAME VARCHAR No
The billing system this billing activity was performed for.
May contain organization-specific values: No
Category Entries:
Professional Billing
Hospital Billing
Hospital & Professional Billing
External
Tapestry
26 ROI_ID VARCHAR No
ID of the release record the action was performed on.
27 INVOICE_NUMBER VARCHAR No
Invoice number of the claim the action was performed on.
28 REMIT_ID NUMERIC No
ID of the remittance snapshot (RRT) record the action acted on.
29 CLAIM_RUN_CTR_ID NUMERIC No
The ID of the claim run tracking (CTR) record the action acted on.
30 RUN_NUMBER INTEGER No
The number of the run the action acted on.
31 ACT_SOURCE_C_NAME NUMERIC No
Stores whether this activity was performed by the system, a user, or a patient.
The category values for this column were already listed for column: SYSTEM_YN
32 MC_CLAIM_ID NUMERIC No
Stores the AP Claim this action was performed on.