|
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. |
|
|