FIN_ASST_TRKR_UPDATE_HX

Description: |
This table contains information related to the financial assistance tracker record's update history.
Whenever any of the following details of a program tracker are changed or added, a row is added to this table.
1. Status
2. Decision date
3. Approval start date
4. Approval end date
5. Note
6. Source
7. Method
8. Medications.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FIN_ASST_TRACKER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FIN_ASST_TRACKER_ID | NUMERIC | No |
The unique identifier for the financial assistance program tracker record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | UPDATE_UTC_DTTM | DATETIME (UTC) | No |
The instant when the update was made.
4 | UPDATE_USER_ID | VARCHAR | No |
The unique ID of the user who made the update.
5 | UPDATE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | UPDATE_STATUS_C_NAME | VARCHAR | No |
The category ID of the program tracker status after the update was made.
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
7 | UPDATE_DECISION_DATE | DATETIME | No |
The decision date after the update was made.
8 | UPDATE_START_DATE | DATETIME | No |
The approval start date after the update was made.
9 | UPDATE_END_DATE | DATETIME | No |
The approval end date after the update was made.
10 | UPDATE_NOTE | VARCHAR | No |
The note added when the update was made.
11 | UPDATE_RESP_USER_ID | VARCHAR | No |
History of Responsible User (I FNT 58).
12 | UPDATE_RESP_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
13 | UPDATE_PROGRAM_SOURCE_C_NAME | VARCHAR | No |
History of the source specified for this program tracker after an update was made to the tracker.
May contain organization-specific values: Yes
14 | UPDATE_PROGRAM_METHOD_C_NAME | VARCHAR | No |
History of the method specified for this program tracker after an update was made to the tracker.
May contain organization-specific values: Yes
Category Entries:
Free Drug
Stock Replacement
Grant
Co-Pay Card
15 | UPDATE_NOTE_ID | VARCHAR | No |
ID of the note record that contains the comment entered as part of the update.
16 | REG_HX_EVENT_ID | NUMERIC | No |
Prelude history event containing more metadata about this entry.