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:
No Action
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
Pause 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
Change Guarantor
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
Reevaluate Tax
Release From Workqueue
Update Estimate
Remove Estimate
Resubmit Charge
Workqueue Action
Resubmit Claim
Print Claim
Transfer to Insurance
Void Transaction
Post Split Write-off
Send Guarantor Letter
Send Invoice Letter
Upload To Workqueue
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
Start Reconsideration
Log Upheld Denial
Reset Self-Pay Aging Date
Reset Insurance Aging Date
Submit Replacement Claim
Submit Cancel Claim
Recalculate Discount
Repost
Reprint Refund Slip
Undistribute
Transfer to HB
Request Refund
Void Transaction (Unused)
Send to Collection Agency
Recall from Collection Agency
Refund Review
Edit Visit Filing Order
Plan Swap
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 Transaction Indicators
Print Refund Letter
PB Quick Correct
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
Write Off Balance
Submit Refund Request
Review Refund
Modify Collections Step
Start Collections
Assign Collector
Modify Collections Transactions
Post Manual Payment
Transfer Payment from Suspense Account
Distribute Credits
Transfer Payment Method from Suspense
Charge Entry
Charge Review
Override Workqueue Rules
Delete
Resubmit to Workqueue
Approve
Decline
Activate
Update Account Benefit Related Info
Update Account Claim Override Info
Update Condition Codes
Update Occurrence Codes
Update Value Codes
Update Occurrence Span Codes
Start Coding
Complete Coding
Reopen Coding
Change Visit Info
Change Providers
Change Coding Diagnoses
Change Coding Procedures
Change Coding DRGs
Start CDI
Create New CDI Review
Complete CDI
Reopen CDI
Edit existing CDI Review
CDI Review Updated
Copy to CDI Baseline Review
Create Batch
Edit Batch
Redistribute Payment
Override Revenue Guardian Check
Override Primary Encounter
Update Coded Contact
Delete Query
Run Manual Pull Info
Reopen Abstracting
Start Abstracting
Complete Abstracting
Modify Abstracting Group
Send Query
Edit Query
Pend Query
Reply to Query
Complete Query
Flag Wait for Query
Create New Wait for Query
Edit DBC Key Fields
Edit DBC Referral Information
Edit DBC Entitlement Information
Edit DBC Paramedical Information
Edit DBC Additional Information
Create DBC Episode
Create Follow-Up DBC
Create Replacement DBC Episode
Re-Use DBC Episode
Merge DBC Episode
Edit Claim Values - Claim Body
Override Claim Edit Error
Export Claim
Export Claim Attachment
Create Claim Attachment
Remove Claim Attachment
Resubmit Errored Claim
Accept Claim
Reject Claim
Refresh Claim
Reset Claim Values
Remove Claim From Workqueue
Edit PB Claim Charges
Edit Claim Values - Explanation of Benefits
Edit Claim Values - Other Coverages
Edit Claim Values - Claim Codes
Edit Claim Values - Service Lines
Load Remittance
Reload Remittance
Process Remittance
Accept Remittance
Reject Remittance
Remove Remittance Payment
Accept Payment Changes
Retest Payment
Release All Completed Payments
Create Cash
Create Cash Control Group
Dismiss Potential Query
Deactivate Provider Nudge
Show Provider Nudge to Physician
PB Transaction Edit
Update Image Index
Edit Appeal Letter
Change Release Status
Assign Cash Control Group
Edit Cash Control Group
Edit Cash
Delete Cash
Transfer Cash
Confirm Cash Control Group
Void Cash Control Group
Reopen Cash Control Group
Update CEV Information
File Remittance
Resolve Claim Edit Error
Introduce Claim Edit Error
Add Claim Comment
Edit Claim Values (CLP)
Create Claim Run
Print Claim Run
Accept Claim Run
Reject Claim Run
Post Payment to Clearing Account
Post Payment to Guarantor
Post Payment to Invoice
Accept PLB
Remove PLB
Post Payment to Charge
Retest All Payments
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.
10 | COLL_PROCESS_IDENT | INTEGER | No |
Stores billing activity history of the id of the process modified by the billing action.
11 | COLL_MODIFICATION_OPT_C_NAME | VARCHAR | No |
Stores billing activity history for which modification option the user chooses with the Modify Collections Step action.
May contain organization-specific values: No
Category Entries:
Complete Step
Skip Step
Toggle Pause
Dismiss Collections
12 | ACTION_COMP_PB_COLL_STEP_C_NAME | VARCHAR | No |
Billing activity history item to store step completed by Modify Collections Step.
May contain organization-specific values: Yes
Category Entries:
Paid Off
Written Off
Final Review