|
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. |
|
|