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.