BILL_SCHED_PMT_PP_HAR_EST
Description:
This table contains pre-service estimates directly linked to hospital accounts that are attached to a payment plan.

Primary Key
Column Name Ordinal Position
SCHED_PMT_ID 1
GROUP_LINE 2
VALUE_LINE 3

Column Information
Name Type Discontinued?
1 SCHED_PMT_ID NUMERIC No
The unique identifier (.1 item) for the scheduled payment record.
2 GROUP_LINE INTEGER No
The line number for the information associated with this record.
3 VALUE_LINE INTEGER No
The line number of one of the multiple values associated with a specific group of data within this record.
4 ESTIMATE_ID NUMERIC No
The unique ID of the estimate record associated with a hospital account on a payment plan.