FIN_ASST_TRACKER
Description:
This table contains information related to a financial assistance program tracker record.

Primary Key
Column Name Ordinal Position
FIN_ASST_TRACKER_ID 1

Column Information
Name Type Discontinued?
1 FIN_ASST_TRACKER_ID NUMERIC No
The unique identifier for the financial assistance program tracker 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 FIN_ASST_PROGRAM_ID NUMERIC No
The unique ID of the financial assistance program that is associated with this tracker record.
4 FIN_ASST_PROGRAM_ID_PROGRAM_NAME VARCHAR No
The name of the financial assistance program record.
5 FIN_ASST_CASE_ID NUMERIC No
This item stores the financial assistance case associated with the program tracker.
6 PAT_ID VARCHAR No
The unique ID of the patient associated with this tracker record.
7 STATUS_C_NAME VARCHAR No
The category ID of the status of a financial assistance program tracker record.
May contain organization-specific values: Yes
Category Entries:
Pending
Approved
Denied
Waiting for supervisor's approval
Pending Appeal
Overturned
Inactive
Entered in Error
Signed
Needs Review
8 DECISION_DATE DATETIME No
Stores the decision date once the tracker has been approved or denied. The date on which a decision is taken whether to approve or deny the financial assistance program tracker.
9 START_DATE DATETIME No
The date from which this approved financial assistance program tracker is effective.
10 END_DATE DATETIME No
The date until which this approved financial assistance program tracker is effective.
11 LETTER_SENT_STATUS_C_NAME VARCHAR No
This item stores the status of an approval or denial letter sent for a tracker.
May contain organization-specific values: Yes
Category Entries:
Sent
Not Sent
In Progress
12 APPL_RECVD_DATE DATETIME No
Date the application was submitted. May or may not be the same date the application was entered as a tracker.
13 PROGRAM_SOURCE_C_NAME VARCHAR No
The source classification of the entity providing funding for the financial assistance program.
May contain organization-specific values: Yes
14 PROGRAM_METHOD_C_NAME VARCHAR No
The method used by the assistance program to provide financial assistance to the patient (e.g. Free drug, co-pay card).
May contain organization-specific values: Yes
Category Entries:
Free Drug
Stock Replacement
Grant
Co-Pay Card
15 DENIAL_REASON_C_NAME VARCHAR No
This item stores the reason why a financial assistance tracker is denied.
May contain organization-specific values: Yes
Category Entries:
Over Income Threshold
Incomplete Application or Documentation
Qualified for Other Assistance Programs
Qualified for Medicaid
Automatically Denied
16 APPROVAL_TYPE_C_NAME VARCHAR No
This item stores the amount, type, or level of approval for a financial assistance program tracker.
May contain organization-specific values: Yes
Category Entries:
Full Approval
80 Percent approval
Half Approval
Automatic Approval
17 TOTAL_APPROVED_AMOUNT NUMERIC No
The total amount of aid approved for a financial assistance program.
18 PENDING_COVERAGE_ID NUMERIC No
The unique ID of the coverage auto-created for the tracker.
19 FOLLOW_UP_DATE DATETIME No
Date on which a user should follow-up for the tracker.
20 PRIMARY_SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
21 DAILY_PAY_AMOUNT NUMERIC No
Patient's daily pay amount for a hospital stay calculated taking their income, expenses, assets, and other financial information into consideration.
22 WRT_OFF_LAST_UPDATE_UTC_DTTM DATETIME (UTC) No
The instant that the write-off amounts for the tracker were last updated.
23 WRT_OFF_HB_SELF_PAY_AMOUNT NUMERIC No
The hospital billing self-pay amount written off as a result of approving the tracker.
24 WRT_OFF_HB_FIN_ASST_AMOUNT NUMERIC No
The hospital billing financial assistance amount written off as a result of approving the tracker.
25 WRT_OFF_PB_SELF_PAY_AMOUNT NUMERIC No
The professional billing self-pay amount written off as a result of approving the tracker.
26 WRT_OFF_PB_FIN_ASST_AMOUNT NUMERIC No
The professional billing financial assistance amount written off as a result of approving the tracker.