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.