HSP_BFH_ACT_DATA_PBA
Description:
This table stores billing activity history action-specific data. Every time a billing activity (ATM) is performed on a record or group of records, an activity history record (BFH) is logged. These activity history records store specific data related to each action that was performed on the activity. Each action (and its related data) is logged as a line in related group BFH 300. This table is specifically for actions performed on Premium Billing Accounts (PBA).

Primary Key
Column Name Ordinal Position
BFH_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 BFH_ID NUMERIC No
The unique identifier (.1 item) for the 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 ACTION_C_NAME VARCHAR No
Stores what system actions were actually performed on the account.
May contain organization-specific values: No
Category Entries:
Send Breeze Letter
Send to Pre-Collect
Send to Bad Debt
Return from Agency
Write-Off Self-Pay
Update Billing/Statement Note
Change Review Notification Date
Add to Workqueue
Add Note
Outsource Account
Change Agency
Update Billing Indicators
Send Letter
Change Self-Pay Follow-up Date
Send to External Agency AR
Modify SNF PPS Codes
Defer
Change Self-Pay Follow-up Level
Add Charge
Reverse Transaction
Reprice Charge
Correct Charge
Update Stop Bills
Enable Paperless Billing
Disable Paperless Billing
Post Adjustment
Transfer Follow-up Record
Next Responsible Party
Transfer to Self-Pay
Undo Billing
Submit Claim Status Request
Update Guarantor Status
Post Refund
Change Bundled Episode
Duplicate and Send Charge
Initiate Informational Claim
Evaluate Pricing Contracts
Override Home Health Discharge Disposition
Change Financial Assistance
Reevaluate Self-Pay Discounts
Unlock Pay as Guest
Change Admit/Discharge Dates
Update Additional Payment Reconciliation
Change Account Class
Override Surcharge
Override Expected Reimbursement
Update Invoice Numbers
Discharge Account
Combine Account
Uncombine Account
Reopen Account
Close Account
Override Claim Sent Dates
Override Claim ICN
Create Related Account
Add Guarantor Note
Update Coding Status
Update Abstracting Status
Update CDI Review Status
Change Assigned Coder
Change Assigned Abstracter
Change Assigned CDI Specialist
Initiate Homing
Initiate Billing
Post Not Allowed Adjustment
Override Self-Pay Discount
Update Settlement Numbers
Admission Day Billing
Send Detail Bill
Send Statement
Process Late Charges
Undo All Billing
Send Guarantor Detail Bill
Undo Discharge
Override DNB Warnings
Override RAP Checks
Update Coding Flags
Override Expected Self-Pay Liability
Create Trust Account Series
Change Next Statement Date
Change Next Payment Plan Auto Pay Date
Log Denial/Remark
Defer Payment Plan
Contest Account
Complete
Transfer
Skip
Route
Stamp Epic Settlement Numbers
Reevaluate Expected Reimbursement
Reevaluate APC Grouping
Undo Informational Bucket
Initiate No-Pay Claim
Initiate Exhaust Claim
Research Review
Send Denied Amount to Self-Pay
Ignore Denied Amount
Void DBC
Undo Close DBC
Park DBC
Unpark DBC
Reprice DBC
Send In Basket Message for DBC
Flag for Review
Close DBC
Recalculate DBC Close Dates
Update Visit Auto Pay
Terminate Visit Auto Pay
Set Up Recurring Payment
Update Recurring Payment
Terminate Recurring Payment
Split Account
Update SNF Exhaust Date
Process Payment Plan Payment Now
Change Next Visit Auto Pay Date
Set Up Recurring Trust Transfer
Update Recurring Trust Transfer
Terminate Recurring Trust Transfer
Process Recurring Trust Transfer Now
Perform One-Time Trust Transfer
Close Recurring Series
Reopen Recurring Series
Override Send DBC to Grouper Checks
Send DBC to Grouper
Close Case
Refund
Log Correspondence
Log Variance
Mark for Separate Service Area Billing
Unmark for Separate Service Area Billing
Send to Billing Service Area
Return to Care Service Area
Send Claim Detail Bill
Process Visit Auto Pay Payment Now
Process Recurring Payment Now
Update Self-pay Charge Exemption Reason
Redistribute Self-Pay Credits
Send Eligibility Query
Update Follow-up Records By Rule
Send Self-Pay to Consolidated Service Area / External Billing
Return from Consolidated Service Area / External Billing
Undo NRP Back to Selected Bucket
Distribute Bundled Payments
Consecutive Account Merge
Resubmit Charge
Perform Workqueue Action
Resubmit Claim
Print Claim
Transfer to Insurance
Void Charge
Post Split Write-off
Send Guarantor Letter
Send Invoice Letter
Initiate RAP
Initiate Secondary RAP
Initiate Notice of Election
Initiate Home Health No-Pay RAP
Initiate Home Health Notice of Admission
Transaction Reverse
Transfer Transaction
Charge Duplicate and Send
Research Correct
Client Correct
Quick Correct
Contest Charge
Post Transaction Refund
Add Corresponding Charge
Edit Refund
Update Denial/Remark
Void Denial/Remark
Reopen Denial/Remark
Update Correspondence
Void Correspondence
Reopen Correspondence
Update Variance
Void Variance
Reopen Variance
Create Release
Update Claim Status Follow-Up
Void Claim Status Follow-Up
Reopen Claim Status Follow-Up
Start Appeal
Void Appeal
Reset Self-Pay Aging Date
Reset Insurance Aging Date
Replace Claim
Submit Cancel Claim
Recalculate Discount
Repost
Reprint Refund Slip
Undistribute
Transfer to HB
Refund Request
Void Transaction
Send to Collection Agency
Recall from Collection Agency
Refund Review
Edit Visit Filing Order
Change AP Import Status
Edit Payment
Edit Adjustment
Post Debit Adjustment
PB Demand Claim
Transfer Visit/Invoice
PB Accept Filing Order
PB Reject Filing Order
Post PB Debit Adjustment
Turn On Automatic Self-Pay Write-Off
Turn Off Automatic Self-Pay Write-Off
PB Undistribute
Override Posted Not Billed Warnings
Retroadjudication
Create Shadow Charges
Update Payment Plan
Terminate Payment Plan
Set Reminder
Send Billing Notification
Execute Extension
Update PB Billing Status
Evaluate for Financial Assistance Case Creation
Demand Claim
Remove From Claim Queue
Rehome
Add to Credit Workqueue
Send Tapestry Letter
Add Tapestry Note
Set Up Auto Pay
Make One-Time Payment
Update Delinquency Status
Reinvoice Account
Ad Hoc Adjustment
Premium Write Off
4 PBA_ACTION_CARD_ID NUMERIC No
The payment method that was selected when the PBA action was performed.
5 DELINQUENT_STATUS_C_NAME VARCHAR No
The delinquency status the Premium Billing Account was set to when an action was performed.
May contain organization-specific values: Yes
Category Entries:
Not Delinquent
6 DELINQUENT_PB_INVC_ID VARCHAR No
The invoice that caused the Premium Billing account to become delinquent.
7 INDIV_PB_INVC_ID VARCHAR No
The invoice created from reinvoicing an account using the Reinvoice Account action.
8 GRP_PB_INVC_ID VARCHAR No
The invoice created for the group account on a split-billing accounts from using the Reinvoice Account action.
9 PB_ACT_TX_ID VARCHAR No
The Ad Hoc transaction ID generated from the Ad Hoc Adjustment action.