BILL_SCHED_PMT_PP_HAR
Description:
This table contains information about the hospital accounts on a payment plan record.

Primary Key
Column Name Ordinal Position
SCHED_PMT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SCHED_PMT_ID NUMERIC No
The unique identifier (.1 item) for the scheduled payment 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 HSP_ACCOUNT_ID NUMERIC No
The unique ID of the hospital account that is associated with this payment plan.
4 HAR_INITIAL_BAL NUMERIC No
The initial balance the hospital account contributes to the payment plan.
5 HAR_REMAINING_BAL NUMERIC No
The remaining balance the hospital account contributes to the payment plan.
6 HAR_PLAN_STATUS_C_NAME VARCHAR No
The category ID of the status for this hospital account on the payment plan.
May contain organization-specific values: No
Category Entries:
On Plan
Paid Off
Removed
Estimated
Completed
7 HAR_PLAN_STATUS_UPDATE_DATE DATETIME No
The date the hospital account's status was updated for the payment plan.
8 IS_HAR_BAL_PRORATED_YN VARCHAR No
This column indicates that this hospital account was set up as a prorated payment plan balance. 'Y' indicates that the hospital account was added to this payment plan with custom amounts or amounts from estimate or partial self-pay balances. 'N' or NULL indicates that the hospital account's full self-pay balance was added to the payment plan.
May contain organization-specific values: No
Category Entries:
No
Yes