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.