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
39 | PRESCREEN_STATUS_C_NAME | VARCHAR | No |
Status of the pre-screening for the financial assistance case.
May contain organization-specific values: No
Category Entries:
Did Not Qualify
Incomplete
Complete - Not Enough Information
Complete
Complete - Unlikely to be Approved