HSP_BFH_ACT_DATA_HLB

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 liability buckets (HLB).

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
BFH_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | BFH_ID | NUMERIC | No |
This column stores the unique identifier for the billing 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 |
The action category ID for this row in the billing activity history. The other data in this row represent specific values associated with this action performed.
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
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
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 | ACT_BDC_RECORD_TYPE_C_NAME | VARCHAR | No |
This column stores the denial/correspondence record type category ID that is created as a result of this bucket action.
May contain organization-specific values: No
Category Entries:
Denial
Remark
Correspondence
Underpayment
Overpayment
Claim Status
5 | ACT_BDC_RECEIVED_DATE | DATETIME | No |
This column stores the denial/correspondence record received date that is set as a result of this bucket action.
6 | ACT_BDC_RECORD_SOURCE_C_NAME | VARCHAR | No |
This column stores the denial/correspondence record source category ID that is set as a result of this bucket action.
May contain organization-specific values: Yes
Category Entries:
Payment Received
Correspondence Received
Zero Allowed Amount
Expected Allowed Amount Updated
Reserved for future use
System Auto Action
PB Follow-up Automatic Activity
System Generated
Claim Status
RAC Correspondence
ADR Correspondence
HH Pre-Claim Review
Transferred In
7 | ACT_BDC_INVOICE_NUM | VARCHAR | No |
This column stores the denial/correspondence record invoice number that is set as a result of this bucket action.
8 | ACT_BDC_AMOUNT | NUMERIC | No |
This column stores the denial/correspondence record amount that is set as a result of this bucket action.
9 | ACT_BDC_REMIT_CODE_ID | VARCHAR | No |
This column stores the denial/correspondence record reason code ID that is set as a result of this bucket action.
10 | ACT_BDC_REMIT_CODE_ID_REMIT_CODE_NAME | VARCHAR | No |
The name of each remittance code.
11 | ACT_BDC_IMAGE_MNEM_C_NAME | VARCHAR | No |
This column stores the denial/correspondence record image mnemonic category ID that is set as a result of this bucket action.
May contain organization-specific values: Yes
12 | ACT_BDC_IMAGE_KEY | VARCHAR | No |
This column stores the denial/correspondence record image key that is set as a result of this bucket action.
13 | ACT_SURCHARGE_OVERRIDE_TYPE_C_NAME | VARCHAR | No |
This item stores the type of surcharge override performed during a billing activity (ATM) action.
May contain organization-specific values: No
Category Entries:
System
User
Ins Pmt
14 | ACT_OUTLIER_AMOUNT | NUMERIC | No |
The outlier amount that is set as a result of this bucket action.
15 | ACT_ADDON_AMOUNT | NUMERIC | No |
The add-on amount that is set as a result of this bucket action.
16 | ACT_XR_OVERRIDE_TYPE_C_NAME | VARCHAR | No |
The type of expected reimbursement override that was performed during this bucket action.
May contain organization-specific values: No
Category Entries:
System Calculated
Contract Overridden
Expected Amounts Overridden
Overridden by Wisdom Estimate
17 | ACT_OVERRIDE_ICN | VARCHAR | No |
This column stores the internal control number that is set as a result of this bucket action.
18 | ACT_PMT_RECON_REPORT_TYPE_C_NAME | VARCHAR | No |
The report type category ID that was set through this bucket action.
May contain organization-specific values: Yes
No Entries Defined
19 | ACT_SETTLMENT_NUM | VARCHAR | No |
Documents the changes in the settlement number.
20 | ACT_NRP_TYPE_C_NAME | VARCHAR | No |
This column stores the next responsible party type performed as part of this activity.
May contain organization-specific values: No
Category Entries:
EOB Amount
Fixed Amount
Remaining Bucket Balance
Debit Bucket Balance
21 | ACT_EXPECTED_ALLOWED_AMT | NUMERIC | No |
The expected allowed amount used for this action.
22 | ACT_PAYER_ALLOWED_AMT | NUMERIC | No |
The payer allowed amount used for this action.
23 | ACT_USE_PREV_CLAIM_DATA_YN | VARCHAR | No |
Indicates whether we are using data from the previous claim for this billing activity. Yes (Y) means we are reusing previous claim data, No (N) means we are not.
May contain organization-specific values: No
Category Entries:
No
Yes
24 | ACT_TOB | VARCHAR | No |
The override Type of Bill used by the billing activity.
25 | ACT_PROCESS_IP_PART_B_YN | VARCHAR | No |
Indicates whether the billing activity processed the claim as an Inpatient Part B claim. Yes (Y) means the claim was processed as Inpatient Part B, No (N) means it was not.
The category values for this column were already listed for column: ACT_USE_PREV_CLAIM_DATA_YN
26 | ACT_CLM_CHNG_COND_CODE_C_NAME | VARCHAR | No |
The claim change reason code category ID for the billing activity.
May contain organization-specific values: Yes
27 | ACT_NRP_AMOUNT | NUMERIC | No |
This column stores the next responsible party amount.
28 | ACT_COPAY_AMOUNT | NUMERIC | No |
Stores the copay amount
29 | ACT_DEDUCTIBLE_AMOUNT | NUMERIC | No |
Stores the deductible amount
30 | ACT_COINSURANCE_AMOUNT | NUMERIC | No |
Stores the coinsurance amount
31 | ACT_NON_COVERED_AMOUNT | NUMERIC | No |
Stores the non-covered amount
32 | ACT_RESUB_CLM_AFTER_ACT_YN | VARCHAR | No |
Stores whether the user chose to resubmit the resulting bucket's claim after the action completes
The category values for this column were already listed for column: ACT_USE_PREV_CLAIM_DATA_YN
33 | ACT_PMT_RECON_REPORT_DATE | DATETIME | No |
Stores the report date
34 | ACT_PMT_RECON_TOTAL_CHG_AMOUNT | NUMERIC | No |
Stores the total charge amount
35 | ACT_PMT_RECON_NOT_ALWD_AMOUNT | NUMERIC | No |
Stores the not allowed amount for a bucket
36 | ACT_PMT_RECON_PAYMENT_AMOUNT | NUMERIC | No |
Stores the payment amount
37 | ACT_CONTRACT_DATE | DATETIME | No |
Stores the contract date of a contract on the bucket
38 | ACT_EXP_NOT_ALLOWED_AMOUNT | NUMERIC | No |
Stores the expected not allowed amount
39 | ACT_SURCHARGE_AMOUNT | NUMERIC | No |
Stores the surcharge amount
40 | ACT_TRANSFER_TO_BUCKET_ID | NUMERIC | No |
Stores the bucket that a record was transferred to
41 | ACT_EXTERNAL_SENT_DATE | DATETIME | No |
Stores the date that a claim was sent to an external source
42 | ACT_PAYER_RECEIVED_DATE | DATETIME | No |
Stores the date that a payer received a claim
43 | ACT_PROC_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
44 | ACT_ADJUSTMENT_AMOUNT | NUMERIC | No |
Stores the adjustment amount
45 | ACT_SURCHARGE_ASSIGNMENT_C_NAME | VARCHAR | No |
Stores how the surcharge is assigned
May contain organization-specific values: No
Category Entries:
System Distribution
Surcharge Credit
Non-Surcharge
46 | ACT_REV_EXISTING_WO_ADJ_YN | VARCHAR | No |
Whether to reverse existing write-offs for the bucket
The category values for this column were already listed for column: ACT_USE_PREV_CLAIM_DATA_YN
47 | ACT_UNDO_TYPE_C_NAME | VARCHAR | No |
Type of undo billing that was performed on the bucket
May contain organization-specific values: No
Category Entries:
Undo Next Responsible Party
Undo Billing
48 | ACT_POST_CONTRACTUAL_ADJ_YN | VARCHAR | No |
Stores whether the user chose to post a contractual adjustment for closed buckets alongside the action
The category values for this column were already listed for column: ACT_USE_PREV_CLAIM_DATA_YN
49 | ACT_REFUND_AMOUNT | NUMERIC | No |
Stores the refund amount for the Post Refund bucket action
50 | ACT_REFUND_REASON_C_NAME | VARCHAR | No |
Stores the category value of the refund reason for the Post Refund bucket action
May contain organization-specific values: Yes
Category Entries:
Other
Duplicate
Posted in Error
Overpayment
Financial Assistance
Left Without Being Seen
Patient Requested
Visit Canceled
51 | ACT_REFUND_COMMENT | VARCHAR | No |
Stores the additional comment that goes along with the refund reason for the Post Refund bucket action
52 | ACT_REFUND_SEND_TO_OPTION_C_NAME | VARCHAR | No |
Stores the category value of the option to whom to send the refund in the Post Refund bucket action
May contain organization-specific values: No
Category Entries:
Coverage
Guarantor
Patient
Custom Payee
Address Override
Payer
Plan
Direct Return
53 | ACT_REFUND_CUSTOM_PAYEE_ID | VARCHAR | No |
This column stores the unique identifier for the agency record for the custom payee to whom to send the refund for the Post Refund bucket action.
54 | ACT_REFUND_CUSTOM_PAYEE_ID_AGENCY_NAME | VARCHAR | No |
The name of the agency.
55 | ACT_REFUND_COVERAGE_ID | NUMERIC | No |
This column stores the unique identifier for the coverage for where to send the refund for the Post Refund bucket action.
56 | ACT_REFUND_PAYER_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
57 | ACT_REFUND_PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
58 | ACT_ADDR_NAME | VARCHAR | No |
Stores the name for an address specified in a billing activity action
59 | ACT_ADDR_LINE_1 | VARCHAR | No |
Stores the first line of an address specified in a billing activity action
60 | ACT_ADDR_LINE_2 | VARCHAR | No |
Stores the second line of an address specified in a billing activity action
61 | ACT_ADDR_CITY | VARCHAR | No |
Stores the city of an address specified in a billing activity action
62 | ACT_ADDR_STATE_C_NAME | VARCHAR | No |
Stores the category value of the state/province in a country for an address specified in a billing activity action
May contain organization-specific values: Yes
63 | ACT_ADDR_ZIP_CODE | VARCHAR | No |
Stores the zip code for an address specified in a billing activity action
64 | ACT_ADDR_HOUSE_NUMBER | VARCHAR | No |
Stores the house number for an address specified in a billing activity action. This may be blank for some addresses.
65 | ACT_ADDR_COUNTY_C_NAME | VARCHAR | No |
Stores the category value of the county for an address specified in a billing activity action
May contain organization-specific values: Yes
66 | ACT_ADDR_DISTRICT_C_NAME | VARCHAR | No |
Stores the category value of the district for an address specified in a billing activity action
May contain organization-specific values: Yes
67 | ACT_ADDR_COUNTRY_C_NAME | VARCHAR | No |
Stores the category value of the country for an address specified in a billing activity action
May contain organization-specific values: Yes
68 | ACT_TRANSFER_FROM_BUCKET_ID | NUMERIC | No |
This column stores the unique identifier of the source bucket when transferring a denial/correspondence record.
69 | ACT_PMT_RECON_NON_CVD_AMOUNT | NUMERIC | No |
Stores the additional payment reconciliation non-covered amount
70 | ACT_ADDL_NRP_AMT | NUMERIC | No |
Stores the additional NRP Amount