ARPB_TX_FIN_ASST

Description:

Financial Assistance Related Items for Transactions. This table has information that is populated by financial assistance workflows.

Primary Key

Column Name	Ordinal Position
TX_ID	1

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction record.
2	PROGRAM_ID	NUMERIC	No
	The financial assistance program applied on this charge line.
3	PROGRAM_ID_PROGRAM_NAME	VARCHAR	No
	The name of the financial assistance program record.
4	DISCOUNT_PCT	NUMERIC	No
	The discount percentage applied to this charge line from financial assistance.
5	FLAT_FEE_AMT	NUMERIC	No
	The applied flat fee for this charge line from financial assistance.
6	MIN_FEE_AMT	NUMERIC	No
	The applied minimum fee on this charge line from financial assistance.
7	FEE_SCHEDULE_ID	NUMERIC	No
	The fee schedule on this charge line used to determine the financial assistance discount amount.
8	FEE_SCHEDULE_ID_FEE_SCHEDULE_NAME	VARCHAR	No
	The name of each fee schedule.
9	DISCOUNT_AMT	NUMERIC	No
	The discount amount from financial assistance calculations.
10	FPL_PCT	NUMERIC	No
	The Federal Poverty Level (FPL) percentage used in financial assistance calculations.
11	FIN_ASST_TRACKER_ID	NUMERIC	No
	The unique identifier of the financial assistance tracker that discounted this transaction.