BILLING_NOTIF_GUARANTOR
Description:
This table contains information about guarantor billing notifications.

Primary Key
Column Name Ordinal Position
OUTREACH_ID 1
CONTACT_DATE_REAL 2

Column Information
Name Type Discontinued?
1 OUTREACH_ID NUMERIC No
The unique identifier (.1 item) for the outreach record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact while the digits after the decimal are unique and distinguish each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 OUTREACH_CSN_ID NUMERIC No
The unique contact serial number (CSN) of the associated notification in the communication record.
5 HB_SELF_PAY_BAL NUMERIC No
This column stores the HB self-pay balance of the guarantor when the notification was sent.
6 PB_SELF_PAY_BAL NUMERIC No
This column stores the PB self-pay balance of the guarantor when the notification was sent.
7 TOTAL_SELF_PAY_BAL NUMERIC No
This column stores the total self-pay balance of the guarantor when the notification was sent.
8 HB_FULL_SELF_PAY_BAL NUMERIC No
This column stores the self-pay balance of the HB hospital accounts that were fully in self-pay, and had no insurance balance when the notification was sent.
9 PB_FULL_SELF_PAY_BAL NUMERIC No
This column stores the self-pay balance of the PB hospital accounts/charges that were fully in self-pay, and had no insurance balance when the notification was sent.
10 TOTAL_FULL_SELF_PAY_BAL NUMERIC No
This column stores the total self-pay balance of HB hospital accounts and PB hospital accounts/charges that were fully in self-pay, and had no insurance balance when the notification was sent.
11 PP_PROPOSED_MONTHLY_AMT NUMERIC No
If the guarantor meets the restrictions for setting up payment plans from MyChart, this column will store the proposed monthly amount that will be shown if they were to sign up for a payment plan. If eligible, the payment plan proposals will be included in statement, balance update, and payment reminder notification.
12 PP_PROPOSED_NUM_PMTS INTEGER No
If the guarantor meets the restrictions for setting up payment plans from MyChart, this column will store the proposed number of payments that will be shown if they were to sign up for a payment plan. If eligible, the payment plan proposals will be included in statement, balance update, and payment reminder notification.
13 HB_NON_PMT_PLAN_BAL NUMERIC No
If the guarantor is on a HB/SBO payment plan, this column stores the self-pay balance that is not on a payment plan. If the guarantor is not on a payment plan, this column will store the total self-pay balance of the notification line.
14 ACTION_AMT NUMERIC No
This column stores the amount the guarantor is able to take a payment action on at the time the notification was sent. For example, a guarantor using Two-Way via SMS to pay off their payment plan due.