HSP_BFH_ACT_DATA

Description:

Actions performed during the billing activity.

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
	Stores what actions were actually performed on the account. 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	ACTION_NOTE_ID	VARCHAR	No
	This column stores the unique identifier for the resultant hospital account note record from this activity.
5	ACTION_COMMENT	VARCHAR	No
	The user entered comment for the action.
6	ACTION_AGENCY_ID	NUMERIC	No
	This column stores the unique identifier for the user-entered agency for the action.
7	ACTION_AGENCY_ID_COLL_AGENCY_NAME	VARCHAR	No
	The name of the collection agency.
8	ACTION_PROC_ID	NUMERIC	No
	This column stores the unique identifier for the user entered procedure for the action.
9	ACTION_DATE	DATETIME	No
	The user entered date for the action.
10	ACTION_ASGN_RSN_C_NAME	VARCHAR	No
	The agency assign reason category number that is set as a result of this action. May contain organization-specific values: Yes No Entries Defined
11	ACTION_WD_RSN_C_NAME	VARCHAR	No
	The agency withdraw reason category number that is set as a result of this action. The category values for this column were already listed for column: ACTION_ASGN_RSN_C_NAME
12	ACTION_PAPRLS_RSN_C_NAME	VARCHAR	No
	Stores the reason the paperless billing status was changed for the associated action May contain organization-specific values: Yes
13	ACTION_TX_ID	NUMERIC	No
	Stores the associated transaction created as a result of a billing activity action.
14	ACTION_AMOUNT	NUMERIC	No
	Stores an amount associated with a performed billing activity action.
15	ACT_NOT_ALLOWED_AMT	NUMERIC	No
	Stores a not allowed amount associated with a performed billing activity action.
16	ACCT_RMV_FROM_TRACKER_ID	NUMERIC	No
	Stores the financial assistance tracker from which the hospital account is removed as part of the billing action.
17	ACCT_ADD_TO_TRACKER_ID	NUMERIC	No
	Stores the financial assistance tracker to which the hospital account is added as part of the billing action.
18	ACTION_LOCATION_ID	NUMERIC	No
	The location that this action set for the account.
19	ACT_RELATED_HAR_TYPE_C_NAME	VARCHAR	No
	The related account type this action changed the account to. May contain organization-specific values: Yes Category Entries: Elective Services ED/Inpatient Split Billing Leave of Absence / Bed Hold Interrupted Stay Separate Service Area Billing Home Infusion Medical Benefits Received Self-Pay Shadow Billing Home Infusion Bypass Other
20	ACTION_ADMIT_DATE	DATETIME	No
	Stores the admit date set through a billing activity action.
21	ACTION_DISCHRG_DATE	DATETIME	No
	Stores the discharge date set through a billing activity action.
22	ACT_RELATED_HAR_ID	NUMERIC	No
	This column stores the unique identifier for the related hospital account created through the Create Related Account billing action.
23	ACT_COMB_HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for a hospital account that was combined or uncombined through a billing activity action.
24	ACT_COMBINE_RSN_C_NAME	VARCHAR	No
	This item tracks the reason that an account was combined May contain organization-specific values: No Category Entries: Combine due to billing Combine due to error System combine due to contact move System combine - recurring series split no longer needed System combine - Home Health/Hospice System combine - replaced voided Hospital Account
25	COMM_MODE_C_NAME	VARCHAR	No
	History of the communication mode used in an account activity. May contain organization-specific values: No Category Entries: Paper Electronic Guarantor Preference
26	ACT_HH_DISCHRG_DISP_C_NAME	VARCHAR	No
	This column stores the patient status (I CLM 1021) value entered for the Override Home Health Discharge Disposition action in an account activity. May contain organization-specific values: Yes
27	ACTION_ACCT_CLASS_C_NAME	VARCHAR	No
	The account class this action changed the account to. May contain organization-specific values: Yes
28	ACTION_START_DATE	DATETIME	No
	History of start date used in a date range of an action.
29	ACTION_END_DATE	DATETIME	No
	History of end date used in a date range of an action.
30	ACT_CODABS_STAT_C_NAME	VARCHAR	No
	The Coding or Abstracting status change made by the action. May contain organization-specific values: Yes Category Entries: Not Started In Progress Waiting Completed Ready To Start On Hold
31	ACT_CDI_STAT_C_NAME	VARCHAR	No
	This column stores the clinical documentation improvement (CDI) status change made by the action. May contain organization-specific values: Yes Category Entries: Not Started In Progress Physician Query All Reviews Completed
32	ACT_CHNG_STAT_CMT	VARCHAR	No
	The comment associated with the change made by the action.
33	ACT_ASGN_USER_ID	VARCHAR	No
	This column stores the Coding, Abstracting, or Clinical Documentation Improvement user assignment made by the action.
34	ACT_ASGN_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
35	ACTION_DAY_OF_MONTH	INTEGER	No
	The day of month that was selected when the action was performed.
36	ACTION_CARD_ID	NUMERIC	No
	The payment method that was selected when the action was performed.
37	ACT_BILL_TYPE_C_NAME	VARCHAR	No
	Indicates how the account was billed. (Date Range, Cumulative, Part A Final) May contain organization-specific values: No Category Entries: Date Range Billing Cumulative Billing Part A Final Billing Default System Billing Selective Billing Rebill Unbilled Date Ranges Days to Bill Extension
38	ACT_CONTEST_RSN_C_NAME	VARCHAR	No
	Shows why the account was contested. May contain organization-specific values: Yes Category Entries: Account Has Contested Charges Patient Not Seen Bankruptcy Legal Deceased Not Informed Service Not Covered Service Not Provided Insurance Appeal Patient Grievance Other
