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.