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.