ACCT_PP_HAR_LIST_REPL

Description: |
The hospital account ID lists that are associated with payment plans attached to guarantor accounts.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ACCT_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
This column stores the unique identifier for the guarantor record.
2 | GROUP_LINE | INTEGER | No |
The line number of the associated payment plan in this guarantor account's record. Together with ACCT_ID, this forms the foreign key to the HSP_GUAR_PMT_PLAN table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple hospital account IDs that are associated with the guarantor account and the payment plan from the HSP_GUAR_PMT_PLAN table.
4 | HB_PP_HAR | NUMERIC | No |
This column stores the unique identifier for the hospital account that is associated with this guarantor account and payment plan.