FIN_ASST_CASE
Description:
This table contains basic information about a financial assistance case record.

Primary Key
Column Name Ordinal Position
FIN_ASST_CASE_ID 1

Column Information
Name Type Discontinued?
1 FIN_ASST_CASE_ID NUMERIC No
The unique identifier for the financial assistance case record.
2 RECORD_STATUS_C_NAME VARCHAR No
Stores the record status (hidden, soft-deleted, etc...)
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 EXTERNAL_ID INTEGER No
This column stores the external unique identifier for a financial assistance case record.
4 SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
5 APPL_PROVIDED_DATE DATETIME No
The date a financial assistance application was provided to the patient.
6 APPL_SIGNED_DATE DATETIME No
The date a completed and signed financial assistance application was submitted by the patient.
7 FAMILY_SIZE INTEGER No
The size of the patient's family when this case was created.
8 PERCENT_FPL NUMERIC No
The percentage of federal poverty level of the patient calculated using income details (stored in FIN_ASST_CASE_INCOME table).
9 PERCENT_FPL_AFTER_EXPENSES NUMERIC No
The percentage of federal poverty level of the patient calculated after subtracting expenses (stored in FIN_ASST_CASE_EXPENSE table) from income details (stored in FIN_ASST_CASE_INCOME table).
10 TOTAL_ANNUAL_INCOME_AFTER_EXP NUMERIC No
The total income after expenses for the patient's household.
11 STATUS_C_NAME VARCHAR No
The status category ID for the financial assistance case record.
May contain organization-specific values: No
Category Entries:
In Progress
Closed
Waiting For Patient
Decided
Completed
12 TOTAL_ANNUAL_INCOME NUMERIC No
Total annual income of the patient's household.
13 ACCOUNT_ID NUMERIC No
The unique ID of the guarantor record associated with the financial assistance case record.
14 PROPENSITY_TO_PAY_C_NAME VARCHAR No
The guarantor propensity to pay category ID for the financial assistance case record.
May contain organization-specific values: Yes
15 CREDIT_SCORE INTEGER No
The guarantor's credit score associated with the financial assistance case record.
16 FIN_ASST_CASE_CRT_SRC_C_NAME VARCHAR No
The way this case record was created.
May contain organization-specific values: No
Category Entries:
User created
MyChart
Social Care
Batch
Background Process
Import
17 MYCHART_USER_ENTERED_CMT VARCHAR No
This column stores the free-text additional information provided with the financial assistance application by patient/requestor through MyChart.
18 CREATED_BY_WPR_ID VARCHAR No
This item stores the user ID of the MyChart user who created this case. Only populated when the case is created through MyChart.
19 CASE_CONTACT_ACCOUNT_ID NUMERIC No
The unique ID of the guarantor account who is the primary contact for this financial assistance case record.
20 TYPE_C_NAME VARCHAR No
The case type category ID for the financial assistance case record.
May contain organization-specific values: No
Category Entries:
Parent
Child
21 CASE_WORKFLOW_C_NAME VARCHAR No
The category ID of the workflow the financial assistance case record is created in.
May contain organization-specific values: Yes
Category Entries:
Financial Assistance
Social Care
Reconciliation
22 FISCAL_YEAR INTEGER No
The fiscal year the financial information in the case record belongs to.
23 NUMBER_OF_DEPENDENTS INTEGER No
Number of dependents the patient for whom this financial assistance case record is for has.
24 FPL_CALCULATION_DATE DATETIME No
The date the federal poverty level stored in PERCENT_FPL and PERCENT_FPL_AFTER_EXPENSES columns was last calculated.
25 NO_INCOME_YN VARCHAR No
Flag that indicates that the household doesn't have any source of income
May contain organization-specific values: No
Category Entries:
No
Yes
26 REQ_LAST_WORKED_UTC_DTTM DATETIME (UTC) No
Last time a patient viewed or edited the financial assistance application in MyChart.
27 DECLINE_ASSIST_UTC_DTTM DATETIME (UTC) No
The instant set after a primary contact declines financial assistance online.
28 ENTITY_DEC_ASST_C_NAME VARCHAR No
The entity that declined a Waiting for Patient financial assistance request.
May contain organization-specific values: No
Category Entries:
Primary Contact
System
29 FIN_ASST_CASE_NAME VARCHAR No
Name of the primary patient on the financial assistance case.
30 REC_CREATION_DATE DATETIME No
Stores the date the record was created
31 SOURCE_FIN_ASST_CASE_ID NUMERIC No
If this case was created and copied from an existing case, this contains the source case that the data was taken from.
32 PAT_FAMILY_SIZE INTEGER No
This item stores the family size entered by the patient.
33 PAT_NO_INCOME_YN VARCHAR No
Flag that indicates that the household doesn't have any source of income entered by the patient.
The category values for this column were already listed for column: NO_INCOME_YN
34 PAT_PERCENT_FPL NUMERIC No
The patient's income percentage, based on income reported by the patient, of the federal poverty level based on family size and annual income.
35 PAT_PERCENT_FPL_AFTER_EXP NUMERIC No
The patient's income percentage, based on income reported by the patient, of the federal poverty level based on family size, annual income, and annual expenses (reported by the patient).
36 PAT_TOTAL_ANNUAL_INCOME NUMERIC No
Total annual income of the patient's household, calculated from the patient reported income.
37 PAT_ANNUAL_INCOME_AFTER_EXP NUMERIC No
Total income after expenses for the patient's household, calculated from the patient reported income and expenses.
38 DECLINE_ASSISTANCE_REASON_C_NAME VARCHAR No
The reason the primary contact declined financial assistance.
May contain organization-specific values: Yes
Category Entries:
No assistance needed
Receiving other assistance
Cancelled visit
Requested in error
Prefer not to say