HSP_GUAR_PMT_PLAN_REPL

Description: |
This table contains hospital guarantor payment plan information.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
GUAR_ACCOUNT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | GUAR_ACCOUNT_ID | NUMERIC | No |
The unique ID of the guarantor account 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 | PP_START_DATE | DATETIME | No |
The Hospital Billing payment plan start date.
4 | PP_INIT_BAL | NUMERIC | No |
Hospital Billing Payment plan initial balance
5 | PP_AMT | NUMERIC | No |
Hospital Billing Payment plan monthly payment amount
6 | PP_NUM_PMTS | INTEGER | No |
Hospital Billing Payment plan number of payments
7 | PP_EFF_INST_DTTM | DATETIME (UTC) | No |
The instant the payment plan was set up (UTC).
8 | PP_TERMS_TYPE_C_NAME | VARCHAR | No |
The term type (monthly amount or number of payments) the payment plan was created with.
May contain organization-specific values: No
Category Entries:
Monthly Amount
Number of Payments
9 | PP_ORIG_PLAN_LINE | INTEGER | No |
Holds the original plan line in the related group if the current line is an update. If the current line is a new plan, the item is null.
10 | PP_STMT_DAY_OF_MO | INTEGER | No |
Stores the day of month to process statements for a payment plan with Auto Pay.
11 | CARD_ID | NUMERIC | No |
Stores the payment method ID for Hospital Billing payment plans on Auto Pay.
12 | PP_APAY_DAY_OF_MO | INTEGER | No |
Stores the day of month to charge the payment method on file and post a payment on the guarantor. This item forces statement cycle for monthly drop cycle.
13 | PP_CREATE_USER_ID | VARCHAR | No |
Stores the ID of the user in Epic who set up this payment plan. If this item is populated, then the system knows this plan was set up by a user via Hyperspace.
14 | PP_CREATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
15 | PP_CREATE_MYPT_ID | VARCHAR | No |
Stores the MyChart user who set up this payment plan. If this item is populated, then the system knows this plan was set up by a guarantor via MyChart rather than through customer service in Hyperspace.
16 | PP_SOURCE_C_NAME | VARCHAR | No |
Stores the source workflow that set up this payment plan.
May contain organization-specific values: No
Category Entries:
Hyperspace
MyChart Web
MyChart Mobile
SBO Conversion
Import Utility
Welcome
System Action
Advance Bill
Two-Way SMS
Consolidated Balances Conversion
Virtual Assistant
17 | PP_INIT_DUE_AMT | NUMERIC | No |
Stores the payment plan due amount for the guarantor after the plan is setup.