HSP_ACCT_EXPECTED_WRT_OFF

Description:

The write-off amounts for pending financial assistance trackers linked to the hospital account.

Primary Key

Column Name	Ordinal Position
HSP_ACCT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCT_ID	NUMERIC	No
	The unique identifier (.1 item) for the account 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	FIN_ASST_TRACKER_ID	NUMERIC	No
	Financial assistance tracker used to calculate expected write-off amounts.
4	LAST_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	Instant the write-off amounts were calculated for this financial assistance tracker.
5	EXPECTED_SELF_PAY_WRITE_OFF	NUMERIC	No
	Self-pay write-off amount the financial assistance tracker would be responsible for writing off if it were to be approved.
6	EXPECTED_FIN_ASST_WRITE_OFF	NUMERIC	No
	Financial assistance-specific write-off amount the tracker would be responsible for writing off if it were to be approved.
7	FPL_PERCENTAGE	NUMERIC	No
	The federal poverty level (FPL) percentage at the time of the write-off calculation.
8	WRITE_OFF_SCENARIO	VARCHAR	No
	The discounting scenario from the financial assistance program that was used for the write-off calculation.
9	WRITE_OFF_RULE_ID	VARCHAR	No
	The matching rule for the discounting scenario from the financial assistance program that was used for the write-off calculation.
10	WRITE_OFF_RULE_ID_RULE_NAME	VARCHAR	No
	The name of the rule.
11	WRITE_OFF_LPP_ID	NUMERIC	No
	The discounting extension from the financial assistance program that was used for the write-off calculation.
12	WRITE_OFF_LPP_ID_LPP_NAME	VARCHAR	No
	The name of the extension.