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
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