HSP_BFH_ACT_DATA_2
Description:
This table stores billing activity history action-specific data.

Primary Key
Column Name Ordinal Position
BFH_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 BFH_ID NUMERIC No
The unique identifier (.1 item) for the 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 ACT_WAS_FORCED_YN VARCHAR No
Stores whether the action was forced by a user or not.
May contain organization-specific values: No
Category Entries:
No
Yes
4 ACTION_PREV_GUAR_ACCT_ID NUMERIC No
Stores the guarantor on the account before the action was performed.
5 ACTION_CUR_GUAR_ACCT_ID NUMERIC No
Stores the guarantor on the account after the action was performed.
6 ACT_LATE_CHG_OPT_C_NAME VARCHAR No
This item holds the late charge selection option chosen for processing late charges. The default is 0-All Prebilled Charges.
May contain organization-specific values: No
Category Entries:
All Unbilled Charges
Date Range Selection
7 BILL_DT_RNG_SEL_MTHD_C_NAME VARCHAR No
This item holds the date range selection method used to default the date ranges when date range billing.
May contain organization-specific values: No
Category Entries:
Bill Selected Date Range
Auto-Split by Cvg Effective Dates
8 ACT_GUARANTOR_TYPE_C_NAME VARCHAR No
The guarantor type used to automatically select the guarantor in a Change Guarantor action
May contain organization-specific values: Yes
Category Entries:
Other
Personal/Family
Non-Employed CRNA
Case Rate
Clearing Account
Trust Account
Delegated Billing
ROI Requester
Invalid
9 ACTION_VOICE_NUMBER VARCHAR No
The phone number that was selected for voice when the action was performed.