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: 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	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