|
Name |
Type |
Discontinued? |
|
1 |
SCHED_PMT_ID |
NUMERIC |
No |
|
|
|
The unique identifier (.1 item) for the scheduled payment record. |
|
|
2 |
PP_INITIAL_DUE_AMT |
NUMERIC |
No |
|
|
|
The amount requested to be paid on this payment plan at the start of the monthly cycle. |
|
|
3 |
PP_INITIAL_OVERPAID_AMT |
NUMERIC |
No |
|
|
|
The amount in which this payment plan was overpaid at the start of the monthly cycle. |
|
|
4 |
PP_INITIAL_OVERDUE_AMT |
NUMERIC |
No |
|
|
|
The overdue amount on this payment plan at the start of the monthly cycle. |
|
|
5 |
PP_REMAINING_DUE_AMT |
NUMERIC |
No |
|
|
|
The outstanding amount for this month on this payment plan. |
|
|
6 |
PP_PAID_AMT |
NUMERIC |
No |
|
|
|
The total amount paid towards the current month's due amount. This number includes payments, reversals, and transfers that affect the due, but will not include adjustments and other non-payment transactions. |
|
|
7 |
PP_OVERPAYMENT_AMT |
NUMERIC |
No |
|
|
|
The amount that is overpaid and accounting for future months. |
|
|
8 |
PP_OVERDUE_AMT |
NUMERIC |
No |
|
|
|
The amount that was unpaid from prior months. |
|
|
9 |
PP_OVERPMT_CONTRIB_MTHD_C_NAME |
VARCHAR |
No |
|
|
|
The category ID of the payment plan overpayment contribution method setting in the hospital billing profile at the time of the payment plan tracker record's creation. |
May contain organization-specific values: No |
Category Entries: |
Remaining Balance |
Future Months |
|
|
10 |
PP_AUTO_PAY_INCL_OVERDUE_YN |
VARCHAR |
No |
|
|
|
Indicates that the Auto Pay payment plan amount should include any overdue balances when processing. This is copied from the hospital billing profile at the time of the payment plan's most recent calculation. A 'Y' indicates that the payment plan should include overdue balances. 'N' indicates that it should not. NULL indicates that this is not an Auto Pay payment plan. |
May contain organization-specific values: No |
Category Entries: |
No |
Yes |
|
|
11 |
PP_PB_UNDIST_PMT_AMT |
NUMERIC |
No |
|
|
|
The total amount of PB payments that have been applied to the payment plan but not yet applied to PB visit accounts on the payment plan. |
|
|