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.