FIN_ASST_INFO

Description:

This table contains financial assistance information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account.
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
	Stores the financial assistance tracker associated with the hospital account.
4	FIN_ASST_EXCL_YN	VARCHAR	No
	Stores if the hospital account is not eligible for financial assistance. May contain organization-specific values: No Category Entries: No Yes
5	FIN_ASST_SOURCE_C_NAME	VARCHAR	No
	Stores the source of the financial assistance information on the hospital account. May contain organization-specific values: No Category Entries: User System Charge Router Handler
6	FIN_ASST_UPDATE_USER_ID	VARCHAR	No
	Stores the user who last updated the financial assistance tracker on the hospital account.
7	FIN_ASST_UPDATE_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	FIN_ASST_UPDATE_DTTM	DATETIME (UTC)	No
	Stores the instant at which the user updated the financial assistance tracker on the hospital account.