BILL_SCHED_PP_ACTION_HX

Description: |
This table contains information about actions performed on a payment plan.

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 | ACTION_UTC_DTTM | DATETIME (UTC) | No |
The UTC date and time that an action occurred on the payment plan.
4 | ACTION_DTTM | DATETIME (Local) | No |
The local date and time that an action occurred on the payment plan.
5 | PMT_PLAN_ACTION_TYPE_C_NAME | VARCHAR | No |
The category ID of the payment plan history action type.
May contain organization-specific values: No
Category Entries:
Void Charge
Void Pmt/Adj
Reverse Pmt/Adj
Distribute
Undistribute
Post Plan Payment
Undistribute to Plan
Distribute From Plan
Adjust Plan Balance
6 | PB_PMT_ADJ_TX_ID | NUMERIC | No |
The unique ID of the professional billing payment or credit adjustment associated with this payment plan history action.
7 | PB_CHARGE_TX_ID | NUMERIC | No |
The unique ID of the professional billing charge associated with this payment plan history action.
8 | PB_MATCH_LINE_NUM | INTEGER | No |
The unique ID of the professional billing payment match line associated with this payment plan history action.
9 | HB_PMT_ADJ_TX_ID | NUMERIC | No |
The unique ID of the hospital billing payment or credit adjustment associated with this payment plan history action.
10 | PB_ORIG_PMT_ADJ_TX_ID | NUMERIC | No |
The unique ID of the original professional billing payment or credit adjustment associated with this payment plan history action. If the hospital or professional billing payment or credit adjustment was transferred from professional billing originally, this is the original transaction. Otherwise, this is the same as the professional billing payment or credit adjustment.
11 | HB_ORIG_PMT_ADJ_TX_ID | NUMERIC | No |
The unique ID of the original hospital billing payment or credit adjustment associated with this payment plan history action. If the hospital or professional billing payment or credit adjustment was transferred from hospital billing originally, this is the original transaction. Otherwise, this is the same as the hospital billing payment or credit adjustment.
12 | APPLIED_AMT | NUMERIC | No |
The payment/credit adjustment amount applied to the payment plan balance. A positive number reduces the balance and a negative number increases the balance.
13 | APPLIED_TO_DUE_AMT | NUMERIC | No |
The payment/credit adjustment amount applied to the payment plan due amount. A positive number reduces the due amount and a negative number increases the due amount.