HSP_BFH_ACT_DATA_BDC

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 insurance follow-up (BDC) records.

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
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 | ACT_BDC_STATUS_C_NAME | VARCHAR | No |
This column stores the denial/correspondence record status category ID that is set as a result of this action.
May contain organization-specific values: Yes
Category Entries:
Created
Transferred
Documents Need Review
Documents Created
Documents Sent
Appeal Started
Reconsideration Started
Reopened
Completed
Voided
5 | ACT_BDC_RESOLVE_REASON_C_NAME | VARCHAR | No |
This column stores the denial/correspondence record resolution reason category ID that is set as a result of this action.
May contain organization-specific values: Yes
Category Entries:
Auto-Closed
No Outstanding Insurance Balance
Claim Resubmitted
PB Charges Voided
PB Charges Reposted
PB Payment Undistributed
PB Original Follow-up Completed
Variance Type Changed
Documents Sent
Subsequent Payer Follow-up
Appeal Submitted
Payment Expected
Denial Expected
Source Payment Recouped
Completed from Previous Follow-up
Payment Received
Claim Status Updated
No Invoice-Level Variance
No Variance after Contract Reevaluation
Variance Under Threshold
Reconsideration Submitted
6 | ACT_BDC_OWNING_AREA_C_NAME | VARCHAR | No |
This column stores the denial/correspondence record owning area category ID that is set as a result of this action.
May contain organization-specific values: Yes
7 | ACT_BDC_DENIAL_CATEGORY_C_NAME | VARCHAR | No |
This column stores the category ID of the denial record denial category that is set as a result of this action.
May contain organization-specific values: Yes
Category Entries:
Adjudication
Registration/Eligibility
Authorization
Coding
Bundled
Contract Related
Non-Covered
Miscellaneous
Timely Filing
Informational
Provider Enrollment/Credentialing
Duplicate
Additional Documentation Needed
Billing Error
Coordination of Benefits
Denied Days
Exceeds Approved Days
Medical Necessity/Level of Care
Patient Responsible
8 | ACT_BDC_ROOT_CAUSE_C_NAME | VARCHAR | No |
This column stores the denial/correspondence record root cause category ID that is set as a result of this action.
May contain organization-specific values: Yes
9 | ACT_BDC_RPT_REMIT_CODE_ID | VARCHAR | No |
This column stores the denial/correspondence record reporting remittance code ID that is set as a result of this action.
10 | ACT_BDC_RPT_REMIT_CODE_ID_REMIT_CODE_NAME | VARCHAR | No |
The name of each remittance code.
11 | ACT_BDC_SOURCE_AREA_C_NAME | VARCHAR | No |
This column stores the denial/correspondence source area category ID that is set as a result of this action.
The category values for this column were already listed for column: ACT_BDC_OWNING_AREA_C_NAME
12 | ACT_BDC_PREVENTABLE_YN | VARCHAR | No |
This column stores the denial record preventable status that is set as a result of this action. 'Y' indicates that the denial was preventable. 'N' or NULL indicate that it was not preventable.
May contain organization-specific values: No
Category Entries:
No
Yes
13 | ACT_BDC_APPEAL_STAGE_C_NAME | VARCHAR | No |
This column stores the denial appeal stage (I BDC 10130).
May contain organization-specific values: Yes
Category Entries:
Stage 1
Stage 2
Stage 3
14 | ACT_BDC_APPEAL_DUE_DATE | DATETIME | No |
This column stores the denial appeal due date (I BDC 10022).
15 | ACT_BDC_APPEAL_USER_ID | VARCHAR | No |
This column stores the denial appealing user (I BDC 10027).
16 | ACT_BDC_APPEAL_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
17 | ACT_BDC_APPEAL_SUBMIT_DATE | DATETIME | No |
This column stores the denial appeal submission date (I BDC 10023).
18 | ACT_BDC_APPEAL_SUBMIT_MTHD_C_NAME | VARCHAR | No |
This column stores the denial appeal submission method (I BDC 10028).
May contain organization-specific values: Yes
Category Entries:
Payer Website
Fax
Mail
Resubmitted Claim
Electronic File Transfer
Payer Platform
Other
19 | ACT_BDC_RES_OWNER_USER_ID | VARCHAR | No |
The column represents the resolution owner for the follow-up records.
20 | ACT_BDC_RES_OWNER_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
21 | ACT_BDC_SOURCE_USER_ID | VARCHAR | No |
The column represents the caused by user for the follow-up records.
22 | ACT_BDC_SOURCE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
23 | ACT_BDC_SOURCE_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
24 | ACT_BDC_APPEAL_SELECT_LN_YN | VARCHAR | No |
The column indicates whether denial resubmission had a manually-selected line.
The category values for this column were already listed for column: ACT_BDC_PREVENTABLE_YN
25 | ACT_BDC_APPEAL_OVRIDE_DATA_YN | VARCHAR | No |
The column indicates whether resubmitted lines had override data.
The category values for this column were already listed for column: ACT_BDC_PREVENTABLE_YN
26 | ACT_BDC_NEXT_FOLLOWUP_DATE | DATETIME | No |
The Next Follow-up Date that was changed as a result of this action.
27 | ACT_BDC_APPEAL_LEVEL_C_NAME | VARCHAR | No |
The appeal level set as a result of this action.
May contain organization-specific values: No
Category Entries:
Level 1
Level 2
Level 3
28 | ACT_BDC_ROI_RECIPIENT_ID | VARCHAR | No |
This column stores the recipient or organization (AGY record) specified when generating the Release of Information (ROI) documentation created from this action.
29 | ACT_BDC_ROI_RECIPIENT_ID_AGENCY_NAME | VARCHAR | No |
The name of the agency.
30 | ACT_BDC_ROI_SUB_MTHD_C_NAME | VARCHAR | No |
This column stores the submission method specified when generating the Release of Information (ROI) documentation created from this action.
May contain organization-specific values: Yes
Category Entries:
CCD
Print
Save to File
Fax
Inspector
EpicCare Link
Electronic Delivery
Chart Gateway
In Basket
Claims Delivery
Interface
Payer Platform
Email
ANSI 275
Release to Tapestry
Release to Payer Platform
31 | ACT_BDC_ROI_RELEASE_TMPLT_ID | NUMERIC | No |
This column stores the release template (RTM record) specified when generating the Release of Information (ROI) documentation created from this action.
32 | ACT_BDC_ROI_RELEASE_TMPLT_ID_ROI_TEMPLT_NAME | VARCHAR | No |
The name of the release template.
33 | ACT_BDC_PAYER_DOWNGRADE_TYPE_C_NAME | VARCHAR | No |
The BDC Payer Downgrade Type that is set as a result of this action.
May contain organization-specific values: No
Category Entries:
No Downgrade
Inpatient to Observation
DRG
Emergency Visit Level
Upcoded DRG
34 | ACT_PAYER_DOWNGRADE_OUTCOME_C_NAME | VARCHAR | No |
The BDC Payer Downgrade Outcome that is set as a result of this action.
May contain organization-specific values: No
Category Entries:
Downgrade Accepted – Agree with Payer
Downgrade Overturned
Downgrade Accepted – Disagree with Payer
35 | ACT_BDC_RULE_ID | VARCHAR | No |
The BDC rule used for billing activities.
36 | ACT_BDC_RULE_ID_RULE_NAME | VARCHAR | No |
The name of the rule.
37 | ACT_BDC_FOLLOW_UP_CONTEXT_C_NAME | VARCHAR | No |
The follow-up context (I BDC 32) set on a follow-up BDC.
May contain organization-specific values: No
Category Entries:
Additional Documentation Request
Payer Rejection
38 | ACT_BDC_ICN | VARCHAR | No |
Internal Control Number (ICN) to provide a payer in relation to a follow-up.
39 | ACT_BDC_FOL_UP_RESP_TYPE_C_NAME | VARCHAR | No |
The response type (I BDC 10507) set on a follow-up record.
May contain organization-specific values: No
Category Entries:
Appeal
Reconsideration
Documentation Submission
40 | ACT_BDC_TRACKING_IDENT | VARCHAR | No |
The submission tracking ID (BDC-10502) set on a follow-up record.
41 | ACT_BDC_INCLUDE_AI_REFS_YN | VARCHAR | No |
Whether or not the user chose to include the automatically AI generated references in the release of information when starting a new appeal.
The category values for this column were already listed for column: ACT_BDC_PREVENTABLE_YN
42 | ACT_BDC_INCL_FAX_CVR_SHEET_YN | VARCHAR | No |
Whether to include the fax cover sheet in the output.
The category values for this column were already listed for column: ACT_BDC_PREVENTABLE_YN
43 | ACT_BDC_ADDL_SMARTTEXT_ID | VARCHAR | No |
The ID of the addtional SmartText that was used in the BDC level action.
44 | ACT_BDC_ADDL_SMARTTEXT_ID_SMARTTEXT_NAME | VARCHAR | No |
The name of the SmartText record.