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: 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 Payer Notice Void Payer Notice Reopen Payer Notice 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 Demand Claim Remove From Claim Queue Rehome Add to Credit Workqueue Send Tapestry Letter
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 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
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 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	NUMERIC	No
	This column stores the caused-by department for the follow-up records.
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 Patient Portal Chart Gateway In Basket Claims Delivery Interface Payer Platform Email ANSI 275 Release to Tapestry
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
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: Appropriate & Downgraded Inappropriate & Overturned Inappropriate & Downgraded
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.