|
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 |
NUMERIC |
No |
|
|
|
| Primary service area for a financial assistance tracker |
|
|