39	ACT_CONTEST_RESOLUTION_RSN_C_NAME	VARCHAR	No
	Holds why the account's contested status was resolved. May contain organization-specific values: Yes Category Entries: Transfer All Charges Resolved Contested in Error Confirmed Billed Correctly Patient No Longer Contesting Insurance Issue Resolved Problem Fixed
40	ACTION_COVERAGE_ID	NUMERIC	No
	This column stores the unique identifier for the new coverage for the Professional Billing Next Responsible Party (PB NRP) action and the unique identifier for the current coverage for the PB Transfer to Insurance action.
41	ACTION_NAA_WRITE_OFF_ID	NUMERIC	No
	This item stores the code that is used to write-off not allowed amount.
42	ACTION_BASE_AMOUNT	NUMERIC	No
	This item stores the base amount set through by a billing activity (ATM) action (for actions with a second, calculated amount).
43	ACTION_PERCENT	NUMERIC	No
	This item stores the percent used by a billing activity (ATM) action.
44	ACT_LATE_CHG_OPTION_C_NAME	VARCHAR	No
	The late charge processing type that was performed on an account May contain organization-specific values: No Category Entries: Late Replacement Late Charge Claim Late Charge Write-Off Late Addition
45	ACTION_NUM_OF_PMTS	INTEGER	No
	The number of payments entered into the billing activity.
46	ACTION_STMT_DAY_OF_MONTH	INTEGER	No
	The statement day of the month entered into the billing activity.
47	ACT_ACCT_MAN_SPLIT_RSN_C_NAME	VARCHAR	No
	The manual split account reason that a billing action set for the account. May contain organization-specific values: Yes Category Entries: Step-Down Level of Care Step-Up Level of Care Part A Benefits Exhaust New Coverage Effective Coverage No Longer Effective Leave of Absence Out Leave of Absence Return
48	ACTION_RESEARCH_ID	VARCHAR	No
	The study associated with this action.
49	ACTION_NUM_OF_CHGS	INTEGER	No
	The number of charges associated with the action.
50	ACTION_SP_DSCNT_OV_RSN_C_NAME	VARCHAR	No
	This column stores the billing follow-up history item for tracking the self-pay discount override reason if the account is not insured. May contain organization-specific values: Yes Category Entries: Other
51	ACTION_SP_DSNT_IOV_RSN_C_NAME	VARCHAR	No
	This column stores the billing follow-up history item for tracking the self-pay discount override reason if the account is insured. May contain organization-specific values: Yes Category Entries: Other
52	ACT_WRITE_OFF_BALANCE_YN	VARCHAR	No
	Whether to write off the entire balance May contain organization-specific values: No Category Entries: No Yes
53	ACT_REFERENCE_NUMBER	VARCHAR	No
	Stores the reference number
54	ACTION_EMAIL	VARCHAR	No
	Stores the email from the activity when the notification was sent.
55	ACTION_PHONE_NUMBER	VARCHAR	No
	Stores the phone number from the activity when the notification was sent.
56	ACT_DATE_FLTR_TYPE_C_NAME	VARCHAR	No
	This item describes how the start and end dates were interpreted when filtering transactions on a detail bill. May contain organization-specific values: No Category Entries: Transaction Service Dates Transaction Post Dates Hospital Account Admit/Discharge Dates
57	ACTION_PRINT_ID	NUMERIC	No
	The statement or detail bill ID created by the action. For example, for Send Statement this is the statement that was printed. For Send Detail Bill, this is the detail bill that was printed. If the user chooses to print later, then this will be blank until the statement/detail bill run is accepted. This may never be set if the statement/detail bill is removed from the queue before it is printed.
58	ACT_SELF_PAY_EXEMPT_RSN_C_NAME	VARCHAR	No
	The self-pay charge exemption reason category ID for the hospital account. May contain organization-specific values: Yes
59	ACT_CONS_SP_WITHDRAWAL_RSN_C_NAME	VARCHAR	No
	The consolidated self-pay account withdrawal reason that is set as the result of this action. May contain organization-specific values: Yes Category Entries: Created in Error Account Combine Sent to PB bad debt in non-SBO AR Service Area. Conversion Utility
60	ACT_SP_LEVEL_CHANGE_C_NAME	VARCHAR	No
	Stores the self-pay follow-up level change (increment/decrement) for the associated action. May contain organization-specific values: No Category Entries: Increment Decrement Specific Level
61	ACT_INTERIM_START_DT_TYPE_C_NAME	VARCHAR	No
	The start date category used for interim billing May contain organization-specific values: No Category Entries: Admit Date Last Interim Bill Date Part B Only Begin Date (Part A Exhausted)
62	ACT_INTERIM_END_DT_TYPE_C_NAME	VARCHAR	No
	The end date category used for interim billing May contain organization-specific values: No Category Entries: Discharge Date Number of Days Part A Exhaust Date/Number of Days Recent End of Month Recent Fiscal Year End Recent End of Year Recent End of Week Latest Billable Date (Today - Min Days - 1) Monthly Last Day of Month Part A Exhaust Date Number of Days Since Inpatient Admission
63	ACT_INTERIM_DAYS_NUM	INTEGER	No
	The number of days used for interim billing
64	ACT_INTERIM_CATCHUP_YN	VARCHAR	No
	Whether or not catch up was performed for interim billing The category values for this column were already listed for column: ACT_WRITE_OFF_BALANCE_YN
65	ACT_SELECTIVE_BILLING_RULE_ID	VARCHAR	No
	The Hospital Transaction rule used for Selective Billing
66	ACT_SELECTIVE_BILLING_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
67	ACT_PAYER_ID	NUMERIC	No
	Stores the record ID of the payer used in billing actions
68	ACT_NUM_DAYS	INTEGER	No
	The number of days used in the billing action