|
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 |
NUMERIC |
No |
|
|
|
| The unique ID of the service area in which this financial assistance case record was created. |
|
|
| 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 |
|
|
| 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. |
|
|
