FIN_ASST_CASE_INCOME

Description:

This table contains income related information of a financial assistance record.

Primary Key

Column Name	Ordinal Position
FIN_ASST_CASE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	FIN_ASST_CASE_ID	NUMERIC	No
	The unique identifier for the financial assistance case 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	INCOME_FREQ_C_NAME	VARCHAR	No
	This column stores the category ID of the frequency with which an income type mentioned in INCOME_TYPE_C is earned. May contain organization-specific values: No Category Entries: Hourly Weekly Biweekly Monthly Annually
4	INCOME_HOURS_PER_WEEK	NUMERIC	No
	If the income frequency (INCOME_FREQUENCY_C) is hourly, then this column stores the number of hours worked in a week.
5	INCOME_AMOUNT	NUMERIC	No
	The income amount earned per frequency.
6	INCOME_TYPE_C_NAME	VARCHAR	No
	This column stores the category ID of the type of income being earned. May contain organization-specific values: Yes
7	INC_BLNG_PAT_RELATIONSHIP_ID	NUMERIC	No
	The patient contact of one of the patients on the case for whom the income information in the current row belongs to. If the information belongs to a patient on the case, INCOME_BELONGS_TO_PAT_ID column will be set instead.
8	INCOME_COMMENT	VARCHAR	No
	A brief comment about the income information in the current row.