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.