FIN_ASST_CASE_EXPENSE
Description:
This table contains expense information related to a financial assistance case 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 EXPENSE_TYPE_C_NAME VARCHAR No
The expense type category ID.
May contain organization-specific values: Yes
4 EXPENSE_FREQ_C_NAME VARCHAR No
The category ID of frequency with which this expense occurs.
May contain organization-specific values: No
Category Entries:
Weekly
Biweekly
Monthly
Annually
5 EXPENSE_AMOUNT NUMERIC No
The expense amount per frequency.
6 EXP_BLNG_PAT_RELATIONSHIP_ID NUMERIC No
The patient contact of one of the patients on the case for whom the expense information in the current row belongs to. If the information belongs to a patient on the case, EXPENSE_BELONGS_TO_PAT_ID column will be set instead.
7 EXPENSE_COMMENT VARCHAR No
A brief comment about the expense information in the current row.